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
After IOx upgraded DF recently, we hit a bug in count distinct with date_bin/date_part.
To Reproduce
After some investigation, here is the reproducer in Datafusion CLI:
createtablet1(state string, city string, min_temp float, area int, timetimestamp) asvalues
('MA', 'Boston', 70.4, 1, 50),
('MA', 'Bedford', 71.59, 2, 150);
select date_part('year', time) as bla, count(distinct state) as count from t1 group by bla;
-- Optimizer rule 'single_distinct_aggregation_to_group_by' failed caused by Schema error: No field named "date_part(Utf8(""year""),t1.time)". Valid fields are group_alias_0, "COUNT(DISTINCT t1.state)".-- this query has the same issueselect date_bin(interval '1 year', time) as bla, count(distinct state) as count from t1 group by bla;
Expected behavior
The queries should work
Additional context
After I backed out 15d8c9b locally, the queries work
The text was updated successfully, but these errors were encountered:
alamb
changed the title
Count distinct with date_part/date_bin does not work
Regression: Count distinct with date_part/date_bin does not work
Nov 14, 2023
Describe the bug
After IOx upgraded DF recently, we hit a bug in count distinct with
date_bin
/date_part
.To Reproduce
After some investigation, here is the reproducer in Datafusion CLI:
Expected behavior
The queries should work
Additional context
After I backed out 15d8c9b locally, the queries work
The text was updated successfully, but these errors were encountered: