sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Robson <David.Rob...@quest.com>
Subject RE: Problem in using sqoop with oracle
Date Thu, 15 Dec 2011 10:25:36 GMT
Hi Mohammad,

This is most likely caused by the username being specified in lower case - can you retry with
it in uppercase for example: "--username PPDMDB".

You could also try Quest® Data Connector for Oracle and Hadoop which is available here: http://toadforcloud.com/entry.jspa?categoryID=677&externalID=4298

It does not require the username or table name to be in uppercase and has a lot of other improvements.
It is Apache licensed and the source code can be found here: https://github.com/QuestSoftwareTCD/OracleSQOOPconnector

Regards,

David

-----Original Message-----
From: Mohammad Tariq [mailto:dontariq@gmail.com] 
Sent: Thursday, 15 December 2011 4:47 PM
To: sqoop-user@incubator.apache.org
Subject: Problem in using sqoop with oracle

Hello list,

     I am trying to store the tables from an oracle database on a
remote machine and store it in the Hbase. But I am getting the below
specified error -

solr@ubuntu:~$ sqoop import --connect
jdbc:oracle:thin:@//BLR-WS-202.pointcrossblr.com/ORCHDB --table
R_SOURCE --username ppdmdb --password ppdmdb --hbase-create-table
--hbase-table WIT --column-family myfamily
11/12/15 11:13:04 WARN tool.BaseSqoopTool: Setting your password on
the command-line is insecure. Consider using -P instead.
11/12/15 11:13:04 INFO manager.SqlManager: Using default fetchSize of 1000
11/12/15 11:13:04 INFO tool.CodeGenTool: Beginning code generation
11/12/15 11:13:04 INFO manager.OracleManager: Time zone has been set to GMT
11/12/15 11:13:04 INFO manager.SqlManager: Executing SQL statement:
SELECT t.* FROM R_SOURCE t WHERE 1=0
11/12/15 11:13:05 ERROR tool.ImportTool: Imported Failed: Attempted to
generate class with no columns!

Need some help.Thank you

Regards,
    Mohammad Tariq

Mime
View raw message