sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alex Rovner <arov...@proclivitymedia.com>
Subject Issue with Oracle and Sqoop
Date Sun, 11 Mar 2012 01:54:25 GMT
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.

Mime
View raw message