Hope you are doing great!
Please find the screenshots for import, export and create hive table command.
Create Table:
Sqoop command for creating Hive table:
Now open the hive shell and check to find the emp table.
Import:
1. First create a table and insert data to it
=> use edureka;
=> create table student(name varchar(20));
=> insert into student values("kamini");
=> select * from student;
sqoop import --connect jdbc:mysql://mysqldb.edu.cloudlab.com/edureka --table student --username labuser -P -target-dir /user/edureka_354973/output -m 1
Export:
=> First create a table
=> use edureka;
=> create table sample(word varchar(30));
=> Now create an input file and copy to hdfs
=> hdfs dfs -put inputfile /user/edureka_354973
sqoop export --connect jdbc:mysql://mysqldb.edu.cloudlab.com/edureka --table sample --username labuser -P -export-dir /user/edureka_354973/inputdata -m 1
Please note, give new names to your output directories or output files.
Please try it once from your side and let us know whether it worked or not.
Will be waiting for your response.