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
From: Mohammad Tariq [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 15 December 2011 4:47 PM
To: [EMAIL PROTECTED]
Subject: Problem in using sqoop with oracle
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
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