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
