Why only dbo schema tables are loading into Hive when we use import-all-tables.

[#1]

How can we load other than dbo schema tables into Hive by using hive import-all-tables command.

[#2]

Try to pass --schema schemaname argument, alternatively, specify database and schema in your jdbc URL

sqoop import ... --table custom_table -- --schema custom_schema

[#3 · Accepted solution]

@srinivasa rao

This is a limitation with sqoop as only default schema under the userid would be used for extracting all the tables with sqoop import-all-tables. Workaround is to import tablewise using sqoop import.