sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bejoy ks <bejo...@gmail.com>
Subject Re: Sqoop import failed
Date Wed, 12 Mar 2014 22:20:09 GMT
Hi Krishnan

Can you please post the complete verbose logs on sqoop command execution?

In the mean time you can verify whether this SQL Server is reachable from
all nodes(Task Trackers) in your cluster.


On Wed, Mar 12, 2014 at 10:36 AM, Krishnan Narayanan <
krishnan.smile@gmail.com> wrote:

> 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
>



-- 
Regards
       Bejoy

Mime
View raw message