hadoop-mapreduce-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Raj Hadoop <hadoop...@yahoo.com>
Subject Sqoop Import Oracle Error - Attempted to generate class with no columns!
Date Wed, 22 May 2013 21:27:09 GMT
Hi,
 
I just finished setting up Apache sqoop 1.4.3. I am trying to test basic sqoop import on Oracle.
 
sqoop import --connect jdbc:oracle:thin:@//intelli.dmn.com:1521/DBT --table usr1.testonetwo
--username usr123 --password passwd123
 
 
I am getting the error as 
13/05/22 17:18:16 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM usr1.testonetwo
t WHERE 1=0
13/05/22 17:18:16 ERROR tool.ImportTool: Imported Failed: Attempted to generate class with
no columns!
 
I checked the database and the query runs fine from Oracle sqlplus client and Toad.
 
Thanks,
Raj
Mime
View raw message