You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@sqoop.apache.org by Mohammad Tariq <do...@gmail.com> on 2011/12/15 06:47:23 UTC
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
Re: Problem in using sqoop with oracle
Posted by Eric Wadsworth <er...@wadhome.org>.
What version of hadoop and hbase is your cluster?
I'm getting the same error, on my own build of sqoop, built against
hadoop version 0.20 and running against apache hadoop version 0.20),
whenever I try to use it with oracle. I dug into the code, but didn't
find anything obviously wrong in there.
--- wad
On 12/14/2011 09:47 PM, Mohammad Tariq wrote:
> 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
Re: Problem in using sqoop with oracle
Posted by Jarek Jarcec Cecho <ja...@apache.org>.
Can you also please attach table schema with sqoop output that was executed with parameter "--verbose"?
Jarcec
On Thu, Dec 15, 2011 at 11:17:23AM +0530, Mohammad Tariq wrote:
> 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
RE: Problem in using sqoop with oracle
Posted by David Robson <Da...@quest.com>.
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