You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository has been archived by the owner on May 27, 2020. It is now read-only.
CREATE CUSTOM INDEX idx ON test(lucene)
USING 'com.stratio.cassandra.lucene.Index'
WITH OPTIONS = {
'schema': '{
fields: {
json_text: {type: "json"}
}
}'
};
And do queries like below or anything similar :
SELECT * FROM test WHERE expr(lucene, '{
filter: {
type: "match",
field: "json_text.key1",
value: "Value1"
}
}');
I know I can use maps to achieve what I am trying to do here with json text column. But, I have read about and faced issues with huge maps in Cassandra. So, trying to avoid maps and trying to get similar functionality with strings. Any suggestions?
The text was updated successfully, but these errors were encountered:
My intention here is not to get results back as JSON, but to index my string column as json.
Checking if something of this sort is possible with Stratio indexes.
Sign up for freeto subscribe to this conversation on GitHub.
Already have an account?
Sign in.
Is there a way, using stratio index, I can index a text column in my Cassandra table as a json object and query on the keys with in the json?
For example consider the below table structure :
CREATE TABLE test (pk int PRIMARY KEY, json_text text, lucene text);
My data in this table looks like this :
Can I create any such index :
And do queries like below or anything similar :
I know I can use maps to achieve what I am trying to do here with json text column. But, I have read about and faced issues with huge maps in Cassandra. So, trying to avoid maps and trying to get similar functionality with strings. Any suggestions?
The text was updated successfully, but these errors were encountered: