sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jarek Jarcec Cecho <jar...@apache.org>
Subject Re: Sqoop Import Oracle Error - Attempted to generate class with no columns!
Date Thu, 23 May 2013 05:55:34 GMT
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 <venkat.nr@gmail.com> wrote:
> 
> > You need to specify username and tablename in uppercase
> >
> > Venkat
> >
> >
> > On Wed, May 22, 2013 at 2:27 PM, Raj Hadoop <hadoopraj@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
> >

Mime
View raw message