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.

column names changes to uppercase instead of lowercase while using sqoop to import

column names changes to uppercase instead of lowercase while using sqoop to import

Explorer

I am trying to import a table from SAP using sqoop but i am running into an error

SAP DBTech JDBC: [260]: invalid column name: BANNER: line 1 col 8 (at pos 7)

The name of this table is banner and not BANNER so its a bit confusing on what is going on.

Any Help?

This is the command i am using to run this

"sqoop import --username SYSTEM --password ******. --connect 'jdbc:sap://***.***.**.***:39015/?currentschema=******' --table FOOD --driver com.sap.db.jdbc.Driver --hive-import -direct -m 1"
1 REPLY 1
Highlighted

Re: column names changes to uppercase instead of lowercase while using sqoop to import

Expert Contributor

First option: You can try lowercase version of table name. Second option: use --query optins instead of --table. Then write sql query. In the query, I hope you can use original table name.

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