[PHOENIX-5935] Select with non primary keys and PHOENIX_ROW_TIMESTAMP() in where clause fails

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 5.1.0, 4.16.0
• Assignee: Jacob Isaac
• Reporter: Jacob Isaac
• Created: 03/Jun/20 03:09
• Updated: 15/Jan/21 12:19
• Resolved: 15/Jul/20 17:03

Description

This fails when COLUMN_ENCODED_BYTES != NON_ENCODED_QUALIFIERS

Steps to reproduce:-

CREATE TABLE IF NOT EXISTS N000001 (PK1 INTEGER NOT NULL, PK2 DATE NOT NULL, KV1 VARCHAR, KV2 VARCHAR CONSTRAINT PK PRIMARY KEY(PK1, PK2)) COLUMN_ENCODED_BYTES = 1,IMMUTABLE_STORAGE_SCHEME = ONE_CELL_PER_COLUMN

 

SELECT COUNT FROM N000001 WHERE PHOENIX_ROW_TIMESTAMP() > PK2 AND KV1 = 'KV1_1'";

 

Fails with the following exception -

Caused by: java.util.NoSuchElementExceptionCaused by: java.util.NoSuchElementException at org.apache.phoenix.filter.MultiEncodedCQKeyValueComparisonFilter$FilteredKeyValueHolder.getCellAtIndex(MultiEncodedCQKeyValueComparisonFilter.java:151) at org.apache.phoenix.filter.MultiEncodedCQKeyValueComparisonFilter$EncodedCQIncrementalResultTuple.getValue(MultiEncodedCQKeyValueComparisonFilter.java:311) at org.apache.phoenix.expression.function.PhoenixRowTimestampFunction.evaluate(PhoenixRowTimestampFunction.java:98) at org.apache.phoenix.expression.ComparisonExpression.evaluate(ComparisonExpression.java:330) at org.apache.phoenix.expression.AndOrExpression.evaluate(AndOrExpression.java:75) at org.apache.phoenix.filter.BooleanExpressionFilter.evaluate(BooleanExpressionFilter.java:93) at org.apache.phoenix.filter.MultiEncodedCQKeyValueComparisonFilter.filterKeyValue(MultiEncodedCQKeyValueComparisonFilter.java:233) at org.apache.hadoop.hbase.regionserver.querymatcher.UserScanQueryMatcher.matchColumn(UserScanQueryMatcher.java:122)

Issue Links

• is related to: PHOENIX-5629 Phoenix Function to Return HBase row timestamp