i got this error 17/04/12 15:28:29 INFO mapreduce.Job: Counters: 8 Job Counters Failed map tasks=1 Launched map tasks=1 Rack-local map tasks=1 Total time spent by all maps in occupied slots (ms)=654614 Total time spent by all reduces in occupied slots (ms)=0 Total time spent by all map tasks (ms)=327307 Total vcore-milliseconds taken by all map tasks=327307 Total megabyte-milliseconds taken by all map tasks=502743552 17/04/12 15:28:29 WARN mapreduce.Counters: Group FileSystemCounters is deprecated. Use org.apache.hadoop.mapreduce.FileSystemCounter instead 17/04/12 15:28:29 INFO mapreduce.ExportJobBase: Transferred 0 bytes in 342.7432 seconds (0 bytes/sec) 17/04/12 15:28:29 WARN mapreduce.Counters: Group org.apache.hadoop.mapred.Task$Counter is deprecated. Use org.apache.hadoop.mapreduce.TaskCounter instead 17/04/12 15:28:29 INFO mapreduce.ExportJobBase: Exported 0 records. 17/04/12 15:28:29 ERROR mapreduce.ExportJobBase: Export job failed! 17/04/12 15:28:29 ERROR tool.ExportTool: Error during export: Export job failed! ... View more

Hi @Deepesh, thank you for your response, but i have some question. --table TABLENAME - is this the table on sql server where i want to dump the data? --export-dir HDFS_EXPORT_DIR - and this command is for HDFS? but my data is on Hive. Please correct me if im wrong ... View more

Hi @Ravi Mutyala, is there any disadvantage when importing a table from Sql Server directly to HIVE? what is the best way to do it? Can you help me with this. thank you in advance ... View more

Hi @Rajendra Manjunath, I try to revise my commands , i dont see any error but still no data transferred on the hdfs directory, please the image ... View more

@Jay SenSharma, i successfully moved the sqljdbc42.jar here : /usr/hdp/current/sqoop-client/lib/ what else should i do after i moved the jar file? i try again another import command but somethings wrong again. ... View more

Hi @Rajendra Manjunath, can you help me to identify whats wrong on my sqoop commands? ... View more

Hi @Jay SenSharma, i got two .jar files , is it ok if i put this both in /usr/hdp/current/sqoop-client/lib/ ? ... View more

Hi @Jay SenSharma, im now able to login on the sqoop client, but after executing some import commands i got this warning. ... View more

Hi @Jay SenSharma, I found out that its not listed on the sqoop client, Thanks for the help. but now my user dont have access on the other nodes.. I will post my updates once the user created. Thank you! ... View more

Hi @Jay SenSharma, Can you guide me how can install it on ambari? Please take a look on my ambari UI , yes i can see my "Sqoop Clients" whats next ? ... View more

@Jay SenSharma im just pasting it. too large to attach on this page. 2017-02-17 09:46:00,150 INFO [main-SendThread(XX002.XXDP.i4.internal.cloudapp.net:2181)]: zookeeper.ClientCnxn (ClientCnxn.java:logStartConnect(1019)) - Opening socket connection to server XX002.XXDP.i4.internal.cloudapp.net/10.94.11.37:2181. Will not attempt to authenticate using SASL (unknown error) 2017-02-17 09:46:00,151 WARN [main-SendThread(XX002.XXDP.i4.internal.cloudapp.net:2181)]: zookeeper.ClientCnxn (ClientCnxn.java:run(1146)) - Session 0x0 for server null, unexpected error, closing socket connection and attempting reconnect java.net.ConnectException: Connection refused at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method) at sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:717) at org.apache.zookeeper.ClientCnxnSocketNIO.doTransport(ClientCnxnSocketNIO.java:361) at org.apache.zookeeper.ClientCnxn$SendThread.run(ClientCnxn.java:1125) 2017-02-17 09:46:00,252 INFO [main-SendThread(XX001.XXDP.i4.internal.cloudapp.net:2181)]: zookeeper.ClientCnxn ... View more

@Artem Ervits do you see my logs? ... View more

i cant paste here my logs dont know why ... View more

Hi @Hamid Zorgani here's the config set on our HDFS ihere what ... View more

Hi @Sindhu, where can i find that "stack trace"? ... View more

Hi @Artem Ervits, Thank you for your quick response. can you guide how to that? im new on this technology. i recently assign to this to explore. im following some guides but this error alert stops me . ... View more