Hello,

Let us consider that we have a table t created as follows:

create table t(k1 vachar, k2 varchar, value varchar, primary key (k1, k2));

Its contents is

a m x
a n y
z 0 9
z 1 8

and I perform a

select * from p where k1 in ('a', 'z');

Is it guaranteed that the rows are grouped by the value of the partition key? That is, is it guaranteed that I'll get

a m x
a n y
z 0 9
z 1 8

or

a n y
a m x
z 1 8
z 0 9

or even

z 0 9
z 1 8
a n y
a m x

but NEVER

a m x
z 0 9
a n y
z 1 8


Thank you,
Sorin

Reply via email to