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.
