Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB