Try the table name as caps in your Sqoop syntax (even though it is lwr case on the Oracle side).
Sent from my iPhone On Feb 17, 2014, at 9:19 PM, "John Zhao" <[email protected]<mailto:[email protected]>> wrote: I got an oracle table with lower case character in table name and column name: CREATE TABLE "MINER_DEMO"."golf_cap_col"(outlook VARCHAR2(32), temperature integer,humidity integer,wind VARCHAR2(32), “play" VARCHAR2(32)) ; INSERT INTO "MINER_DEMO"."golf_cap_col"( outlook, temperature, humidity, wind, “play") VALUES ('sunny', 80, 81, 'false', 'no’) So when I run this ./sqoop import --connect jdbc:oracle:thin:@192.168.1.28:1521/xe --username miner_demo --password miner_demo --table MINER_DEMO.golf_cap_col --username miner_demo --password miner_demo --connection-manager org.apache.sqoop.manager.OracleManager -m 1 It will throw the following error : 14/02/17 17:04:21 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM MINER_DEMO.golf_cap_col t WHERE 1=0 14/02/17 17:04:21 ERROR manager.SqlManager: Error executing statement: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395) If I run the command with --table "MINER_DEMO".”golf_cap_col”, it will throw the same error . If I run it with --table \"\"MINER_DEMO\".\”golf_cap_col\"\” , it shows the following error : ./sqoop import --connect jdbc:oracle:thin:@192.168.1.28:1521/xe --username miner_demo --password miner_demo --table \"\"MINER_DEMO\".\"golf_cap_col\"\" --username miner_demo --password miner_demo --connection-manager org.apache.sqoop.manager.OracleManager -m 1 .... 14/02/17 17:00:01 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM "MINER_DEMO"."golf_cap_col" t WHERE 1=0 14/02/17 17:00:01 ERROR tool.ImportTool: Imported Failed: Attempted to generate class with no columns! Also the same issue happens in export command. So, as I tried every way I can think, it still does not work. Does anyone know how to handle it? Thanks. John Zhao
