phoenix构建索引时间戳类型的索引列发生异常 ERROR 201 (22000): Illegal data.

描述:索引表已有数据写入,估计是某个时间戳的值造成的非法数据异常。使得索引表一直处于BUILDING状态。
不知是不是时间类型或时间戳类型在索引表在某个极端下的bug还是其他问题,期望有大佬解答。


异常如下:


Error: ERROR 201 (22000): Illegal data. (state=22000,code=201)
java.sql.SQLException: ERROR 201 (22000): Illegal data.
at org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:493)
at org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:150)
at org.apache.phoenix.util.ServerUtil.parseRemoteException(ServerUtil.java:189)
at org.apache.phoenix.util.ServerUtil.parseServerExceptionOrNull(ServerUtil.java:173)
at org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:140)
at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:1298)
at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:1239)
at org.apache.phoenix.iterate.RoundRobinResultIterator.getIterators(RoundRobinResultIterator.java:176)
at org.apache.phoenix.iterate.RoundRobinResultIterator.next(RoundRobinResultIterator.java:91)
at org.apache.phoenix.compile.UpsertCompiler$ClientUpsertSelectMutationPlan.execute(UpsertCompiler.java:1318)
at org.apache.phoenix.compile.DelegateMutationPlan.execute(DelegateMutationPlan.java:31)
at org.apache.phoenix.compile.PostIndexDDLCompiler$1.execute(PostIndexDDLCompiler.java:117)
at org.apache.phoenix.query.ConnectionQueryServicesImpl.updateData(ConnectionQueryServicesImpl.java:3663)
at org.apache.phoenix.schema.MetaDataClient.buildIndex(MetaDataClient.java:1382)
at org.apache.phoenix.schema.MetaDataClient.alterIndex(MetaDataClient.java:3998)
at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableAlterIndexStatement$1.execute(PhoenixStatement.java:1230)
at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:406)
at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:389)
at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:388)
at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:376)
at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1789)
at sqlline.Commands.execute(Commands.java:822)
at sqlline.Commands.sql(Commands.java:732)
at sqlline.SqlLine.dispatch(SqlLine.java:813)
at sqlline.SqlLine.begin(SqlLine.java:686)
at sqlline.SqlLine.start(SqlLine.java:398)
at sqlline.SqlLine.main(SqlLine.java:291)
已邀请:

jinqian

赞同来自:

这问题解决了吗? 在什么版本上出现的, 提问的时候可以贴一下复现方式,建表、建索引和查询SQL

要回复问题请先登录注册


中国HBase技术社区微信公众号:
hbasegroup

欢迎加入HBase生态+Spark社区钉钉大群