manasa-konidena opened a new issue, #15072:
URL: https://github.com/apache/druid/issues/15072
Please provide a detailed title (e.g. "Broker crashes when using TopN query
with Bound filter" instead of just "Broker crashes").
### Affected Version
The Druid version where the problem was encountered.
2023.01.4-lts-iap
### Description
I am not able pass mofo (has time zone data) in dynamic way to time_extract
function
```
select beyoch, TIME_EXTRACT(MILLIS_TO_TIMESTAMP(beyoch), 'DOW', mofo) from (
SELECT
_timestamp as beyoch,
COALESCE(location_timezone, 'UTC') AS mofo
FROM
podcastStreams
WHERE
DATE_TRUNC('day', MILLIS_TO_TIMESTAMP(_timestamp)) >=
TIME_PARSE('2023-08-12')
AND DATE_TRUNC('day', MILLIS_TO_TIMESTAMP(_timestamp)) <=
TIME_PARSE('2023-08-31')
AND MV_OVERLAP(podcast_id,
Array['d2559f3c-54a3-11e9-85f3-4b0dc7ea6463']) = 1
AND is_stream = 1
AND location_timezone is not null
)
```
Please include as much detailed information about the problem as possible.
- Cluster size
- Configurations in use
- Steps to reproduce the problem
- The error message or stack traces encountered. Providing more context,
such as nearby log messages or even entire logs, can be helpful.
- Any debugging that you have already done
--
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]
