You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
Incorrect answers with SELECT DISTINCT queries #250
> CREATE EXTERNAL TABLE t(col varchar)
STORED AS CSV
LOCATION '/tmp/foo.csv';
0 rows in set. Query took 0 seconds.
> SELECT DISTINCT col from t
> ;
+-----+
| col |
+-----+
| A |
| B |
| B |
| B |
+-----+
Expected behavior
Expected results are no duplicates. The output should contain only 2 rows with values of A and B
Additional context
I suspect we are just ignoring the distinct on these queries. We could "fix" the bug by generating an error about the feature being unsupported. Bonus points would be to add a group by operator on top of the plan to remove duplicates (e.g. group by all the items in the select list)
Activity
Avoid calling shutdown after failed write of AsyncWrite (#249) (#250) (…
Avoid calling shutdown after failed write of AsyncWrite (apache#249) (a…
Avoid calling shutdown after failed write of AsyncWrite (apache#249) (a…
Avoid calling shutdown after failed write of AsyncWrite (apache#249) (a…
feat: Enable columnar shuffle by default (apache#250)