cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brandon Williams (Jira)" <j...@apache.org>
Subject [jira] [Updated] (CASSANDRA-14344) Support filtering using IN restrictions
Date Mon, 16 Aug 2021 16:56:00 GMT

     [ https://issues.apache.org/jira/browse/CASSANDRA-14344?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Brandon Williams updated CASSANDRA-14344:
-----------------------------------------
    Description: 
              Support IN filter query like this:

 
 CREATE TABLE ks1.t1 (
     key int,
     col1 int,
     col2 int,
     value int,
     PRIMARY KEY (key, col1, col2)
 ) WITH CLUSTERING ORDER BY (col1 ASC, col2 ASC)
  
 cqlsh:ks1> select * from t1 where key = 1 and col2 in (1) allow filtering;
  
  key | col1 | col2 | value
 -----++------------+-------
    1 |    1 |    1 |     1
    1 |    2 |    1 |     3
  
 (2 rows)
 cqlsh:ks1> select * from t1 where key = 1 and col2 in (1, 2) allow filtering;
 *{color:#ff0000}InvalidRequest: Error from server: code=2200 [Invalid query] message="IN
restrictions are not supported on indexed columns"{color}*
 cqlsh:ks1>

  was:
Support IN filter query like this:

 
CREATE TABLE ks1.t1 (
    key int,
    col1 int,
    col2 int,
    value int,
    PRIMARY KEY (key, col1, col2)
) WITH CLUSTERING ORDER BY (col1 ASC, col2 ASC)
 
cqlsh:ks1> select * from t1 where key = 1 and col2 in (1) allow filtering;
 
 key | col1 | col2 | value
-----+------+------+-------
   1 |    1 |    1 |     1
   1 |    2 |    1 |     3
 
(2 rows)
cqlsh:ks1> select * from t1 where key = 1 and col2 in (1, 2) allow filtering;
*{color:#ff0000}InvalidRequest: Error from server: code=2200 [Invalid query] message="IN restrictions
are not supported on indexed columns"{color}*
cqlsh:ks1>


> Support filtering using IN restrictions
> ---------------------------------------
>
>                 Key: CASSANDRA-14344
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-14344
>             Project: Cassandra
>          Issue Type: New Feature
>          Components: Legacy/CQL
>            Reporter: Dikang Gu
>            Assignee: Venkata Harikrishna Nukala
>            Priority: Normal
>             Fix For: 4.x
>
>         Attachments: 14344-trunk-2.txt, 14344-trunk-3.patch, 14344-trunk-inexpression-approach-2.txt,
14344-trunk-inexpression-approach.txt, 14344-trunk.txt
>
>
>               Support IN filter query like this:
>  
>  CREATE TABLE ks1.t1 (
>      key int,
>      col1 int,
>      col2 int,
>      value int,
>      PRIMARY KEY (key, col1, col2)
>  ) WITH CLUSTERING ORDER BY (col1 ASC, col2 ASC)
>   
>  cqlsh:ks1> select * from t1 where key = 1 and col2 in (1) allow filtering;
>   
>   key | col1 | col2 | value
>  -----++------------+-------
>     1 |    1 |    1 |     1
>     1 |    2 |    1 |     3
>   
>  (2 rows)
>  cqlsh:ks1> select * from t1 where key = 1 and col2 in (1, 2) allow filtering;
>  *{color:#ff0000}InvalidRequest: Error from server: code=2200 [Invalid query] message="IN
restrictions are not supported on indexed columns"{color}*
>  cqlsh:ks1>



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org


Mime
View raw message