Support Questions
Find answers, ask questions, and share your expertise

sqoop import of tables with space in table name

Contributor

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 

1 ACCEPTED SOLUTION

Contributor

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

View solution in original post

1 REPLY 1

Contributor

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

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.