John M.

03/06/2023, 6:47 PM
Is it possible to query on a partition name? So for example I have a time field, and I have my table partitioned by day on the time field, but I'd like to be able to query things like: "SELECT * FROM table WHERE date=x" -- is this possible? or do I have to do some type of time>x and time<y?

Bolek Ziobrowski

03/06/2023, 6:55 PM
If you query on designated timestamp, e.g.
select * from table where date in '2023-01-01'
then qdb will limit scanning to the time interval . Same with
date >= '2023-01-01T00:00:00.000000' and date < '2023-01-02T00:00:00.000000'

John M.

03/06/2023, 7:01 PM
thank you this is very helpful