Hi Raj, you can find more background for this issue in Sqoop Troubleshooting guide:
http://sqoop.apache.org/docs/1.4.3/SqoopUserGuide.html#_oracle_case_sensitive_catalog_query_errors Jarcec On Wed, May 22, 2013 at 04:41:28PM -0700, Venkat Ranganathan wrote: > 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 <[email protected]> wrote: > > > 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 > >
signature.asc
Description: Digital signature
