qq_40678224 2018-10-11 00:59 采纳率: 0%
浏览 2124

使用sqoop2把hive表导出道pgsql时报错,数据只导出了一部分,如何解决?

18/10/11 16:30:39 INFO mapreduce.Job: Running job: job_1539239753824_0018
18/10/11 16:30:45 INFO mapreduce.Job: Job job_1539239753824_0018 running in uber mode : false
18/10/11 16:30:45 INFO mapreduce.Job: map 0% reduce 0%
18/10/11 16:30:56 INFO mapreduce.Job: map 19% reduce 0%
18/10/11 16:30:59 INFO mapreduce.Job: map 27% reduce 0%
18/10/11 16:31:01 INFO mapreduce.Job: map 100% reduce 0%
18/10/11 16:31:02 INFO mapreduce.Job: Job job_1539239753824_0018 failed with state FAILED due to: Task failed task_1539239753824_0018_m_000000
Job failed as tasks failed. failedMaps:1 failedReduces:0

18/10/11 16:31:02 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)=13204
Total time spent by all reduces in occupied slots (ms)=0
Total time spent by all map tasks (ms)=13204
Total vcore-milliseconds taken by all map tasks=13204
Total megabyte-milliseconds taken by all map tasks=13520896
18/10/11 16:31:02 WARN mapreduce.Counters: Group FileSystemCounters is deprecated. Use org.apache.hadoop.mapreduce.FileSystemCounter instead
18/10/11 16:31:02 INFO mapreduce.ExportJobBase: Transferred 0 bytes in 24.5676 seconds (0 bytes/sec)
18/10/11 16:31:02 WARN mapreduce.Counters: Group org.apache.hadoop.mapred.Task$Counter is deprecated. Use org.apache.hadoop.mapreduce.TaskCounter instead
18/10/11 16:31:02 INFO mapreduce.ExportJobBase: Exported 0 records.
18/10/11 16:31:02 ERROR mapreduce.ExportJobBase: Export job failed!
18/10/11 16:31:02 ERROR tool.ExportTool: Error during export:
Export job failed!
at org.apache.sqoop.mapreduce.ExportJobBase.runExport(ExportJobBase.java:445)
at org.apache.sqoop.manager.SqlManager.exportTable(SqlManager.java:931)
at org.apache.sqoop.tool.ExportTool.exportTable(ExportTool.java:80)
at org.apache.sqoop.tool.ExportTool.run(ExportTool.java:99)
at org.apache.sqoop.Sqoop.run(Sqoop.java:147)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:243)
at org.apache.sqoop.Sqoop.main(Sqoop.java:252)

展开全部

  • 写回答

1条回答 默认 最新

  • qq_40678224 2018-10-11 01:00
    关注

    hive的表字段是4个string,一个int,一个timestamp,对应pg里面是4个text,一个integer,一个timestamp

    sqoop export --connect jdbc:postgresql://192.168.136.151:5432/test --username postgres --password 'postgres' --table t_merchant_infocontent --export-dir /user/hive/warehouse/userdb.db/t_merchant_infocontent_for_mysql/* --input-fields-terminated-by '\t'

    评论
    编辑
    预览

    报告相同问题?

    悬赏问题

    • ¥50 第三代非支配排序遗传算法(NSGA-Ⅲ)和多目标粒子群优化算法(MOPSO)的实现
    • ¥20 图的广度优先搜索输出遍历序列
    • ¥15 hbuilderx写一个这个网页🙏
    • ¥20 plant simulation与python com接口实时数据交互
    • ¥15 有关汽车的MC9S12XS128单片机实验
    • ¥15 求c语言动态链表相关课程有偿,或能将这块知识点讲明白
    • ¥15 FLKT界面刷新异常
    • ¥15 物体双站RCS和其组成阵列后的双站RCS关系验证
    • ¥50 单细胞测序拟时序分析
    • ¥50 运行springboot项目报错
    手机看
    程序员都在用的中文IT技术交流社区

    程序员都在用的中文IT技术交流社区

    专业的中文 IT 技术社区,与千万技术人共成长

    专业的中文 IT 技术社区,与千万技术人共成长

    关注【CSDN】视频号,行业资讯、技术分享精彩不断,直播好礼送不停!

    关注【CSDN】视频号,行业资讯、技术分享精彩不断,直播好礼送不停!

    客服 返回
    顶部