question Re: sqoop import all tables into HDFS in Archives of Support Questions (Read Only)

sqoop import all tables into HDFS

cherukuri_49 — Mon, 19 Aug 2019 10:23:37 GMT

Hi,

I have 4 tables in Mysql DB, I can able to import single table to HDFS, but when I try to import all 4 tables using below command i am getting error as shown below

sqoop-import-all-tables --connect jdbc:mysql://192.168.0.32:3306/database1 --username hive --password hive --target-dir '/user/tsldp/patelco/' --m 1

Thanks,

Sagar.

Re: sqoop import all tables into HDFS

StevenONeill — Wed, 11 Jan 2017 05:10:27 GMT

@sagar pavan, instead of using:

--target-dir '/user/tsldp/patelco/'

try:

--warehouse-dir '/user/tsldp/patelco/'

Each table will then be in a subdirectory under '/user/tsldp/patelco/'

Cheers, Steven.

Re: sqoop import all tables into HDFS

cherukuri_49 — Wed, 11 Jan 2017 12:44:18 GMT

Thanks Steven for your answer