Select rows only from specific partititons


I have a table ABC. It has a shard based on one of the fields. I want to select rows only from specific partition. Something like: select * from ABC partition 10 where some_id=‘6’

Please advise.

1 Like

Welcome Benzion! :wave:

To achieve this, can you try to run:

SELECT * FROM ABC WHERE some_id = 6 AND partition_id() = 10;

Please keep us updated on how it goes.