[PHOENIX-2965] Use DistinctPrefixFilter logic for COUNT(DISTINCT ...) and COUNT(...) GROUP BY - ASF JIRA

XML

Word

Printable

JSON

Details

Type: Sub-task
Status: Closed
Priority: Major
Resolution: Fixed
Affects Version/s: None
Fix Version/s: 4.8.0
Component/s: None
Labels:
None

Description

Parent uses skip scanning to optimize DISTINCT and certain GROUP BY operations along the row key.
COUNT queries are optimized differently, could be sped up significantly as well.

giacomotaylor, I might need to help into where COUNT(DISTINCT) queries are planned and optimized.

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending

2965.txt
07/Jun/16 21:37
13 kB
Lars Hofhansl
2965-v2.txt
08/Jun/16 00:28
14 kB
Lars Hofhansl
2965-v3.txt
08/Jun/16 18:00
14 kB
Lars Hofhansl
2965-v4.txt
08/Jun/16 20:14
22 kB
Lars Hofhansl
2965-v5.txt
08/Jun/16 20:38
23 kB
Lars Hofhansl
2965-v6.txt
09/Jun/16 04:41
23 kB
Lars Hofhansl
PHOENIX-2965_wip.patch
10/Jun/16 17:43
1 kB
James R. Taylor
2965-v7.txt
11/Jun/16 02:40
11 kB
Lars Hofhansl
2965-v8.txt
11/Jun/16 04:07
10 kB
Lars Hofhansl
2965-v9.txt
11/Jun/16 04:50
10 kB
Lars Hofhansl
2965-v10.txt
12/Jun/16 01:02
11 kB
Lars Hofhansl
2965-v11.txt
12/Jun/16 05:07
12 kB
Lars Hofhansl
2965-v12.txt
12/Jun/16 15:25
13 kB
Lars Hofhansl
2965-v13.txt
12/Jun/16 17:12
12 kB
Lars Hofhansl
2965-v14.txt
12/Jun/16 18:05
15 kB
Lars Hofhansl

Issue Links

relates to

PHOENIX-2974 SELECT COUNT(DISTINCT c1, c2,...) throws NPE

Open

Activity

People

Assignee:: Lars Hofhansl

Reporter:: Lars Hofhansl

Votes:: 0 Vote for this issue

Watchers:: 7 Start watching this issue

Dates

Created:: 05/Jun/16 00:50

Updated:: 11/Aug/16 08:27

Resolved:: 12/Jun/16 18:20