How to use a specified Hive database when using Sqoop import

hadoop, hive, sqoop

Solution

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

Problem

``` 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?

Original source