limhwanhee opened a new issue, #15740:
URL: https://github.com/apache/druid/issues/15740
Please provide a detailed title (e.g. "Broker crashes when using TopN query
with Bound filter" instead of just "Broker crashes").
### Affected Version
24.0.0
### Description
I have a Table like the one below.
|__time |test1|test2|start_time|value|
|---|---|---|---|----|
|2024-01-23T00:00:00.000Z|A|C|2024/01/23 00:00:00|1|
|2024-01-23T00:00:00.100Z|A|C|2024/01/23 00:00:00|2|
|2024-01-23T00:00:00.200Z|B|C|2024/01/23 00:00:00|3|
|...|...|...|...|...|
|2024-01-23T00:01:00.000Z|A|C|2024/01/23 00:00:00|1|
|2024-01-23T00:01:00.100Z|A|C|2024/01/23 00:00:00|2|
|2024-01-23T00:01:00.200Z|B|C|2024/01/23 00:00:00|3|
|...|...|...|...|...|
Write the query statement as follows.
```
select * from (SELECT __time, test1, test2, TIME_PARSE("start_time",
'yyyy/MM/dd HH:mm:ss') as "stime", value from test_table order by __time)
where "stime" >= TIMESTAMP '2024-01-24 00:00:00'
order by __time
```
The correct answer I expect is
|__time |test1|test2|stime|value|
|---|---|---|---|----|
|2024-01-24T00:00:00.000Z|C|A|2024-01-24T00:00:00Z|1|
|2024-01-24T00:00:00.100Z|C|A|2024-01-24T00:00:00Z|2|
|2024-01-24T00:00:00.200Z|C|A|2024-01-24T00:00:00Z|3|
|...|...|...|...|...|
|2024-01-24T00:01:00.000Z|F|X|2024-01-24T00:00:00Z|1|
|2024-01-24T00:01:00.100Z|F|X|2024-01-24T00:00:00Z|2|
|2024-01-24T00:01:00.200Z|F|X|2024-01-24T00:00:00Z|3|
|...|...|...|...|...|
However, the result is shown below.
|__time |test1|test2|stime|value|
|---|---|---|---|----|
|2024-01-24T00:00:00.000Z|C|A|2024-01-24T23:56:xxZ|1|
|2024-01-24T00:00:00.100Z|C|A|2024-01-24T23:xx:xxZ|2|
|2024-01-24T00:00:00.200Z|C|A|2024-01-24T23:59:xxZ|3|
|...|...|...|...|...|
|2024-01-24T00:01:00.000Z|F|X|2024-01-24T23:xx:xxZ|1|
|2024-01-24T00:01:00.100Z|F|X|2024-01-24T23:xx:xxZ|2|
|2024-01-24T00:01:00.200Z|F|X|2024-01-24T23:xx:xxZ|3|
|...|...|...|...|...|
The original table has a normal start_time.
What could be the cause?
--
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]
