You are viewing a plain text version of this content. The canonical link for it is here.
Posted to mapreduce-user@hadoop.apache.org by Raj Hadoop <ha...@yahoo.com> on 2013/05/22 23:27:09 UTC
Sqoop Import Oracle Error - Attempted to generate class with no columns!
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
Re: Sqoop Import Oracle Error - Attempted to generate class with no
columns!
Posted by Jarek Jarcec Cecho <ja...@apache.org>.
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 <ve...@gmail.com> wrote:
>
> > You need to specify username and tablename in uppercase
> >
> > Venkat
> >
> >
> > On Wed, May 22, 2013 at 2:27 PM, Raj Hadoop <ha...@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
> >
Re: Sqoop Import Oracle Error - Attempted to generate class with no columns!
Posted by Venkat Ranganathan <vr...@hortonworks.com>.
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 <ve...@gmail.com> wrote:
> You need to specify username and tablename in uppercase
>
> Venkat
>
>
> On Wed, May 22, 2013 at 2:27 PM, Raj Hadoop <ha...@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
>
Re: Sqoop Import Oracle Error - Attempted to generate class with no columns!
Posted by Venkat Ranganathan <vr...@hortonworks.com>.
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 <ve...@gmail.com> wrote:
> You need to specify username and tablename in uppercase
>
> Venkat
>
>
> On Wed, May 22, 2013 at 2:27 PM, Raj Hadoop <ha...@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
>
Re: Sqoop Import Oracle Error - Attempted to generate class with no columns!
Posted by Venkat Ranganathan <vr...@hortonworks.com>.
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 <ve...@gmail.com> wrote:
> You need to specify username and tablename in uppercase
>
> Venkat
>
>
> On Wed, May 22, 2013 at 2:27 PM, Raj Hadoop <ha...@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
>
Re: Sqoop Import Oracle Error - Attempted to generate class with no columns!
Posted by Venkat Ranganathan <vr...@hortonworks.com>.
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 <ve...@gmail.com> wrote:
> You need to specify username and tablename in uppercase
>
> Venkat
>
>
> On Wed, May 22, 2013 at 2:27 PM, Raj Hadoop <ha...@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
>
Re: Sqoop Import Oracle Error - Attempted to generate class with no columns!
Posted by Venkat Ranganathan <vr...@hortonworks.com>.
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 <ve...@gmail.com> wrote:
> You need to specify username and tablename in uppercase
>
> Venkat
>
>
> On Wed, May 22, 2013 at 2:27 PM, Raj Hadoop <ha...@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
>
Re: Sqoop Import Oracle Error - Attempted to generate class with no columns!
Posted by Venkat Ranganathan <vr...@hortonworks.com>.
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 <ve...@gmail.com> wrote:
> You need to specify username and tablename in uppercase
>
> Venkat
>
>
> On Wed, May 22, 2013 at 2:27 PM, Raj Hadoop <ha...@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
>
Re: Sqoop Import Oracle Error - Attempted to generate class with no columns!
Posted by Venkat <ve...@gmail.com>.
You need to specify username and tablename in uppercase
Venkat
On Wed, May 22, 2013 at 2:27 PM, Raj Hadoop <ha...@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