hosswald opened a new issue, #13152:
URL: https://github.com/apache/druid/issues/13152
### Affected Version
0.23.0
### Description
The following query
```sql
SELECT *
FROM "druid"."mydata"
WHERE false
ORDER BY "__time" DESC
```
leads to the following error:
`druid error: Unsupported operation (org.apache.druid.java.util.common.UOE):
Time-ordering on scan queries is only supported for queries with segment specs
of type MultipleSpecificSegmentSpec or SpecificSegmentSpec...a
[MultipleIntervalSegmentSpec] was received instead.`
false can be an arbitrary unsatisfiable boolean expression. I came across it
when trying to filter for a specific exact timestamp in Superset, which is
translated into the unsatisfiable expression
```sql
WHERE MILLIS_TO_TIMESTAMP(recordTimeParsed) >=
TIME_PARSE('2022-09-25T00:00:00')
AND MILLIS_TO_TIMESTAMP(recordTimeParsed) <
TIME_PARSE('2022-09-25T00:00:00')
```
Since it seems to be valid vor any unsatisfiable WHERE clause, I'm omitting
details about my specific dataset.
--
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]
