Documentation

Apache Lucene

You can add the Apache Lucene add-on to Apache Cassandra clusters to avail the functionality of indexing cluster data which allows you to search on the cluster data at blazing speed.

With Lucene index, you get advanced search capabilities including full-text search, multivariable, geospatial and bi-temporal search.

Cassandra Setup

In this example, we will create a Lucene index and search using the index.

Creating Lucene Index

CREATE CUSTOM INDEX test_index ON test ()
USING 'com.stratio.cassandra.lucene.Index'
WITH OPTIONS = {
'refresh_seconds': '1',
'schema': '{
fields: {
si: {type: "integer"},
name: {type: "string"},
gender: {type: "string"}
} }' };

CREATE CUSTOM INDEX test_index ON test ()

USING 'com.stratio.cassandra.lucene.Index'

WITH OPTIONS = {

'refresh_seconds': '1',

'schema': '{

fields: {

si: {type: "integer"},

name: {type: "string"},

gender: {type: "string"}

} }' };

Searching using index with one field

SELECT * FROM test WHERE expr(test_index, '{
    query : {type:"match", field:"name", value:"kinley"}
}');

SELECT * FROM test WHERE expr(test_index, '{

query : {type:"match", field:"name", value:"kinley"}

}');

Searching using index with multiple field

SELECT * FROM test WHERE expr(test_index, '{
    query : [
        {type:"match", field:"name", value:"kinley"},
        {type:"match", field:"gender", value:"male"}
    ]
}');

SELECT * FROM test WHERE expr(test_index, '{

query : [

{type:"match", field:"name", value:"kinley"},

{type:"match", field:"gender", value:"male"}

]

}');

By Instaclustr Support

Previous Article Useful Apache Spark References Next Article Continuous Backup

Need Support?

Learn More

Experiencing difficulties on the website or console?

Status page for known incidents

Already have an account?

Need help with your cluster?

Contact Support

Why sign up?

To experience the ease of creating and managing clusters via the Instaclustr Console

Spin up a cluster in minutes

Free Trial