phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Samarth Jain (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-3904) Queries with LIKE and LIMIT OFFSET fail for mutable tables with column mapping enabled
Date Fri, 02 Jun 2017 15:13:04 GMT

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

Samarth Jain commented on PHOENIX-3904:
---------------------------------------

MutableIndexFailureIT is a known flapper.

[~jamestaylor], does this change in BaseResultIterators look good to you? 

{code}
+                    if (Bytes.equals(cf, SchemaUtil.getEmptyColumnFamily(table))) {
+                        // if the column family is also the empty column family, project
the
+                        // empty key value column
+                        Pair<byte[], byte[]> emptyKeyValueInfo =
+                                EncodedColumnsUtil.getEmptyKeyValueInfo(table);
+                        qualifierSet.add(emptyKeyValueInfo.getFirst());
+                    }
+                    // In case of a keyOnlyFilter, we only need to project the empty key
value column
+                    if (qualifierRangeForFamily != null && !keyOnlyFilter) {
+                        // On the scan, only project the columns in the range.

{code}

For cases where the where clause is on PK or when the empty column family was added to the
scan, I am now making sure that we project the empty key value column explicitly.

> Queries with LIKE and LIMIT OFFSET fail for mutable tables with column mapping enabled
> --------------------------------------------------------------------------------------
>
>                 Key: PHOENIX-3904
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-3904
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: Samarth Jain
>            Assignee: Samarth Jain
>             Fix For: 4.11.0
>
>         Attachments: PHOENIX-3904.patch, PHOENIX-3904_v2.patch, PHOENIX-3904_v3.patch,
PHOENIX-3904_v4.patch, PHOENIX-3904_v5.patch
>
>
> Details:
> https://stackoverflow.com/questions/44214659/qualifier-out-of-valid-range-error-in-apache-phoenix-select-with-where-and-of



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message