[DRILL-7348] Aggregate on Subquery with Select Distinct or UNION fails to Group By

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: 1.15.0
• Component/s: Functions - Drill
• Assignee: Unassigned
• Reporter: Keith G Yu
• Created: 14/Aug/19 20:33
• Updated: 09/Oct/19 15:39
• Resolved: 09/Oct/19 15:39

Description

The following query fails to group properly.

SELECT date, COUNT(1)
FROM (
    SELECT DISTINCT
        id,
        date,
        status
    FROM table(dfs.`path`(type => 'text', fieldDelimiter => ',', extractHeader => TRUE))
)
GROUP BY 1

This also fails to group properly.

SELECT date, COUNT(1)
FROM (
    SELECT
        id,
        date,
        status
    FROM table(dfs.`path1`(type => 'text', fieldDelimiter => ',', extractHeader => TRUE))
    UNION
    SELECT
        id,
        date,
        status
    FROM table(dfs.`path2`(type => 'text', fieldDelimiter => ',', extractHeader => TRUE))
)
GROUP BY 1