nosql - IN operator in Cassandra doesn't work for table having a column with type-collection(Map or List) -
I am working on the cassandra to know how it works Some strange when using the IN operator Talked. Example:
Table: Create table test_time (name text, age, time, time, time id, "timestamp" timestamp, primary key ((name, age), time))
I have inserted some dummy data in the operator as follows: test_time to SELECT * where name = "9" and age = 81 and time IN (c7c88000-190e-11e4-8000- 000000000000, c7c88000-190e-11e4-7000-000000000000);
It worked properly.
Then, a column type was added to map
. The table will look like this: create test test_time (Name text, age, time, time-time, name_age map, lit, text, interval, timestamp, timestamp, primary key ((name, age), time) / Code> On executing the same question, I found the following error:
Bad request: The main part can not be restricted in the primary relationship in these relations because the query is selected by the archive
above From the examples, we can say, if the operator has any column of type collection (map or list) in the table, then it does not work.
I do not understand why this happens, please tell me if I am missing anything. thank you in advanced.
Yes ... this is a limitation, you can do the following:
- Select
... from where name = '9' and age = 81 and time & gt; X and time & lt; Y
-
Select [Column Excluding Column] ... where name = '9' and age = 81 more time (...)
You can then filter the client side, or do any other query.
Comments
Post a Comment