-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Not A Problem
-
Affects Version/s: 1.15.0
-
Fix Version/s: None
-
Component/s: Functions - Drill
-
Labels:None
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