How to use a specified Hive database when using Sqoop import

hadoop hive sqoop
JustFF picture JustFF · Mar 21, 2013 · Viewed 18.9k times · Source 
sqoop import --connect jdbc:mysql://remote-ip/db --username xxx --password xxx --table tb --hive-import

The above command imports table tb into the 'default' Hive database.

Can I use other database instead?

Answer

Mark Vickery picture Mark Vickery · Mar 21, 2013

Off the top of my head i recall you can specify --hive-table foo.tb

where foo is your hive database and tb is your hive table.

so in your case it would be:

sqoop import --connect jdbc:mysql://remote-ip/db --username xxx --password xxx --table tb --hive-import --hive-table foo.tb

As a footnote, here is the original jira issue https://issues.apache.org/jira/browse/SQOOP-322

Related questions

Using Sqoop to import data from MySQL to Hive

I am using Sqoop (version 1.4.4) to import data from MySQL to Hive. The data will be a subset of one of tables, i.e. few columns from a table. Is it necessary to create table in Hive before hand. Or …

Read More
Multiple table join in hive

I have migrated Teradata tables' data into hive . Now I have to build summary tables on top of imported data. Summary table needs to be built from five source tables If I go with joins I'll need to join five …

Read More
Sqoop: Could not load mysql driver exception

I Installed Sqoop in my local machine. Following are the config information. Bash.bashrc: export HADOOP_HOME=/home/hduser/hadoop export HBASE_HOME=/home/hduser/hbase export HIVE_HOME=/home/hduser/hive export HCAT_HOME=/home/hduser/hive/hcatalog export …

Read More