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 < [email protected]> 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
