Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Sqoop >> mail # user >> Problem in using sqoop with oracle


+
Mohammad Tariq 2011-12-15, 05:47
+
Jarek Jarcec Cecho 2011-12-15, 07:06
Copy link to this message
-
RE: Problem in using sqoop with oracle
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:[EMAIL PROTECTED]]
Sent: Thursday, 15 December 2011 4:47 PM
To: [EMAIL PROTECTED]
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
+
Eric Wadsworth 2011-12-15, 17:41