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] [Commented] (PHOENIX-2666) Performance regression: Aggregate query with filter on table with multiple column families
Date Tue, 09 Feb 2016 17:06:18 GMT

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

James Taylor commented on PHOENIX-2666:
---------------------------------------

[~mujtabachohan] - would it be possible for you to let us know the guideposts info for the
column family containing {{last_column}} versus the guideposts for the column family of the
first declared column?

> 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
>             Fix For: 4.7.0
>
>
> 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