Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Sqoop Import failed: No column by the name ConferenceDisplayNameListfound

Sqoop Import failed: No column by the name ConferenceDisplayNameListfound

Explorer

Command: 

sqoop import \
-Dhadoop.security.credential.provider.path=jceks://hdfs/user/lrm0613/mydb1.jceks \
--connect 'jdbc:jtds:sqlserver://SQLQP002:1433;useNTLMv2=true;domain=JNL_NT;databaseName=TC31Reporting' \
--username 'lrm0613' -P \
--target-dir /data/DataEngSandbox/Hive \
--delete-target-dir \
--query 'select JobId from JobHistory where $CONDITIONS' \
--compress \
--compression-codec snappy \
--map-column-java MCUNameList=String,ConferenceDisplayNameList=String \
--verbose \
-m 1 \
--create-hcatalog-table \
--hcatalog-storage-stanza 'stored as parquet'

 

Result:

Enter password:
20/04/03 14:51:55 WARN tool.BaseSqoopTool: --hcatalog-storage-stanza option will be ignored without --hatalog-table
20/04/03 14:51:55 DEBUG sqoop.ConnFactory: Loaded manager factory: org.apache.sqoop.manager.oracle.OraOopManagerFactory
20/04/03 14:51:55 DEBUG sqoop.ConnFactory: Loaded manager factory: com.cloudera.sqoop.manager.DefaultManagerFactory
20/04/03 14:51:55 DEBUG sqoop.ConnFactory: Trying ManagerFactory: org.apache.sqoop.manager.oracle.OraOopManagerFactory
20/04/03 14:51:56 DEBUG oracle.OraOopManagerFactory: Data Connector for Oracle and Hadoop can be called by Sqoop!
20/04/03 14:51:56 DEBUG sqoop.ConnFactory: Trying ManagerFactory: com.cloudera.sqoop.manager.DefaultManagerFactory
20/04/03 14:51:56 DEBUG manager.DefaultManagerFactory: Trying with scheme: jdbc:jtds:sqlserver:
20/04/03 14:51:56 INFO manager.SqlManager: Using default fetchSize of 1000
20/04/03 14:51:56 DEBUG sqoop.ConnFactory: Instantiated ConnManager org.apache.sqoop.manager.SQLServerManager@7995092a
20/04/03 14:51:56 INFO tool.CodeGenTool: Beginning code generation
20/04/03 14:51:56 DEBUG manager.SqlManager: Execute getColumnInfoRawQuery : select JobId from JobHistory where (1 = 0)
20/04/03 14:51:56 DEBUG manager.SqlManager: No connection paramenters specified. Using regular API for making connection.
20/04/03 14:51:56 DEBUG manager.SqlManager: Using fetchSize for next query: 1000
20/04/03 14:51:56 INFO manager.SqlManager: Executing SQL statement: select JobId from JobHistory where (1 = 0)
20/04/03 14:51:56 DEBUG manager.SqlManager: Found column JobId of type [4, 10, 0]
20/04/03 14:51:56 DEBUG manager.SqlManager: Using fetchSize for next query: 1000
20/04/03 14:51:56 INFO manager.SqlManager: Executing SQL statement: select JobId from JobHistory where (1 = 0)
20/04/03 14:51:56 DEBUG manager.SqlManager: Found column JobId
20/04/03 14:51:56 ERROR tool.ImportTool: Import failed: No column by the name ConferenceDisplayNameListfound while importing data; expecting one of [JobId]

 

Please let me know your ideas on how to solve this error. Thank you!

Don't have an account?
Coming from Hortonworks? Activate your account here