[ 
https://issues.apache.org/jira/browse/PHOENIX-5935?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jacob Isaac updated PHOENIX-5935:
---------------------------------
    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)

> Select with non primary keys and PHOENIX_ROW_TIMESTAMP() in where clause fails
> ------------------------------------------------------------------------------
>
>                 Key: PHOENIX-5935
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-5935
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: Jacob Isaac
>            Assignee: Jacob Isaac
>            Priority: Major
>
> 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)



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to