Hi,
I read somewhere that the order of columns in the cluster key matters.
Please correct me if I am wrong.
For example,
PRIMARY KEY((prodgroup), status, productid).
Then the below query cannot run,
select * from product where prodgroup='xyz' and prodid > 0
But this query can be run:
select *
Your proposed model for the table to handle the last query looks good, so I
would stick with that.
On Mon, Jan 5, 2015 at 5:45 AM, Nagesh wrote:
> Hi All,
>
> I have designed a column family
>
> prodgroup text, prodid int, status int, , PRIMARY KEY ((prodgroup),
> prodid, status)
>
> The data mo
