我正在尝试使用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)
不知道是什么导致了这个错误。
暂无答案!
目前还没有任何答案,快来回答吧!