Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Sqoop >> mail # user >> Failed to import Oracle Table - case sensitive column name


Copy link to this message
-
Failed to import Oracle Table - case sensitive column name
I am trying to import a oracle table with Sqoop 1.4.3 with following
information -

  *Column Name* *Data Type* *Primary Key*  Company_ID NUMBER true
Formal_Name VARCHAR2 false  Ticker VARCHAR2 false  Cntry_Nme VARCHAR2 false
Industry VARCHAR2 false  Market_Cap NUMBER false  Daily_Change NUMBER false
Weekly_Change NUMBER false  Monthly_Change NUMBER false  Yearly_Change
NUMBER false  Ratings VARCHAR2 false  Current_Price NUMBER false
Current_Name VARCHAR2 false  Sector_Description VARCHAR2 false

with the command -

./sqoop import --connect jdbc:oracle:thin:@ORACLE_SERVER:1530:impl
 --username APP --password APP --table COMPANIES --target-dir
/landscape/APP/COMPANIES

The import process failed with -

java.sql.SQLException: ORA-00904: "SECTOR_DESCRIPTION": invalid identifier

The import process not taking care of case sensitive column names. How to
achieve that? Am I doing anything wrong? Please help.

--
Thanks,
Am
it