phoenix-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Karan Mehta (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-5236) Multiple dynamic columns in WHERE clause is not working
Date Thu, 25 Apr 2019 05:05:00 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-5236?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16825717#comment-16825717
] 

Karan Mehta commented on PHOENIX-5236:
--------------------------------------

[~ckulkarni] Any idea why this is happening here?

> 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
>            Priority: Major
>
> 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
>  Even comparing different dynamic columns is not working. For example in the same table,
following upsert is executed:
> UPSERT INTO CITY (ID, NAME, CURRENT_POPULATION INTEGER) VALUES (2, 'ABC', 2000)
> And when the following query is executed:
> SELECT ID, NAME FROM CITY (POPULATION INTEGER, CURRENT_POPULATION INTEGER) WHERE POPULATION
!= CURRENT_POPULATION
> It again throws the same error (
> org.apache.phoenix.schema.PTable$QualifierEncodingScheme$InvalidQualifierBytesException:
Invalid number of qualifier bytes. Expected length: 2. Actual: 10)
> 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)

Mime
View raw message