question Re: Why Sqoop Executing same query for both MySql and Oracle.. in Archives of Support Questions (Read Only)

Why Sqoop Executing same query for both MySql and Oracle..

bsuresh — Mon, 14 Dec 2015 13:37:48 GMT

sqoop import --driver oracle.jdbc.driver.OracleDriver --connect jdbc:oracle:thin:@ipaddress:1521:orcl --username username --password password --table T_PROJECT --delete-target-dir --warehouse-dir /foo

The above one is simple sqoop command i executed.This tries to execute following command to know the columns."SELECT t.* FROM T_PROJECT AS t WHERE 1=0" (False condition to know columns of table) .Unfortunately this won't work in oracle.If i changed the database to mysql,It is working well.Where is the logic.How to execute above command for oracle database.

Re: Why Sqoop Executing same query for both MySql and Oracle..

nsabharwal — Mon, 14 Dec 2015 19:13:10 GMT

@Suresh Bonam

Please share the output of sqoop while running it for oracle. I have never experienced any issues while running simple import from oracle to hive using sqoop.

I don't have oracle instance running but you can see working example here

http://www.rittmanmead.com/2014/03/using-sqoop-for...

Re: Why Sqoop Executing same query for both MySql and Oracle..

bsuresh — Mon, 19 Aug 2019 12:37:38 GMT

HI Neeraj,

The following pic shows the error.The respective command is as i wrote in the question only with -m 1 option.The oracle imports are working well with query.But i try to import data using --table option instead of --query there i am getting error.This command is working fine with Mysql. I taught Sqoop using select t.* from T_PROJECT as t where 1=0 to determine column names,there oracle database suffers.And it is executing well in Mysql.

Re: Why Sqoop Executing same query for both MySql and Oracle..

nsabharwal — Mon, 14 Dec 2015 19:56:36 GMT

@Suresh Bonam The problem is with "AS" operator Bug

What is the ojdbc version?

Re: Why Sqoop Executing same query for both MySql and Oracle..

bsuresh — Mon, 14 Dec 2015 20:02:57 GMT

@Neeraj Sabharwal

The ojdbc version is 14. How to solve it??

Re: Why Sqoop Executing same query for both MySql and Oracle..

nsabharwal — Mon, 14 Dec 2015 20:05:34 GMT

@Suresh Bonam

Skip --driver oracle.jdbc.driver.OracleDriver - Bug

Run this

sqoop import --connect jdbc:oracle:thin:@ipaddress:1521:orcl --username username --password password --table T_PROJECT --delete-target-dir --warehouse-dir /foo

Re: Why Sqoop Executing same query for both MySql and Oracle..

nsabharwal — Tue, 15 Dec 2015 20:29:48 GMT

@Suresh Bonam Did it work? If yes then please accept the answer for future reference.

Re: Why Sqoop Executing same query for both MySql and Oracle..

bsuresh — Tue, 15 Dec 2015 20:35:02 GMT

Yupp..its working fine...Tq