Select rows only from specific partititons

Help Procedural SQL
1

Hi,

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
2

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.

2 Likes