Member since
02-17-2017
22
Posts
0
Kudos Received
0
Solutions
04-12-2017
12:51 PM
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
04-12-2017
07:17 AM
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
04-12-2017
12:53 AM
Hi, Can anyone can help me to find a solution on transfering data from Hive to Sql Server? The Idea is Hive is our back up and im trying to load it to sql server. Thank you in advance.!
... View more
Labels:
- Labels:
-
Apache Hive
03-20-2017
03:15 AM
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
03-17-2017
09:33 AM
Hi , Im trying to import table from SQL Server to Hive with the commands below: sqoop import --connect "jdbc:sqlserver://11.11.111.11;databaseName=dswFICO" --username sqoop--password sqoop --driver com.microsoft.sqlserver.jdbc.SQLServerDriver --table KNA1 --target-dir "/tmp/dbo-customer" When i check on Hive View i cant see any KNA1 table created.
... View more
Labels:
- Labels:
-
Apache Hive
-
Apache Sqoop
03-17-2017
01:08 AM
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
03-16-2017
07:03 AM
@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
03-16-2017
07:01 AM
Hi @Rajendra Manjunath, can you help me to identify whats wrong on my sqoop commands?
... View more
03-16-2017
03:28 AM
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
03-13-2017
08:01 AM
Hi @Jay SenSharma, im now able to login on the sqoop client, but after executing some import commands i got this warning.
... View more