Is it possible to filter data using stripe_num directly from SQL ?

Open rferraton opened this issue 3 months ago • 2 comments

Something like

SELECT * FROM schema.table WHERE stripe_num = 10

Sep 04 '25 14:09 rferraton

Unfortunately no as it's not an attribute of the relation.

Could you share a bit more about your use case so I can better understand what you’re aiming for?

Sep 08 '25 11:09 onurctirtir

hello @onurctirtir : i would like to split the data for even parallel extraction from an external client without having to now the business (classic) column distribution. With classic tables i do this using ctid. But ctid is not available with citus columnar table.

Sep 08 '25 14:09 rferraton