Hi, I have this problem from time to time, and then it disappears for the same query. I can’t seem to find out why. I have tried so many ways to debug, but no luck. It is making my system unstable as it comes and goes for the exact same data.
Endpoints of an Interval should have the same type.
This was likely caused by a bug in DataFusion’s code and we would welcome that you file an bug report in our issue tracker: rpc error: code = Internal desc = Error while planning query: order_union_sorted_inputs: Internal error: Endpoints of an Interval should have the same type.
This was likely caused by a bug in DataFusion’s code and we would welcome that you file an bug report in our issue tracker
This is the query:
SELECT * FROM device_data WHERE device_id = 1000 ORDER BY message_timestamp DESC LIMIT 1
It works if I run
SELECT * FROM device_data WHERE device_id = 1000 LIMIT 1
I have run and the data looks good.
SELECT MIN(message_timestamp), MAX(message_timestamp)
FROM device_data
WHERE device_id = 1000
And this one returns nothing.
SELECT message_timestamp, device_id
FROM device_data
WHERE device_id = 1000
AND (message_timestamp::TEXT ~ ‘[^0-9]’)
LIMIT 20;
