question Re: Why only dbo schema tables are loading into Hive when we use import-all-tables. in Archives of Support Questions (Read Only)

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

gsrao_cse — Tue, 16 Aug 2016 20:02:57 GMT

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

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

aervits — Tue, 16 Aug 2016 21:03:11 GMT

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

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

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

ssubhas — Tue, 16 Aug 2016 21:30:07 GMT

@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.