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:donta...@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
