sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alex Rovner <arov...@proclivitymedia.com>
Subject Re: Issue with Oracle and Sqoop
Date Sun, 11 Mar 2012 18:51:37 GMT
That worked. Thanks

Sent from my iPhone

On Mar 11, 2012, at 12:09 PM, anil gupta <anilgupt@buffalo.edu> wrote:

HI Alex,

Please try with uppercase username along with upper case TableName.

Thanks,
Anil

On Sun, Mar 11, 2012 at 5:02 AM, Alex Rovner <arovner@proclivitymedia.com>wrote:

> 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 <jagatsingh@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 <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.
>>
>>
>>
>
> 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.




-- 
Thanks & Regards,
Anil Gupta

-- 
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