Resending, as the last one bounced. You need to specify username and tablename in uppercase, otherwise the job will fail
Thanks Venkat On Wed, May 22, 2013 at 4:19 PM, Venkat <venkat...@gmail.com> wrote: > You need to specify username and tablename in uppercase > > Venkat > > > On Wed, May 22, 2013 at 2:27 PM, Raj Hadoop <hadoop...@yahoo.com> 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 >