sqoop1.99.4错误:GENERIC_JDBC_CONNECTOR_0005:No column is found to partition data

场景:

从greenplum用sqoop1.99.4抽数到hdfs

环境:

hadoop-2.6.4,sqoop1.99.4

错误信息:
    2017-01-07 16:16:27,426 [http-12000-1] ERROR org.apache.sqoop.server.SqoopProtocolServlet  - Exception in PUT  http://localhost:12000/sqoop/v1/job/13/start org.apache.sqoop.common.SqoopException: GENERIC_JDBC_CONNECTOR_0005: No column is found to partition data
        at org.apache.sqoop.connector.jdbc.GenericJdbcFromInitializer.configurePartitionProperties(GenericJdbcFromInitializer.java:152)
        at org.apache.sqoop.connector.jdbc.GenericJdbcFromInitializer.initialize(GenericJdbcFromInitializer.java:51)
        at org.apache.sqoop.connector.jdbc.GenericJdbcFromInitializer.initialize(GenericJdbcFromInitializer.java:40)
        at org.apache.sqoop.driver.JobManager.initializeConnector(JobManager.java:451)
        at org.apache.sqoop.driver.JobManager.createJobRequest(JobManager.java:371)
        at org.apache.sqoop.driver.JobManager.start(JobManager.java:277)
        at org.apache.sqoop.handler.JobRequestHandler.startJob(JobRequestHandler.java:366)
        at org.apache.sqoop.handler.JobRequestHandler.handleEvent(JobRequestHandler.java:112)
        at org.apache.sqoop.server.v1.JobServlet.handlePutRequest(JobServlet.java:96)
        at org.apache.sqoop.server.SqoopProtocolServlet.doPut(SqoopProtocolServlet.java:79)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:730)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)

关键信息 No column is found to partition data 查了资料没发现什么意思,后来细想,greenplum在环境中都是有分部键的
然后我对我的sqoop  job做了update

有如下信息
Schema name: datamart
Table name: table_name
Table SQL statement: 
Table column names: 
Partition column name:
Null value allowed for the partition column: 
Boundary query: 

Partition column name分区的列名,正好我把表table_name的分布键  id  加了上去,然后start job --jid 1
执行成功


  • 1
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值