Hi Everyone, Facing strange issue in phoenix after bulk loading data in HBase. When we query count(*) on phoenix view encountered the below error, regular select is working fine.
java.lang.IllegalStateException: Expected single, aggregated KeyValue from coprocessor, but instead received keyvalues={lmalpinevancouver100~262/cf:chg_dt/1433442509439/Put/vlen=26/mvcc=0/value=2015-06-04 11:07:11.000000, lmalpinevancouver100~262/cf:dbname/1433442509439/Put/vlen=17/mvcc=0/value=lmalpinevancouver, lmalpinevancouver100~262/cf:fieldid/1433442509439/Put/vlen=3/mvcc=0/value=100, lmalpinevancouver100~262/cf:leadid/1433442509439/Put/vlen=3/mvcc=0/value=262, lmalpinevancouver100~262/cf:value/1433442509439/Put/vlen=3/mvcc=0/value=1st} . Ensure aggregating coprocessors are loaded correctly on server at org.apache.phoenix.util.TupleUtil.getAggregateValue(TupleUtil.java:88) at org.apache.phoenix.expression.aggregator.ClientAggregators.aggregate(ClientAggregators.java:54) at org.apache.phoenix.iterate.GroupedAggregatingResultIterator.next(GroupedAggregatingResultIterator.java:75) at org.apache.phoenix.iterate.UngroupedAggregatingResultIterator.next(UngroupedAggregatingResultIterator.java:39) at org.apache.phoenix.jdbc.PhoenixResultSet.next(PhoenixResultSet.java:739) at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2429) at sqlline.SqlLine$TableOutputFormat.print(SqlLine.java:2074) at sqlline.SqlLine.print(SqlLine.java:1735) at sqlline.SqlLine$Commands.execute(SqlLine.java:3683) at sqlline.SqlLine$Commands.sql(SqlLine.java:3584) at sqlline.SqlLine.dispatch(SqlLine.java:821) at sqlline.SqlLine.begin(SqlLine.java:699) at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441) at sqlline.SqlLine.main(SqlLine.java:424) When I drop and recreate the view, it works fine. Did anyone face similar issue? Thanks, Siva.