Re: [E] bug in cluster key push down

2020-01-13 Thread Hannu Kröger
No, I think it was originally correct. If partition key has multiple parts, then you need parenthesis around parts of partition key. Hannu > On 13. Jan 2020, at 14.30, Saha, Sushanta K > wrote: > >> primary key (partition, clustering1, clustering2) >> >> So, the partitioning key has three c

Re: [E] Re: bug in cluster key push down

2020-01-13 Thread Saha, Sushanta K
*primary key (partition, clustering1, clustering2)* So, the partitioning key has three columns. You need to specify values for all three columns. For clustering columns, you need another parenthesis like *primary key (partition, (clustering1, clustering2))* * Sushanta* On Sun, Jan 12, 2020

Re: bug in cluster key push down

2020-01-12 Thread onmstester onmstester
-It’s probably just a logging / visibility problem, but we should confirm  I think it is. Cause with tracing on, cqlsh logs that "read 1 live rows... " for the query with both clustering key restricted but the whole partition (with no clustering key restriction) has 12 live rows, so i suppo

Re: bug in cluster key push down

2020-01-12 Thread onmstester onmstester
Done. https://issues.apache.org/jira/browse/CASSANDRA-15500 Sent using https://www.zoho.com/mail/ On Sun, 12 Jan 2020 19:22:33 +0330 Jeff Jirsa wrote Can you open a jira so someone can investigate ? It’s probably just a logging / visibility problem, but we should confirm  Sent

Re: bug in cluster key push down

2020-01-12 Thread Jeff Jirsa
Can you open a jira so someone can investigate ? It’s probably just a logging / visibility problem, but we should confirm Sent from my iPhone > On Jan 12, 2020, at 6:04 AM, onmstester onmstester > wrote: > >  > Using Apache Cassandra 3.11.2, defined a table like this: > > create table my_t

bug in cluster key push down

2020-01-12 Thread onmstester onmstester
Using Apache Cassandra 3.11.2, defined a table like this: create table my_table(                    partition text,            clustering1 int,       clustering2 text,       data set,     primary key (partition, clustering1, clustering2)) and con