Jagat, I forgot to mention that I have tried both upper case and lowercase table names with no success. Run with uppercase below:
[arovner@haiti sqoop]$ bin/sqoop import --connect jdbc:oracle:thin:@10.0.137.102:1521:MRC2 --username XXXX --password XXX --table BUILD_NODE --hive-import --hive-overwrite --hive-table build_node --num-mappers 1 --map-column-hive CLIENT_TID=bigint,MERCHANDISE_TID=bigint --target-dir /tmp/tables/build_node Warning: /usr/lib/hbase does not exist! HBase imports will fail. Please set $HBASE_HOME to the root of your HBase installation. 12/03/11 08:01:19 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead. 12/03/11 08:01:19 INFO tool.BaseSqoopTool: Using Hive-specific delimiters for output. You can override 12/03/11 08:01:19 INFO tool.BaseSqoopTool: delimiters with --fields-terminated-by, etc. 12/03/11 08:01:19 INFO manager.SqlManager: Using default fetchSize of 1000 12/03/11 08:01:19 INFO tool.CodeGenTool: Beginning code generation 12/03/11 08:01:20 INFO manager.OracleManager: Time zone has been set to GMT 12/03/11 08:01:20 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM BUILD_NODE t WHERE 1=0 12/03/11 08:01:20 ERROR tool.ImportTool: Imported Failed: Attempted to generate class with no columns! Thanks Alex On Sun, Mar 11, 2012 at 12:16 AM, Jagat <jagatsi...@gmail.com> wrote: > Dear Alex > > The Oracle table name has to be given in upper case. > > The same has been documented in the Sqoop user guide. > > You can read more about it at link below. > > > http://incubator.apache.org/sqoop/docs/1.4.1-incubating/SqoopUserGuide.html#_oracle_case_sensitive_catalog_query_errors > > Thanks > > Jagat > > On Sun, Mar 11, 2012 at 7:24 AM, Alex Rovner > <arov...@proclivitymedia.com>wrote: > >> Getting the below error when specifying "--table" argument. Specifying >> the "--query" works though. Reading through email archives some one >> suggested that the table names are case sensitive in oracle so I have >> verified that the case is correct. >> >> Using latest from trunk. Any ideas? >> >> [arovner@haiti sqoop]$ bin/sqoop version >> Warning: /usr/lib/hbase does not exist! HBase imports will fail. >> Please set $HBASE_HOME to the root of your HBase installation. >> Sqoop 1.4.2-incubating-SNAPSHOT >> git commit id 8b39345360c7c4e2982bfa25c27321 >> ad9882357f >> Compiled by arovner on Sat Mar 10 15:07:11 EST 2012 >> >> >> >> [arovner@haiti sqoop]$ bin/sqoop import --connect >> jdbc:oracle:thin:@10.0.137.102:1521:MRC2 --username XXXX --password XXXX >> --table build_node --hive-import --hive-overwrite --hive-table build_node >> --target-dir /tmp/build_node --num-mappers 1 >> Warning: /usr/lib/hbase does not exist! HBase imports will fail. >> Please set $HBASE_HOME to the root of your HBase installation. >> 12/03/10 15:21:53 WARN tool.BaseSqoopTool: Setting your password on the >> command-line is insecure. Consider using -P instead. >> 12/03/10 15:21:53 INFO tool.BaseSqoopTool: Using Hive-specific delimiters >> for output. You can override >> 12/03/10 15:21:53 INFO tool.BaseSqoopTool: delimiters with >> --fields-terminated-by, etc. >> 12/03/10 15:21:53 INFO manager.SqlManager: Using default fetchSize of 1000 >> 12/03/10 15:21:53 INFO tool.CodeGenTool: Beginning code generation >> 12/03/10 15:21:54 INFO manager.OracleManager: Time zone has been set to >> GMT >> 12/03/10 15:21:54 INFO manager.SqlManager: Executing SQL statement: >> SELECT t.* FROM build_node t WHERE 1=0 >> 12/03/10 15:21:54 ERROR tool.ImportTool: Imported Failed: Attempted to >> generate class with no columns! >> >> >> Proclivity® | We Value Your Customers™ >> >> This message is the property of Proclivity Systems, Inc. and is intended >> only for the use of the addressee(s), and may contain material that is >> confidential and privileged for the sole use of the intended recipient. If >> you are not the intended recipient, reliance or forwarding without express >> permission is strictly prohibited; please contact the sender and delete all >> copies. > > > -- Proclivity® | We Value Your Customers™ This message is the property of Proclivity Systems, Inc. and is intended only for the use of the addressee(s), and may contain material that is confidential and privileged for the sole use of the intended recipient. If you are not the intended recipient, reliance or forwarding without express permission is strictly prohibited; please contact the sender and delete all copies.
