Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB