TheBuilderJR opened a new issue, #13957:
URL: https://github.com/apache/datafusion/issues/13957
### Describe the bug
I have an analytics service and I want to impute dates we no data with 0
in clickhouse I can do something like
```
timeseries AS (
WITH
toDateTime(${timeCoersion}(toDateTime(${start}, '${timezone}')),
'${timezone}') as start_date,
toDateTime(${end}) AS end_date
select
arrayJoin(
arrayMap(
x ->
toDateTime(${timeCoersion}(toDateTime(x,
'${timezone}')), '${timezone}'),
range(
toUInt32(toDateTime(start_date)),
toUInt32(toDateTime(end_date)),
${granularity}
)
)
) as date
where date <= now()
),
```
but it seems that datafusion has no such afforance
### To Reproduce
try to mimic the query above in datafusion
### Expected behavior
it runs and imputes correctly
### Additional context
_No response_
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
