sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From anil gupta <anilg...@buffalo.edu>
Subject Re: Issue with Oracle and Sqoop
Date Sun, 11 Mar 2012 16:09:10 GMT
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

Mime
View raw message