Chandrasekar created PHOENIX-5236:
-------------------------------------
Summary: Multiple dynamic columns in WHERE clause is not working
Key: PHOENIX-5236
URL: https://issues.apache.org/jira/browse/PHOENIX-5236
Project: Phoenix
Issue Type: Bug
Affects Versions: 4.14.0
Reporter: Chandrasekar
When the query uses multiple dynamic columns in the WHERE clause it's failing.
Consider the following example:
CREATE TABLE CITY (ID INTEGER, NAME VARCHAR CONSTRAINT PK PRIMARY KEY (ID))
And the following upserts:
UPSERT INTO CITY (ID, NAME, POPULATION INTEGER, DISTRICT VARCHAR) VALUES (1,
'XYZ', 1000, 'XYZ')
UPSERT INTO CITY (ID, NAME, POPULATION INTEGER) VALUES (2, 'ABC', 2000)
And now when the following query is executed:
SELECT ID, NAME FROM CITY (POPULATION INTEGER, DISTRICT VARCHAR) WHERE
DISTRICT IS NULL AND POPULATION > 1000
It throws the following exception:
org.apache.phoenix.schema.PTable$QualifierEncodingScheme$InvalidQualifierBytesException:
Invalid number of qualifier bytes. Expected length: 2. Actual: 8
Does phoenix allows querying by conditions on multiple dynamic columns? The
phoenix version used is 4.14.0 and HBase version is 1.4.8.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
