sqoop import No Java type for SQL type -151 for column __28ArchiveTime

最新推荐文章于 2022-04-23 15:36:32 发布

FreyFan

最新推荐文章于 2022-04-23 15:36:32 发布

阅读量695

点赞数

分类专栏： hadoop 文章标签： sqoop java type column time

本文链接：https://blog.csdn.net/fanchw/article/details/107404711

版权

博客讨论了在使用sqoop从SQLServer导入数据时遇到的问题，即sqoop无法处理时间字段，因为没有匹配的Java类型。提出了两种解决方案：1) 创建视图将时间字段转换为字符串；2) 修改sqoop源码，但这需要复杂的开发、测试和部署流程。

摘要由CSDN通过智能技术生成

[root@node11 ~]# sqoop import --connect 'jdbc:sqlserver://192.xxx.xxx.xxx:1433;username=xxxx;password=xxxx;database=ssws' --driver com.microsoft.sqlserver.jdbc.SQLServerDriver --columns "id,pump_type,_01SystemPressure,_28ArchiveTime,rowkey"  -table 'xxx'  --hbase-table 'xxx'  --column-family content --hbase-row-key rowkey -m 1
Warning: /root/TDH-Client/sqoop/../hcatalog does not exist! HCatalog jobs will fail.
Please set $HCAT_HOME to the root of your HCatalog installation.
Warning: /root/TDH-Client/sqoop/../accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
2020-07-17 11:36:06,267 INFO sqoop.Sqoop: Running Sqoop version: 1.4.5-transwarp-6.0.0
2020-07-17 11:36:06,368 WARN sqoop.ConnFactory: Parameter --driver is set to an explicit driver however appropriate connection manager is not being set (via --connection-manager). Sqoop is going to fall back to org.apa

最低0.47元/天解锁文章

FreyFan

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
sqoop import No Java type for SQL type -151 for column __28ArchiveTime

[root@node11 ~]# sqoop import --connect 'jdbc:sqlserver://192.xxx.xxx.xxx:1433;username=xxxx;password=xxxx;database=ssws' --driver com.microsoft.sqlserver.jdbc.SQLServerDriver --columns "id,pump_type,_01SystemPressure,_28ArchiveTime,rowkey" -table 'xxx'
复制链接

扫一扫