Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Sqoop >> mail # user >> Sqoop Import Oracle Error - Attempted to generate class with no columns!


+
Raj Hadoop 2013-05-22, 21:27
Copy link to this message
-
Re: Sqoop Import Oracle Error - Attempted to generate class with no columns!
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
+
Venkat Ranganathan 2013-05-22, 23:41
+
Jarek Jarcec Cecho 2013-05-23, 05:55