You need to specify username and tablename in uppercase Venkat
On Wed, May 22, 2013 at 2:27 PM, Raj Hadoop <[email protected]> wrote: > 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 > -- Regards Venkat
