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
|