sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Krishnan Narayanan <krishnan.sm...@gmail.com>
Subject Sqoop import failed
Date Wed, 12 Mar 2014 17:36:02 GMT
Hi ,

I am using cloudera and sqoop 1.4.3, I trying to connect mssql server
database for getting the data.I have the sqljdbc4.jar file in lib.
I am able to connect and view the tables using sqoop list-tables but unable
to import.
I found that the sqoop 1.4.1 has this bug and fixed in the next versions.
can someone help me in this.

The below code works and list all the table in DB.

sqoop list-tables -Dmapred.job.queue.name=foundation  --connect
"jdbc:sqlserver://QYSPRDESTSQL06.net:20101;database=profiledb" \
--username "rpuser" \
--password "xxxxxxxxxxxx"

The below code throws error. TCP/IP error unable to connect host machine
check network setting

sqoop import -libjars /usr/lib/sqoop/lib/sqljdbc4.jar -
Dmapred.job.queue.name=foundation --connect
"jdbc:sqlserver://QYSPRDESTSQL06.net:20101;database=profiledb" \
--username rpuser \
--password xxxxxxxxxxxxx \
--fields-terminated-by 'รพ' \
--target-dir /app/apd/sys_apd_sl/test/mytable \
--table mytable

thanks
Krishnan

Mime
View raw message