sqoop import of tables with space in table name

[#1]

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 

[#2 · Accepted solution]

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