hadoop-mapreduce-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Venkat Ranganathan <vranganat...@hortonworks.com>
Subject Re: Sqoop Import Oracle Error - Attempted to generate class with no columns!
Date Wed, 22 May 2013 23:41:28 GMT
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