ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.RuntimeException: java.lang.RuntimeException: java.sql.SQLException: The connection property 'zeroDateTimeBehavior' acceptable values are: 'CO

使用sqoop导入数据时报了如题的异常,异常的提示是

 The connection property 'zeroDateTimeBehavior' acceptable values are: 'CONVERT_TO_NULL', 'EXCEPTION' or 'ROUND'. The value 'convertToNull' is not acceptable.

解决:

--connect jdbc:mysql://hadoop002:3306/company?zeroDateTimeBehavior=CONVERT_TO_NULL \

加了个参数zeroDateTimeBehavior=CONVERT_TO_NULL

之后重新执行可以正常导入了

posted @ 2018-11-25 14:35  tele  阅读(9027)  评论(1)  编辑  收藏  举报