phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From " Ayden Bissessar (JIRA)" <>
Subject [jira] [Created] (PHOENIX-4991) Query fails when mixing different types of IN clauses
Date Wed, 24 Oct 2018 22:08:00 GMT
 Ayden Bissessar created PHOENIX-4991:

             Summary: Query fails when mixing different types of IN clauses
                 Key: PHOENIX-4991
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.13.1
            Reporter:  Ayden Bissessar

When mixing different types of IN clauses in a query, we get a failure of:
java.sql.SQLException: ERROR 201 (22000): Illegal data. Expected length of at least 8 bytes,
but had 2
>From my experience, you see this error when Phoenix cannot understand the values from
HBase, typically when you have inserted data outside of Phoenix. Why would we see this same
error when different versions of the query return the results fine?

# Query 1 - WORKS: One column per IN clause only
"id1" in (1234,5678) and "id2" in (8642,2468) and "id3" IN (1,2,3);


# Query 2 - WORKS: Combined column IN clause only
("id1","id2","id3") IN ((1234,8642,,1),(5678,2468,1));


# Query 3 - FAILS: Combined column method AND one column method
("id1","id2") IN ((1234,8642),(5678,2468)) AND "id3" IN (1,2,3);
My guess would be query 3 isn't officially supported, but would like some more information.
Why would changing this cause an illegal amount of bytes to be returned?

This message was sent by Atlassian JIRA

View raw message