sqoop import时过滤条件时中文报错
0
sqoop import时过滤条件时中文或者时间类型会报错,请各位朋友指导
表结构
mysql> desc test1
-> ;
+-------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+-------+
| id | varchar(10) | YES | | NULL | |
| name | varchar(100) | YES | | NULL | |
执行语句
sqoop import --connect jdbc:mysql://192.168.70.10:3306/cm \
--username root -password 123456 --table test1 \
--columns 'id,name' \
--where 'name=泰山' \
--append \
--target-dir /tmp/sqooop \
-m 1
报错信息
16/12/11 17:30:29 INFO mapreduce.Job: Job job_local150876034_0001 running in uber mode : false
16/12/11 17:30:29 INFO mapreduce.Job: map 0% reduce 0%
16/12/11 17:30:29 INFO mapreduce.Job: Job job_local150876034_0001 failed with state FAILED due to: NA
16/12/11 17:30:29 INFO mapreduce.Job: Counters: 0
16/12/11 17:30:29 WARN mapreduce.Counters: Group FileSystemCounters is deprecated. Use org.apache.hadoop.mapreduce.FileSystemCounter instead
16/12/11 17:30:29 INFO mapreduce.ImportJobBase: Transferred 0 bytes in 6.6071 seconds (0 bytes/sec)
16/12/11 17:30:29 WARN mapreduce.Counters: Group org.apache.hadoop.mapred.Task$Counter is deprecated. Use org.apache.hadoop.mapreduce.TaskCounter instead
16/12/11 17:30:29 INFO mapreduce.ImportJobBase: Retrieved 0 records.
16/12/11 17:30:29 ERROR tool.ImportTool: Error during import: Import job failed!
表结构
mysql> desc test1
-> ;
+-------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+-------+
| id | varchar(10) | YES | | NULL | |
| name | varchar(100) | YES | | NULL | |
执行语句
sqoop import --connect jdbc:mysql://192.168.70.10:3306/cm \
--username root -password 123456 --table test1 \
--columns 'id,name' \
--where 'name=泰山' \
--append \
--target-dir /tmp/sqooop \
-m 1
报错信息
16/12/11 17:30:29 INFO mapreduce.Job: Job job_local150876034_0001 running in uber mode : false
16/12/11 17:30:29 INFO mapreduce.Job: map 0% reduce 0%
16/12/11 17:30:29 INFO mapreduce.Job: Job job_local150876034_0001 failed with state FAILED due to: NA
16/12/11 17:30:29 INFO mapreduce.Job: Counters: 0
16/12/11 17:30:29 WARN mapreduce.Counters: Group FileSystemCounters is deprecated. Use org.apache.hadoop.mapreduce.FileSystemCounter instead
16/12/11 17:30:29 INFO mapreduce.ImportJobBase: Transferred 0 bytes in 6.6071 seconds (0 bytes/sec)
16/12/11 17:30:29 WARN mapreduce.Counters: Group org.apache.hadoop.mapred.Task$Counter is deprecated. Use org.apache.hadoop.mapreduce.TaskCounter instead
16/12/11 17:30:29 INFO mapreduce.ImportJobBase: Retrieved 0 records.
16/12/11 17:30:29 ERROR tool.ImportTool: Error during import: Import job failed!
没有找到相关结果
重要提示:提问者不能发表回复,可以通过评论与回答者沟通,沟通后可以通过编辑功能完善问题描述,以便后续其他人能够更容易理解问题.
0 个回复