How to import tables into Hive from Sqoop

Question

Hi. I need to import a table from MySql to Hive. How to tell sqoop that the table should be imported to Hive instead of any other file system?

P.S.:By default it is getting imported to HDFS

Answer 1

Very simple, in your sqoop command that you are using to import the table, add the below switch:

--hive-import

Now the table will be imported into Hive