pentaho hbase导入:从hbase中拉出日期数据类型抛出错误

nfzehxib  于 2021-06-09  发布在  Hbase
关注(0)|答案(0)|浏览(282)

我正在尝试使用hbase输入步骤查询hbase。但是它抛出了一个错误“hbase input 2.0-日期列值的长度必须等于long”
下面是我的配置屏幕截图


这是我的hbase表中的数据

您可以看到messagetimestamp是一个数字字符串。我想像这样筛选此列的查询

但这给了我一个错误,我怀疑这与类型转换有关。

2019/04/26 11:56:05 - HBase input 2.0 - ERROR (version 8.2.0.0-342, build 8.2.0.0-342 from 2018-11-14 10.30.55 by buildguy) : Unexpected error  
2019/04/26 11:56:05 - HBase input 2.0 - ERROR (version 8.2.0.0-342, build 8.2.0.0-342 from 2018-11-14 10.30.55 by buildguy) : org.pentaho.di.core.exception.KettleException:  
2019/04/26 11:56:05 - HBase input 2.0 - Unable to execute source table scan  
2019/04/26 11:56:05 - HBase input 2.0 - java.lang.IllegalArgumentException: java.lang.ClassCastException@75d93487  
2019/04/26 11:56:05 - HBase input 2.0 -  
2019/04/26 11:56:05 - HBase input 2.0 - at org.pentaho.big.data.kettle.plugins.hbase.input.HBaseInput.processRow(HBaseInput.java:245)  
2019/04/26 11:56:05 - HBase input 2.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)  
2019/04/26 11:56:05 - HBase input 2.0 - at java.lang.Thread.run(Unknown Source)  
2019/04/26 11:56:05 - HBase input 2.0 - Caused by: java.io.IOException: java.lang.IllegalArgumentException: java.lang.ClassCastException@75d93487  
2019/04/26 11:56:05 - HBase input 2.0 - at com.pentaho.big.data.bundles.impl.shim.hbase.table.ResultScannerBuilderImpl$3.perform(ResultScannerBuilderImpl.java:109)  
2019/04/26 11:56:05 - HBase input 2.0 - at com.pentaho.big.data.bundles.impl.shim.hbase.BatchHBaseConnectionOperation.perform(BatchHBaseConnectionOperation.java:45)  
2019/04/26 11:56:05 - HBase input 2.0 - at com.pentaho.big.data.bundles.impl.shim.hbase.table.ResultScannerBuilderImpl.build(ResultScannerBuilderImpl.java:126)  
2019/04/26 11:56:05 - HBase input 2.0 - at org.pentaho.big.data.kettle.plugins.hbase.input.HBaseInput.processRow(HBaseInput.java:243)

如果我去掉过滤器,试着把整个table拉起来。我仍然得到下面的错误

2019/04/26 11:59:46 - HBase input 2.0 - ERROR (version 8.2.0.0-342, build 8.2.0.0-342 from 2018-11-14 10.30.55 by buildguy) : Unexpected error  
2019/04/26 11:59:46 - HBase input 2.0 - ERROR (version 8.2.0.0-342, build 8.2.0.0-342 from 2018-11-14 10.30.55 by buildguy) : org.pentaho.di.core.exception.KettleException:  
2019/04/26 11:59:46 - HBase input 2.0 - The length of a date column value must equal that of a long  
2019/04/26 11:59:46 - HBase input 2.0 -  
2019/04/26 11:59:46 - HBase input 2.0 - at org.pentaho.hbase.shim.api.HBaseValueMeta.decodeColumnValue(HBaseValueMeta.java:755)  
2019/04/26 11:59:46 - HBase input 2.0 - at com.pentaho.big.data.bundles.impl.shim.hbase.meta.HBaseValueMetaInterfaceImpl.decodeColumnValue(HBaseValueMetaInterfaceImpl.java:49)  
2019/04/26 11:59:46 - HBase input 2.0 - at org.pentaho.big.data.kettle.plugins.hbase.input.HBaseInputData.getOutputRow(HBaseInputData.java:281)  
2019/04/26 11:59:46 - HBase input 2.0 - at org.pentaho.big.data.kettle.plugins.hbase.input.HBaseInput.processRow(HBaseInput.java:287)  
2019/04/26 11:59:46 - HBase input 2.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)  
2019/04/26 11:59:46 - HBase input 2.0 - at java.lang.Thread.run(Unknown Source)

不知道是什么导致了这个错误。

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题