Hope you are doing great!

Please find the screenshots for import, export and create hive table command. 

Create Table:

image


image


Sqoop command for creating Hive table:

image
image

Now open the hive shell and check to find the emp table.

image
 
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
 

image

image
 
image

image


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


 
image
image

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.