sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jagat <jagatsi...@gmail.com>
Subject Re: Issue with Oracle and Sqoop
Date Sun, 11 Mar 2012 05:16:32 GMT
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 <arovner@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.

Mime
View raw message