I have installed the latest version of scylladb and cassandra in my centos os. i have tried allow filtering in select query but i don't need it, I want advance search or full text search in it, i have google it but couldn't find any solution, when i create indexes and try to run the select query it gives error "server error: not implemented: indexes". can any one help me please?
Asked
Active
Viewed 2,400 times
4
-
https://docs.datastax.com/en/dse/5.1/cql/cql/cql_using/useSASIIndex.html – Ashraful Islam Oct 18 '17 at 06:58
-
thanks for reply, unfortunately i have tried this before it gives the same error which i mentioned in question – Sahibzada Oct 18 '17 at 07:01
-
Which cassandra version are you using ? – Ashraful Islam Oct 18 '17 at 07:02
-
i am using Cassandra 3.0.8 – Sahibzada Oct 18 '17 at 07:03
-
SASI introduced in cassandra 3.4 https://github.com/apache/cassandra/blob/trunk/CHANGES.txt#L969 – Ashraful Islam Oct 18 '17 at 07:08
-
Actually i have installed the latest version of scylla where i am using cassandra, cassandra 3.0 is automatically installed with the latest version of scylla – Sahibzada Oct 18 '17 at 07:13
2 Answers
6
If you are using cassandra version 3.4 or above then you can use SSTable Attached Secondary Index (SASI).
Using CQL, SSTable attached secondary indexes (SASI) can be created on a non-collection column defined in a table. Secondary indexes are used to query a table that uses a column that is not normally queryable, such as a non primary key column. SASI implements three types of indexes, PREFIX, CONTAINS, and SPARSE.
Learn more on : https://docs.datastax.com/en/dse/5.1/cql/cql/cql_using/useSASIIndex.html
Or You could use Apache Solr or Elastic Search. So when ever any searchable data created, updated or deleted you have index or delete the data from solr or elastic search.
Ashraful Islam
- 12,470
- 3
- 32
- 53
-
i am unable to update cassandra because i am using it with scylladb in centos 7 cassandra 3.0.8 has been installed with latest scylla – Sahibzada Oct 18 '17 at 10:04
-
-
i can not use apache solr and elastic search because i am using datastax cassandra not apache cassandra – Sahibzada Oct 18 '17 at 10:14
-
6
Scylla is actively working to enable secondary indexes. Expecting to have a working solution with 2.2 release http://www.scylladb.com/product/technology/scylla-roadmap/
To currently support a full text search with Scylla, an auxiliary solution such as Solr or Elasticsearch is needed, the following link explains how to combine a Scylla and Elasticsearch
http://www.scylladb.com/2017/08/03/data-analytics-elastic-scylla/
gutkinde
- 405
- 2
- 5