用sqoop把hive中的表格导入到mysql中没有报错但是不成功这是什么问题?在线等,急!

铁血小八 2015-10-30 11:22:16
c1@u1:~$ sqoop export --connect jdbc:mysql://u1:3306/nihao --username root --password hive --table bujiming --export-dir /
Creating symlink: /home/c1/hadoop2/tmp/mapred/local/1446172727647/snappy-java-1.0.3.2.jar <- /home/c1/snappy-java-1.-ma
15/1
15/10/29 19:38:50 INFO mapred.LocalDistributedCacheManager: Creating symlink: /home/c1/hadoop2/tmp/mapred/local/1446172727666/hadoop-mapreduce-client-hs-2.2.0.jar <- /home/c1/hadoop-mapreduce-client-hs-2.2.0.jar
15/10/29 19:38:50 INFO mapred.LocalDistributedCacheManager: Localized hdfs://u1:9000/home/c1/sqoop1.4.4/lib/hadoop-mapreduce-client-hs-2.2.0.jar as file:/home/c1/hadoop2/tmp/mapred/local/1446172727666/hadoop-mapreduce-client-hs-2.2.0.jar
15/10/29 19:38:50 INFO mapred.LocalDistributedCacheManager: Creating symlink: /home/c1/hadoop2/tmp/mapred/local/1446172727667/hadoop-mapreduce-client-jobclient-2.2.0.jar <- /home/c1/hadoop-mapreduce-client-jobclient-2.2.0.jar
15/10/29 19:38:50 INFO mapred.LocalDistributedCacheManager: Localized hdfs://u1:9000/home/c1/sqoop1.4.4/lib/hadoop-mapreduce-client-jobclient-2.2.0.jar as file:/home/c1/hadoop2/tmp/mapred/local/1446172727667/hadoop-mapreduce-client-jobclient-2.2.0.jar
15/10/29 19:38:50 INFO mapred.LocalDistributedCacheManager: Creating symlink: /home/c1/hadoop2/tmp/mapred/local/1446172727668/avro-ipc-1.5.3.jar <- /home/c1/avro-ipc-1.5.3.jar
15/10/29 19:38:50 INFO mapred.LocalDistributedCacheManager: Localized hdfs://u1:9000/home/c1/sqoop1.4.4/lib/avro-ipc-1.5.3.jar as file:/home/c1/hadoop2/tmp/mapred/local/1446172727668/avro-ipc-1.5.3.jar
15/10/29 19:38:50 INFO Configuration.deprecation: mapred.cache.localFiles is deprecated. Instead, use mapreduce.job.cache.local.files
15/10/29 19:38:50 WARN conf.Configuration: hdfs-site.xml:an attempt to override final parameter: dfs.namenode.name.dir; Ignoring.
15/10/29 19:38:50 WARN conf.Configuration: file:/home/c1/hadoop2/tmp/mapred/local/localRunner/c1/job_local1148244138_0001/job_local1148244138_0001.xml:an attempt to override final parameter: dfs.namenode.name.dir; Ignoring.
15/10/29 19:38:50 WARN conf.Configuration: file:/home/c1/hadoop2/tmp/mapred/local/localRunner/c1/job_local1148244138_0001/job_local1148244138_0001.xml:an attempt to override final parameter: dfs.replication; Ignoring.
15/10/29 19:38:50 WARN conf.Configuration: file:/home/c1/hadoop2/tmp/mapred/local/localRunner/c1/job_local1148244138_0001/job_local1148244138_0001.xml:an attempt to override final parameter: mapreduce.job.end-notification.max.retry.interval; Ignoring.
15/10/29 19:38:50 WARN conf.Configuration: file:/home/c1/hadoop2/tmp/mapred/local/localRunner/c1/job_local1148244138_0001/job_local1148244138_0001.xml:an attempt to override final parameter: mapreduce.job.end-notification.max.attempts; Ignoring.
15/10/29 19:38:50 WARN conf.Configuration: file:/home/c1/hadoop2/tmp/mapred/local/localRunner/c1/job_local1148244138_0001/job_local1148244138_0001.xml:an attempt to override final parameter: fs.defaultFS; Ignoring.
15/10/29 19:38:50 INFO mapred.LocalDistributedCacheManager: file:/home/c1/hadoop2/tmp/mapred/local/1446172727645/jackson-mapper-asl-1.7.3.jar
15/10/29 19:38:50 INFO mapred.LocalDistributedCacheManager: file:/home/c1/hadoop2/tmp/mapred/local/1446172727646
15/10/29 19:38:50 INFO mapred.LocalDistributedCacheManager: file:/home/c1/hadoop2/tmp/mapred/local/1446172727662/commons-io-1.4.jar
15/10/29 19:38:50 INFO mapred.LocalDistributedCacheManager: file:/home/c1/hadoop2/tmp/mapred/local/1446172727663/hsqldb-1.8.0.10.jar
15/10/29 19:38:50 INFO mapred.LocalDistributedCacheManager: file:/home/c1/hadoop2/tmp/mapred/local/1446172727664/hadoop-mapreduce-client-jobclient-2.2.0-tests.jar
15/10/29 19:38:50 INFO mapred.LocalDistributedCacheManager: file:/home/c1/hadoop2/tmp/mapred/local/1446172727665/hadoop-mapreduce-client-core-2.2.0.jar
15/10/29 19:38:50 INFO mapred.LocalDistributedCacheManager: file:/home/c1/hadoop2/tmp/mapred/local/1446172727666/hadoop-mapreduce-client-hs-2.2.0.jar
15/10/29 19:38:50 INFO mapred.LocalDistributedCacheManager: file:/home/c1/hadoop2/tmp/mapred/local/1446172727667/hadoop-mapreduce-client-jobclient-2.2.0.jar
15/10/29 19:38:50 INFO mapred.LocalDistributedCacheManager: file:/home/c1/hadoop2/tmp/mapred/local/1446172727668/avro-ipc-1.5.3.jar
15/10/29 19:38:50 INFO mapreduce.Job: The url to track the job: http://localhost:8080/
15/10/29 19:38:50 INFO mapreduce.Job: Running job: job_local1148244138_0001
15/10/29 19:38:50 INFO mapred.LocalJobRunner: OutputCommitter set in config null
15/10/29 19:38:50 INFO mapred.LocalJobRunner: OutputCommitter is org.apache.sqoop.mapreduce.NullOutputCommitter
15/10/29 19:38:50 WARN conf.Configuration: hdfs-site.xml:an attempt to override final parameter: dfs.namenode.name.dir; Ignoring.
15/10/29 19:38:50 INFO mapred.LocalJobRunner: Waiting for map tasks
15/10/29 19:38:50 INFO mapred.LocalJobRunner: Starting task: attempt_local1148244138_0001_m_000000_0
15/10/29 19:38:50 INFO mapred.Task: Using ResourceCalculatorProcessTree : [ ]
15/10/29 19:38:50 INFO mapred.MapTask: Processing split: Paths:/user/hive/warehouse/bujiming/000000_0:110187+18365,/user/hive/warehouse/bujiming/000000_0:128552+18365
15/10/29 19:38:50 INFO Configuration.deprecation: map.input.file is deprecated. Instead, use mapreduce.map.input.file
15/10/29 19:38:50 INFO Configuration.deprecation: map.input.start is deprecated. Instead, use mapreduce.map.input.start
15/10/29 19:38:50 INFO Configuration.deprecation: map.input.length is deprecated. Instead, use mapreduce.map.input.length
15/10/29 19:38:51 INFO mapreduce.AutoProgressMapper: Auto-progress thread is finished. keepGoing=false
15/10/29 19:38:51 INFO mapred.LocalJobRunner:
15/10/29 19:38:51 INFO mapred.Task: Task:attempt_local1148244138_0001_m_000000_0 is done. And is in the process of committing
15/10/29 19:38:51 INFO mapred.LocalJobRunner: map
15/10/29 19:38:51 INFO mapred.Task: Task 'attempt_local1148244138_0001_m_000000_0' done.
15/10/29 19:38:51 INFO mapred.LocalJobRunner: Finishing task: attempt_local1148244138_0001_m_000000_0
15/10/29 19:38:51 INFO mapred.LocalJobRunner: Starting task: attempt_local1148244138_0001_m_000001_0
15/10/29 19:38:51 INFO mapred.Task: Using ResourceCalculatorProcessTree : [ ]
15/10/29 19:38:51 INFO mapred.MapTask: Processing split: Paths:/user/hive/warehouse/bujiming/000000_0:0+36729
15/10/29 19:38:51 INFO mapreduce.Job: Job job_local1148244138_0001 running in uber mode : false
15/10/29 19:38:51 INFO mapreduce.Job: map 100% reduce 0%
15/10/29 19:38:51 INFO mapreduce.AutoProgressMapper: Auto-progress thread is finished. keepGoing=false
15/10/29 19:38:51 INFO mapred.LocalJobRunner:
15/10/29 19:38:51 INFO mapred.Task: Task:attempt_local1148244138_0001_m_000001_0 is done. And is in the process of committing
15/10/29 19:38:51 INFO mapred.LocalJobRunner: map
15/10/29 19:38:51 INFO mapred.Task: Task 'attempt_local1148244138_0001_m_000001_0' done.
15/10/29 19:38:51 INFO mapred.LocalJobRunner: Finishing task: attempt_local1148244138_0001_m_000001_0
15/10/29 19:38:51 INFO mapred.LocalJobRunner: Starting task: attempt_local1148244138_0001_m_000002_0
15/10/29 19:38:51 INFO mapred.Task: Using ResourceCalculatorProcessTree : [ ]
15/10/29 19:38:51 INFO mapred.MapTask: Processing split: Paths:/user/hive/warehouse/bujiming/000000_0:36729+36729
15/10/29 19:38:51 INFO mapreduce.AutoProgressMapper: Auto-progress thread is finished. keepGoing=false
15/10/29 19:38:51 INFO mapred.LocalJobRunner:
15/10/29 19:38:51 INFO mapred.Task: Task:attempt_local1148244138_0001_m_000002_0 is done. And is in the process of committing
15/10/29 19:38:51 INFO mapred.LocalJobRunner: map
15/10/29 19:38:51 INFO mapred.Task: Task 'attempt_local1148244138_0001_m_000002_0' done.
15/10/29 19:38:51 INFO mapred.LocalJobRunner: Finishing task: attempt_local1148244138_0001_m_000002_0
15/10/29 19:38:51 INFO mapred.LocalJobRunner: Starting task: attempt_local1148244138_0001_m_000003_0
15/10/29 19:38:51 INFO mapred.Task: Using ResourceCalculatorProcessTree : [ ]
15/10/29 19:38:51 INFO mapred.MapTask: Processing split: Paths:/user/hive/warehouse/bujiming/000000_0:73458+36729
15/10/29 19:38:52 INFO mapreduce.AutoProgressMapper: Auto-progress thread is finished. keepGoing=false
15/10/29 19:38:52 INFO mapred.LocalJobRunner:
15/10/29 19:38:52 INFO mapred.Task: Task:attempt_local1148244138_0001_m_000003_0 is done. And is in the process of committing
15/10/29 19:38:52 INFO mapred.LocalJobRunner: map
15/10/29 19:38:52 INFO mapred.Task: Task 'attempt_local1148244138_0001_m_000003_0' done.
15/10/29 19:38:52 INFO mapred.LocalJobRunner: Finishing task: attempt_local1148244138_0001_m_000003_0
15/10/29 19:38:52 INFO mapred.LocalJobRunner: Map task executor complete.
15/10/29 19:38:52 WARN conf.Configuration: hdfs-site.xml:an attempt to override final parameter: dfs.namenode.name.dir; Ignoring.
15/10/29 19:38:52 INFO mapreduce.Job: Job job_local1148244138_0001 completed successfully
15/10/29 19:38:52 INFO mapreduce.Job: Counters: 23
File System Counters
FILE: Number of bytes read=24660
FILE: Number of bytes written=40853260
FILE: Number of read operations=0
FILE: Number of large read operations=0
FILE: Number of write operations=0
HDFS: Number of bytes read=40062894
HDFS: Number of bytes written=0
HDFS: Number of read operations=1334
HDFS: Number of large read operations=0
HDFS: Number of write operations=0
Map-Reduce Framework
Map input records=1641
Map output records=1641
Input split bytes=601
Spilled Records=0
Failed Shuffles=0
Merged Map outputs=0
GC time elapsed (ms)=10
CPU time spent (ms)=0
Physical memory (bytes) snapshot=0
Virtual memory (bytes) snapshot=0
Total committed heap usage (bytes)=163086336
File Input Format Counters
Bytes Read=0
File Output Format Counters
Bytes Written=0
15/10/29 19:38:52 INFO mapreduce.ExportJobBase: Transferred 38.207 MB in 6.4586 seconds (5.9157 MB/sec)
15/10/29 19:38:52 INFO mapreduce.ExportJobBase: Exported 1641 records.
...全文
443 回复 打赏 收藏 转发到动态 举报
写回复
用AI写文章
回复
切换为时间正序
请发表友善的回复…
发表回复

932

社区成员

发帖
与我相关
我的任务
社区描述
云计算 云存储相关讨论
社区管理员
  • 云存储
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧