question sqoop import of tables with space in table name in Support Questions

sqoop import of tables with space in table name

sow — Mon, 11 Nov 2019 13:41:53 GMT

Sqoop import fails while importing tables that has space and special characters in the table name.

command used:

sqoop import --connect <> --username <> --password <> --table "employee details information" --as-parquetfile --delete-target-dir --target-dir /hdfs/dir/ --m 1

Re: sqoop import of tables with space in table name

sow — Mon, 25 Nov 2019 08:30:16 GMT

using the query option helped.

solution :

sqoop import --connect <> --username <> -password <> --as-parquetfile --delete-target-dir --target-dir /hdfs/dir/ --query "select * from [DB_SCHEMA_NAME].[table_name] where \$CONDITIONS;" --m 1