phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Taylor (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (PHOENIX-2666) Performance regression: Aggregate query with filter on table with multiple column families
Date Wed, 17 Feb 2016 00:41:18 GMT

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

James Taylor edited comment on PHOENIX-2666 at 2/17/16 12:40 AM:
-----------------------------------------------------------------

As usual, [~mujtabachohan] was correct. :-) We weren't projecting the columns being filtered
on for the case where we don't project the empty key value. This patch fixes that. Please
review, [~tdsilva].


was (Author: jamestaylor):
As usual, [~mujtabachohan] was correct. :-) We weren't projecting the columns being filtered
on for the case where we don't project the empty key value. This patch fixes that.

> Performance regression: Aggregate query with filter on table with multiple column families
> ------------------------------------------------------------------------------------------
>
>                 Key: PHOENIX-2666
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-2666
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.7.0
>            Reporter: Mujtaba Chohan
>            Assignee: James Taylor
>             Fix For: 4.7.0
>
>         Attachments: PHOENIX-2666.patch
>
>
> In the test, table contains total of 6 columns with one column per column family.
> Running a query  {code}select count(*) from T where last_column < ?{code} is 4x slower
after commit for PHOENIX-1312 (https://git-wip-us.apache.org/repos/asf?p=phoenix.git;a=commit;h=3fdaecdaaa2a2f07070df67f861252fd44e338c3)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message