Hello,

Is it possible to use the "where partition_key in (...)" clause if the partition key has a composite type?

I have a schema as follows:

create table tbl (
   k1 int,
   k2 varchar,
   k3 varchar,
   m blob,
   primary key((k1, k2), k3)
)

I would like to be able to do something like

select m from tbl where (k1, k2) in ((0, 'abc'), (1, 'xyz'));

I think though that I'll have to use the more verbose

begin unlogged batch
select m from tbl where k1=0 and k2='abc'
select m from tbl where k1=1 and k2='xyz'
apply batch;

Thanks,
Sorin

Reply via email to