Sqoop import all tables in hive, specifying database

I am not sure if there is an option to specify target database in hive, while I am loading all tables using sqoop.
I am using -

sqoop import-all-tables --connect “jdbc:mysql://nn01.itversity.com:3306/retail_db” --username retail_dba --password itversity --hive-import --hive-overwrite

–hive-database option can be used to specify the database

1 Like

I wonder why this option is not given in sqoop documentation? I will try and respond.

1 Like

Yes, I am also surprised. But this is quite common with open source technologies.

And by the way --hive-database option did work out.