[
https://issues.apache.org/jira/browse/PHOENIX-2666?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mujtaba Chohan reopened PHOENIX-2666:
-------------------------------------
This 4x perf. regression happens even with setting
{{phoenix.query.threadPoolSize}} to 1 and with empty stats table.
Got same explain plan before and after the
[commit|https://git-wip-us.apache.org/repos/asf?p=phoenix.git;a=commitdiff;h=3fdaecdaaa2a2f07070df67f861252fd44e338c3]
causing regression.
{code}CLIENT 4-CHUNK PARALLEL 1-WAY FULL SCAN OVER TABLE_6CF SERVER FILTER BY
CF6.F < 1000000 SERVER AGGREGATE INTO SINGLE ROW{code}
> 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: Thomas D'Silva
> 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)
