[ https://issues.apache.org/jira/browse/DRILL-7348?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16907999#comment-16907999 ]
Arina Ielchiieva commented on DRILL-7348: ----------------------------------------- [~snapdoodle] please provide dataset and actual and expected results. > Aggregate on Subquery with Select Distinct or UNION fails to Group By > --------------------------------------------------------------------- > > Key: DRILL-7348 > URL: https://issues.apache.org/jira/browse/DRILL-7348 > Project: Apache Drill > Issue Type: Bug > Components: Functions - Drill > Affects Versions: 1.15.0 > Reporter: Keith G Yu > Priority: Major > > The following query fails to group properly. > {code:java} > SELECT date, COUNT(1) > FROM ( > SELECT DISTINCT > id, > date, > status > FROM table(dfs.`path`(type => 'text', fieldDelimiter => ',', > extractHeader => TRUE)) > ) > GROUP BY 1{code} > This also fails to group properly. > {code:java} > 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 > {code} -- This message was sent by Atlassian JIRA (v7.6.14#76016)