table-comments-vs
INSERT INTO cycling.comments_vs (record_id, id, commenter, comment, created_at, comment_vector) VALUES (now(),e7ae5cf3-d358-4d99-b900-85902fda9bb0, 'Alex','Raining too hard should have postponed','2017-02-14 12:43:20-0800',[0.45, 0.09, 0.01, 0.2, 0.11]);
INSERT INTO cycling.comments_vs (record_id, id, commenter, comment, created_at, comment_vector) VALUES (now(),e7ae5cf3-d358-4d99-b900-85902fda9bb0,'Alex','Second rest stop was out of water','2017-03-21 13:11:09.999-0800',[0.99, 0.5, 0.99, 0.1, 0.34]);
INSERT INTO cycling.comments_vs (record_id, id, commenter, comment, created_at, comment_vector) VALUES (now(),e7ae5cf3-d358-4d99-b900-85902fda9bb0,'Alex','LATE RIDERS SHOULD NOT DELAY THE START','2017-04-01 06:33:02.16-0800',[0.9, 0.54, 0.12, 0.1, 0.95]);
INSERT INTO cycling.comments_vs (record_id, id, commenter, comment, created_at, comment_vector) VALUES (now(),c7fceba0-c141-4207-9494-a29f9809de6f,'Amy','The gift certificate for winning was the best',totimestamp(now()),[0.13, 0.8, 0.35, 0.17, 0.03]);
INSERT INTO cycling.comments_vs (record_id, id, commenter, comment, created_at, comment_vector) VALUES (now(),c7fceba0-c141-7207-9494-a29f9809de6f,'Amy','The <B>gift certificate</B> for winning was the best',totimestamp(now()),[0.13, 0.8, 0.35, 0.17, 0.03]);
INSERT INTO cycling.comments_vs (record_id, id, commenter, comment, created_at, comment_vector) VALUES (now(),c7fceba0-c141-4207-9494-a29f9809de6f,'Amy','Glad you ran the race in the rain','2017-02-17 12:43:20.234+0400',[0.3, 0.34, 0.2, 0.78, 0.25]);
INSERT INTO cycling.comments_vs (record_id, id, commenter, comment, created_at, comment_vector) VALUES (now(),c7fceba0-c141-4207-9594-a29f9809de6f,'Jane','Boy, was it a drizzle out there!','2017-02-17 12:43:20.234+0400',[0.3, 0.34, 0.2, 0.78, 0.25]);
INSERT INTO cycling.comments_vs (record_id, id, commenter, comment, created_at, comment_vector) VALUES (now(), c7fceba0-c141-3207-9494-a29f9809de6f,'Amy','THE RACE WAS FABULOUS!','2017-02-17 12:43:20.234+0400',[0.3, 0.34, 0.2, 0.78, 0.25]);
INSERT INTO cycling.comments_vs (record_id, id, commenter, comment, created_at, comment_vector) VALUES (now(),c7fceba0-c141-4207-9494-a29f9809de6f, 'Amy','Great snacks at all reststops','2017-03-22 5:16:59.001+0400',[0.1, 0.4, 0.1, 0.52, 0.09]);
INSERT INTO cycling.comments_vs (record_id, id, commenter, comment, created_at, comment_vector) VALUES (now(),c7fceba0-c141-4207-9494-a29f9809de6f,'Amy','Last climb was a killer','2017-04-01 17:43:08.030+0400',[0.3, 0.75, 0.2, 0.2, 0.5]);
INSERT INTO cycling.comments_vs (record_id, id, commenter, comment, created_at, comment_vector) VALUES (now(),e8ae5cf3-d358-4d99-b900-85902fda9bb0,'John','rain, rain,rain, go away!','2017-04-01 06:33:02.16-0800',[0.9, 0.54, 0.12, 0.1, 0.95]);
INSERT INTO cycling.comments_vs (record_id, id, commenter, comment, created_at, comment_vector) VALUES (now(),e8ae5df3-d358-4d99-b900-85902fda9bb0,'Jane','Rain like a monsoon','2017-04-01 06:33:02.16-0800',[0.9, 0.54, 0.12, 0.1, 0.95]); CREATE CUSTOM INDEX comment_all_ann_options_idx
ON cycling.comments_vs (comment_vector)
WITH OPTIONS = { 'similarity_function': 'COSINE', 'source_model': 'bert'}; CREATE CUSTOM INDEX comment_all_ann_options_idx
ON cycling.comments_vs (comment_vector) USING 'sai'
WITH OPTIONS = { 'similarity_function': 'COSINE', 'source_model': 'bert'}; CREATE CUSTOM INDEX comment_all_ann_options_idx
ON cycling.comments_vs (comment_vector) USING 'StorageAttachedIndex'
WITH OPTIONS = { 'similarity_function': 'COSINE', 'source_model': 'bert'}; CREATE CUSTOM INDEX comment_keyword_htmlstrip_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
{
"tokenizer" : {"name" : "keyword"},
"charFilters" : [{"name" : "htmlstrip"}]
}'}; CREATE CUSTOM INDEX comment_keyword_htmlstrip_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
{
"tokenizer" : {"name" : "keyword"},
"charFilters" : [{"name" : "htmlstrip"}]
}'}; CREATE CUSTOM INDEX comment_keyword_htmlstrip_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
{
"tokenizer" : {"name" : "keyword"},
"charFilters" : [{"name" : "htmlstrip"}]
}'}; CREATE CUSTOM INDEX comment_language_lowercase_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
{"tokenizer" : {"name" : "standard"},
"filters" : [{"name" : "lowercase"}, {"name" : "czechstem"}]
}'}; CREATE CUSTOM INDEX comment_language_lowercase_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
{"tokenizer" : {"name" : "standard"},
"filters" : [{"name" : "lowercase"}, {"name" : "czechstem"}]
}'}; CREATE CUSTOM INDEX comment_language_lowercase_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
{"tokenizer" : {"name" : "standard"},
"filters" : [{"name" : "lowercase"}, {"name" : "czechstem"}]
}'}; CREATE CUSTOM INDEX comment_standard_lowercase_idx ON cycling.comments_vs (comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer':
'{
"tokenizer" : {
"name" : "standard",
"args" : {}
},
"filters" : [
{
"name" : "lowercase",
"args": {}
}
],
"charFilters" : []
}'
}; CREATE CUSTOM INDEX comment_standard_lowercase_idx ON cycling.comments_vs (comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer':
'{
"tokenizer" : {
"name" : "standard",
"args" : {}
},
"filters" : [
{
"name" : "lowercase",
"args": {}
}
],
"charFilters" : []
}'
}; CREATE CUSTOM INDEX comment_standard_lowercase_idx ON cycling.comments_vs (comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer':
'{
"tokenizer" : {
"name" : "standard",
"args" : {}
},
"filters" : [
{
"name" : "lowercase",
"args": {}
}
],
"charFilters" : []
}'
}; CREATE CUSTOM INDEX comment_mapping_lowercase_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '{"tokenizer" : {"name" : "mapping"},
"filters" : [{"name" : "lowercase"}],
"char_filter": {"my_mappings_char_filter": {
"type": "mapping",
"mappings": [
":) => _happy_",
":( => _sad_"
]
}
}'}; CREATE CUSTOM INDEX comment_mapping_lowercase_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '{"tokenizer" : {"name" : "mapping"},
"filters" : [{"name" : "lowercase"}],
"char_filter": {"my_mappings_char_filter": {
"type": "mapping",
"mappings": [
":) => _happy_",
":( => _sad_"
]
}
}'}; CREATE CUSTOM INDEX comment_mapping_lowercase_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '{"tokenizer" : {"name" : "mapping"},
"filters" : [{"name" : "lowercase"}],
"char_filter": {"my_mappings_char_filter": {
"type": "mapping",
"mappings": [
":) => _happy_",
":( => _sad_"
]
}
}'}; CREATE CUSTOM INDEX comment_ngram_lowercase_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
{"tokenizer" : {"name" : "ngram", "args" : {"minGramSize":"2", "maxGramSize":"3"}},
"filters" : [{"name" : "lowercase"}]
}'}; CREATE CUSTOM INDEX comment_ngram_lowercase_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
{"tokenizer" : {"name" : "ngram", "args" : {"minGramSize":"2", "maxGramSize":"3"}},
"filters" : [{"name" : "lowercase"}]
}'}; CREATE CUSTOM INDEX comment_ngram_lowercase_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
{"tokenizer" : {"name" : "ngram", "args" : {"minGramSize":"2", "maxGramSize":"3"}},
"filters" : [{"name" : "lowercase"}]
}'}; CREATE CUSTOM INDEX comment_standard_idx ON cycling.comments_vs (comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {'index_analyzer': 'STANDARD'}; CREATE CUSTOM INDEX comment_standard_idx ON cycling.comments_vs (comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {'index_analyzer': 'STANDARD'}; CREATE CUSTOM INDEX comment_standard_idx ON cycling.comments_vs (comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {'index_analyzer': 'STANDARD'}; CREATE CUSTOM INDEX comment_pattern_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
"tokenizer" : {"name" : "simplepattern", "args" : {"pattern":"[0123456789]{3}"}
}'}; CREATE CUSTOM INDEX comment_pattern_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
"tokenizer" : {"name" : "simplepattern", "args" : {"pattern":"[0123456789]{3}"}
}'}; CREATE CUSTOM INDEX comment_pattern_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
"tokenizer" : {"name" : "simplepattern", "args" : {"pattern":"[0123456789]{3}"}
}'}; CREATE CUSTOM INDEX comment_stemming_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '{
"tokenizer" : {"name" : "standard"},
"filters" : [{"name" : "porterstem"}]
}'}; CREATE CUSTOM INDEX comment_stemming_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '{
"tokenizer" : {"name" : "standard"},
"filters" : [{"name" : "porterstem"}]
}'}; CREATE CUSTOM INDEX comment_stemming_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '{
"tokenizer" : {"name" : "standard"},
"filters" : [{"name" : "porterstem"}]
}'}; CREATE CUSTOM INDEX comment_stemming_lowercase_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '{
"tokenizer" : {"name" : "standard"},
"filters" : [{"name" : "porterstem"}, {"name" : "lowercase"}]
}'}; CREATE CUSTOM INDEX comment_stemming_lowercase_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '{
"tokenizer" : {"name" : "standard"},
"filters" : [{"name" : "porterstem"}, {"name" : "lowercase"}]
}'}; CREATE CUSTOM INDEX comment_stemming_lowercase_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '{
"tokenizer" : {"name" : "standard"},
"filters" : [{"name" : "porterstem"}, {"name" : "lowercase"}]
}'}; CREATE CUSTOM INDEX comment_stop_lowercase_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
"tokenizer" : {"name" : "stop"},
"filters" : [{"name" : "lowercase"}]
}'}; CREATE CUSTOM INDEX comment_stop_lowercase_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
"tokenizer" : {"name" : "stop"},
"filters" : [{"name" : "lowercase"}]
}'}; CREATE CUSTOM INDEX comment_stop_lowercase_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
"tokenizer" : {"name" : "stop"},
"filters" : [{"name" : "lowercase"}]
}'}; CREATE CUSTOM INDEX commenter_synonym_keyword_idx ON cycling.comments_vs(commenter)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '{
"tokenizer": {"name" : "keyword"},
"filters" : [
{"name" : "synonym", "args" : {"synonyms" : "Alex, alex, Alexander, alexander => Alex"}}]
}'}; CREATE CUSTOM INDEX commenter_synonym_keyword_idx ON cycling.comments_vs(commenter)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '{
"tokenizer": {"name" : "keyword"},
"filters" : [
{"name" : "synonym", "args" : {"synonyms" : "Alex, alex, Alexander, alexander => Alex"}}]
}'}; CREATE CUSTOM INDEX commenter_synonym_keyword_idx ON cycling.comments_vs(commenter)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '{
"tokenizer": {"name" : "keyword"},
"filters" : [
{"name" : "synonym", "args" : {"synonyms" : "Alex, alex, Alexander, alexander => Alex"}}]
}'}; CREATE CUSTOM INDEX comment_synonym_lowercase_idx ON cycling.comments_vs (comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '{
"tokenizer": {"name" : "whitespace"},
"filters" : [ {"name" : "lowercase"},
{"name" : "synonym", "args" : {"synonyms" : "rain, drizzle => rain"}}]
}'}; CREATE CUSTOM INDEX comment_synonym_lowercase_idx ON cycling.comments_vs (comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '{
"tokenizer": {"name" : "whitespace"},
"filters" : [ {"name" : "lowercase"},
{"name" : "synonym", "args" : {"synonyms" : "rain, drizzle => rain"}}]
}'}; CREATE CUSTOM INDEX comment_synonym_lowercase_idx ON cycling.comments_vs (comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '{
"tokenizer": {"name" : "whitespace"},
"filters" : [ {"name" : "lowercase"},
{"name" : "synonym", "args" : {"synonyms" : "rain, drizzle => rain"}}]
}'}; CREATE CUSTOM INDEX comment_whitespace_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {'index_analyzer':'whitespace'}; CREATE CUSTOM INDEX comment_whitespace_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {'index_analyzer':'whitespace'}; CREATE CUSTOM INDEX comment_whitespace_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {'index_analyzer':'whitespace'}; CREATE CUSTOM INDEX comment_whitespace_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
{"tokenizer":{"name" : "whitespace"}}
}'}; CREATE CUSTOM INDEX comment_whitespace_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
{"tokenizer":{"name" : "whitespace"}}
}'}; CREATE CUSTOM INDEX comment_whitespace_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
{"tokenizer":{"name" : "whitespace"}}
}'}; CREATE CUSTOM INDEX comment_whitespace_lowercase_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
{"tokenizer":{"name" : "whitespace"},
"filters":[{"name" : "lowercase"}]
}'}; CREATE CUSTOM INDEX comment_whitespace_lowercase_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
{"tokenizer":{"name" : "whitespace"},
"filters":[{"name" : "lowercase"}]
}'}; CREATE CUSTOM INDEX comment_whitespace_lowercase_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
{"tokenizer":{"name" : "whitespace"},
"filters":[{"name" : "lowercase"}]
}'}; CREATE CUSTOM INDEX comment_whitespace_stemming_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
{"tokenizer":{"name" : "whitespace"},
"filters":[{"name" : "porterstem"}]
}'}; CREATE CUSTOM INDEX comment_whitespace_stemming_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
{"tokenizer":{"name" : "whitespace"},
"filters":[{"name" : "porterstem"}]
}'}; CREATE CUSTOM INDEX comment_whitespace_stemming_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
{"tokenizer":{"name" : "whitespace"},
"filters":[{"name" : "porterstem"}]
}'}; CREATE CUSTOM INDEX comment_case_insensitive_idx ON cycling.comments_vs (comment)
WITH OPTIONS = { 'case_sensitive': false}; CREATE CUSTOM INDEX comment_case_insensitive_idx ON cycling.comments_vs (comment)
USING 'sai'
WITH OPTIONS = { 'case_sensitive': false}; CREATE CUSTOM INDEX comment_case_insensitive_idx ON cycling.comments_vs (comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = { 'case_sensitive': false}; CREATE INDEX comment_ann_idx ON cycling.comments_vs(comment_vector); CREATE INDEX comment_ann_idx ON cycling.comments_vs(comment_vector) USING 'sai'; CREATE CUSTOM INDEX comment_ann_idx ON cycling.comments_vs(comment_vector)
USING 'StorageAttachedIndex'; CREATE INDEX commenter_idx ON cycling.comments_vs (commenter)
WITH OPTIONS = {'case_sensitive': 'true', 'normalize': 'true', 'ascii': 'true'}; CREATE INDEX commenter_idx ON cycling.comments_vs (commenter) USING 'sai'
WITH OPTIONS = {'case_sensitive': 'true', 'normalize': 'true', 'ascii': 'true'}; CREATE CUSTOM INDEX commenter_idx ON cycling.comments_vs (commenter)
USING 'StorageAttachedIndex'
WITH OPTIONS = {'case_sensitive': 'true', 'normalize': 'true', 'ascii': 'true'}; CREATE INDEX commenter_idx ON cycling.comments_vs (commenter); CREATE INDEX commenter_idx ON cycling.comments_vs (commenter)
USING 'sai'; CREATE CUSTOM INDEX commenter_idx ON cycling.comments_vs (commenter)
USING 'StorageAttachedIndex'; CREATE INDEX created_at_idx ON cycling.comments_vs (created_at); CREATE INDEX created_at_idx ON cycling.comments_vs (created_at)
USING 'sai'; CREATE CUSTOM INDEX created_at_idx ON cycling.comments_vs (created_at)
USING 'StorageAttachedIndex'; CREATE CUSTOM INDEX comment_sim_function_idx
ON cycling.comments_vs (comment_vector)
WITH OPTIONS = { 'similarity_function': 'DOT_PRODUCT'}; CREATE CUSTOM INDEX comment_sim_function_idx
ON cycling.comments_vs (comment_vector) USING 'sai'
WITH OPTIONS = { 'similarity_function': 'DOT_PRODUCT'}; CREATE CUSTOM INDEX comment_sim_function_idx
ON cycling.comments_vs (comment_vector) USING 'StorageAttachedIndex'
WITH OPTIONS = { 'similarity_function': 'DOT_PRODUCT'}; CREATE CUSTOM INDEX comment_source_model_idx
ON cycling.comments_vs (comment_vector)
WITH OPTIONS = { 'source_model': 'bert'}; CREATE CUSTOM INDEX comment_source_model_idx
ON cycling.comments_vs (comment_vector) USING 'sai'
WITH OPTIONS = { 'source_model': 'bert'}; CREATE CUSTOM INDEX comment_source_model_idx
ON cycling.comments_vs (comment_vector) USING 'StorageAttachedIndex'
WITH OPTIONS = { 'source_model': 'bert'}; DESCRIBE INDEX cycling.comment_all_ann_options_idx; DESCRIBE INDEX cycling.comment_all_ann_options_idx; DESCRIBE INDEX cycling.comment_all_ann_options_idx; DESCRIBE INDEX cycling.comment_keyword_htmlstrip_idx; DESCRIBE INDEX cycling.comment_keyword_htmlstrip_idx; DESCRIBE INDEX cycling.comment_keyword_htmlstrip_idx; DESCRIBE INDEX cycling.comment_language_lowercase_idx; DESCRIBE INDEX cycling.comment_language_lowercase_idx; DESCRIBE INDEX cycling.comment_language_lowercase_idx; DESCRIBE INDEX cycling.comment_standard_lowercase_idx; DESCRIBE INDEX cycling.comment_standard_lowercase_idx; DESCRIBE INDEX cycling.comment_standard_lowercase_idx; DESCRIBE INDEX cycling.comment_mapping_lowercase_idx; DESCRIBE INDEX cycling.comment_mapping_lowercase_idx; DESCRIBE INDEX cycling.comment_mapping_lowercase_idx; DESCRIBE INDEX cycling.comment_ngram_lowercase_idx; DESCRIBE INDEX cycling.comment_ngram_lowercase_idx; DESCRIBE INDEX cycling.comment_ngram_lowercase_idx; DESCRIBE INDEX cycling.comment_pattern_idx; DESCRIBE INDEX cycling.comment_pattern_idx; DESCRIBE INDEX cycling.comment_pattern_idx; DESCRIBE INDEX cycling.comment_stemming_idx; DESCRIBE INDEX cycling.comment_stemming_idx; DESCRIBE INDEX cycling.comment_stemming_idx; DESCRIBE INDEX cycling.comment_stemming_lowercase_idx; DESCRIBE INDEX cycling.comment_stemming_lowercase_idx; DESCRIBE INDEX cycling.comment_stemming_lowercase_idx; DESCRIBE INDEX cycling.comment_stop_lowercase_idx; DESCRIBE INDEX cycling.comment_stop_lowercase_idx; DESCRIBE INDEX cycling.comment_stop_lowercase_idx; DESCRIBE INDEX cycling.commenter_synonym_keyword_idx; DESCRIBE INDEX cycling.commenter_synonym_keyword_idx; DESCRIBE INDEX cycling.commenter_synonym_keyword_idx; DESCRIBE INDEX cycling.comment_synonym_lowercase_idx; DESCRIBE INDEX cycling.comment_synonym_lowercase_idx; DESCRIBE INDEX cycling.comment_synonym_lowercase_idx; DESCRIBE INDEX cycling.comment_whitespace_idx; DESCRIBE INDEX cycling.comment_whitespace_idx; DESCRIBE INDEX cycling.comment_whitespace_idx; DESCRIBE INDEX cycling.comment_whitespace_idx; DESCRIBE INDEX cycling.comment_whitespace_idx; DESCRIBE INDEX cycling.comment_whitespace_idx;
// end::index-describe-analyzer-whitespace-idx
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Describe index comment_whitespace_idx v3"
fi
# Query vector search analyzer whitespace
# LLP: Do i have an example?
# DROP INDEX TO RECREATE
$cqlsh -e "DROP INDEX cycling.comment_whitespace_idx;"
# tokenizing filter with whitecase alternate
if [ $index_version = "v1"]; then
tag="index-create-analyzer-whitespace-alternate-idx-v1[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-create-analyzer-whitespace-alternate-idx-v1[]
CREATE CUSTOM INDEX comment_whitespace_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {'index_analyzer':'whitespace'};
// end::index-create-analyzer-whitespace-alternate-idx-v1[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Create index comment_whitespace_idx v1"
tag="index-describe-analyzer-whitespace-alternate-idx-v1[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-describe-analyzer-whitespace-alternate-idx-v1[]
DESCRIBE INDEX cycling.comment_whitespace_idx;
// end::index-describe-analyzer-whitespace-alternate-idx-v1[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Describe index comment_whitespace_idx v1"
elif [ $index_version = "v2" ]; then
tag="index-create-analyzer-whitespace-alternate-idx-v2[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-create-analyzer-whitespace-alternate-idx-v2[]
CREATE CUSTOM INDEX comment_whitespace_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {'index_analyzer':'whitespace'};
// end::index-create-analyzer-whitespace-alternate-idx-v2[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Create index comment_whitespace_idx v2"
tag="index-describe-analyzer-whitespace-alternate-idx-v2[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-describe-analyzer-whitespace-alternate-idx-v2[]
DESCRIBE INDEX cycling.comment_whitespace_idx;
// end::index-describe-analyzer-whitespace-alternate-idx-v2[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Describe index comment_whitespace_idx v2"
elif [ $index_version = "v3" ]; then
tag="index-create-analyzer-whitespace-alternate-idx-v3[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-create-analyzer-whitespace-alternate-idx-v3[]
CREATE CUSTOM INDEX comment_whitespace_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {'index_analyzer':'whitespace'};
// end::index-create-analyzer-whitespace-alternate-idx-v3[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Create index comment_whitespace_idx v3"
tag="index-describe-analyzer-whitespace-alternate-idx-v3[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-describe-analyzer-whitespace-alternate-idx-v3[]
DESCRIBE INDEX cycling.comment_whitespace_idx;
// end::index-describe-analyzer-whitespace-alternate-idx-v3[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Describe index comment_whitespace_idx v3"
fi
# Query vector search analyzer whitespace alternate
# LLP: Do i have an example? Probably same as last one
# DROP INDEX TO RECREATE
$cqlsh -e "DROP INDEX cycling.comment_whitespace_idx;"
# tokenizing filter with whitespace and lowercase filter
# Text: The Dog Tokens: the, dog
if [ $index_version = "v1"]; then
tag="index-create-analyzer-whitespace-lowercase-idx-v1[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-create-analyzer-whitespace-lowercase-idx-v1[]
CREATE CUSTOM INDEX comment_whitespace_lowercase_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
{"tokenizer":{"name" : "whitespace"},
"filters":[{"name" : "lowercase"}]
}'};
// end::index-create-analyzer-whitespace-lowercase-idx-v1[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Create index comment_whitespace_lowercase_idx v1"
tag="index-describe-analyzer-whitespace-lowercase-idx-v1[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-describe-analyzer-whitespace-lowercase-idx-v1[]
DESCRIBE INDEX cycling.comment_whitespace_lowercase_idx;
// end::index-describe-analyzer-whitespace-lowercase-idx-v1[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Describe index comment_whitespace_lowercase_idx v1"
elif [ $index_version = "v2" ]; then
tag="index-create-analyzer-whitespace-lowercase-idx-v2[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-create-analyzer-whitespace-lowercase-idx-v2[]
CREATE CUSTOM INDEX comment_whitespace_lowercase_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
{"tokenizer":{"name" : "whitespace"},
"filters":[{"name" : "lowercase"}]
}'};
// end::index-create-analyzer-whitespace-lowercase-idx-v2[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Create index comment_whitespace_lowercase_idx v2"
tag="index-describe-analyzer-whitespace-lowercase-idx-v2[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-describe-analyzer-whitespace-lowercase-idx-v2[]
DESCRIBE INDEX cycling.comment_whitespace_lowercase_idx;
// end::index-describe-analyzer-whitespace-lowercase-idx-v2[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Describe index comment_whitespace_lowercase_idx v2"
elif [ $index_version = "v3" ]; then
tag="index-create-analyzer-whitespace-lowercase-idx-v3[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-create-analyzer-whitespace-lowercase-idx-v3[]
CREATE CUSTOM INDEX comment_whitespace_lowercase_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
{"tokenizer":{"name" : "whitespace"},
"filters":[{"name" : "lowercase"}]
}'};
// end::index-create-analyzer-whitespace-lowercase-idx-v3[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Create index comment_whitespace_lowercase_idx v3"
tag="index-describe-analyzer-whitespace-lowercase-idx-v3[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-describe-analyzer-whitespace-lowercase-idx-v3[]
DESCRIBE INDEX cycling.comment_whitespace_lowercase_idx;
// end::index-describe-analyzer-whitespace-lowercase-idx-v3[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Describe index comment_whitespace_lowercase_idx v3"
fi
# Query vector search analyzer whitespace lowercase
# Text: The dogs Tokens: the, dog, dogs
# Hmm - no lowercasing, so ^^ may not be correct?
if [ $index_version = "v1"]; then
tag="index-create-analyzer-whitespace-stemming-idx-v1[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-create-analyzer-whitespace-stemming-idx-v1[]
CREATE CUSTOM INDEX comment_whitespace_stemming_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
{"tokenizer":{"name" : "whitespace"},
"filters":[{"name" : "porterstem"}]
}'};
// end::index-create-analyzer-whitespace-stemming-idx-v1[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Create index comment_whitespace_stemming_idx v1"
tag="index-describe-analyzer-whitespace-stemming-idx-v1[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-describe-analyzer-whitespace-stemming-idx-v1[]
DESCRIBE INDEX cycling.comment_whitespace_stemming_idx;
// end::index-describe-analyzer-whitespace-stemming-idx-v1[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Describe index comment_whitespace_stemming_idx v1"
elif [ $index_version = "v2" ]; then
tag="index-create-analyzer-whitespace-stemming-idx-v2[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-create-analyzer-whitespace-stemming-idx-v2[]
CREATE CUSTOM INDEX comment_whitespace_stemming_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
{"tokenizer":{"name" : "whitespace"},
"filters":[{"name" : "porterstem"}]
}'};
// end::index-create-analyzer-whitespace-stemming-idx-v2[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Create index comment_whitespace_stemming_idx v2"
tag="index-describe-analyzer-whitespace-stemming-idx-v2[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-describe-analyzer-whitespace-stemming-idx-v2[]
DESCRIBE INDEX cycling.comment_whitespace_stemming_idx;
// end::index-describe-analyzer-whitespace-stemming-idx-v2[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Describe index comment_whitespace_stemming_idx v2"
elif [ $index_version = "v3" ]; then
tag="index-create-analyzer-whitespace-stemming-idx-v3[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-create-analyzer-whitespace-stemming-idx-v3[]
CREATE CUSTOM INDEX comment_whitespace_stemming_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
{"tokenizer":{"name" : "whitespace"},
"filters":[{"name" : "porterstem"}]
}'};
// end::index-create-analyzer-whitespace-stemming-idx-v3[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Create index comment_whitespace_stemming_idx v3"
tag="index-describe-analyzer-whitespace-stemming-idx-v3[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-describe-analyzer-whitespace-stemming-idx-v3[]
DESCRIBE INDEX cycling.comment_whitespace_stemming_idx;
// end::index-describe-analyzer-whitespace-stemming-idx-v3[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Describe index comment_whitespace_stemming_idx v3"
fi
# Query vector search analyzer whitespace stemming
# DROP INDEX TO RECREATE
$cqlsh -e "DROP INDEX cycling.comment_whitespace_stemming_idx;"
# Text: DoG Tokens: do, dog, og
# Text: RACE, race, RAIN, rain Tokens: ??
if [ $index_version = "v1"]; then
tag="index-create-analyzer-ngram-lowercase-idx-v1[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-create-analyzer-ngram-lowercase-idx-v1[]
CREATE CUSTOM INDEX comment_ngram_lowercase_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
{"tokenizer" : {"name" : "ngram", "args" : {"minGramSize":"2", "maxGramSize":"3"}},
"filters" : [{"name" : "lowercase"}]
}'};
// end::index-create-analyzer-ngram-lowercase-idx-v1[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Create index comment_ngram_lowercase_idx v1"
tag="index-describe-analyzer-ngram-lowercase-idx-v1[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-describe-analyzer-ngram-lowercase-idx-v1[]
DESCRIBE INDEX cycling.comment_ngram_lowercase_idx;
// end::index-describe-analyzer-ngram-lowercase-idx-v1[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Describe index comment_ngram_lowercase_idx v1"
elif [ $index_version = "v2"]; then
tag="index-create-analyzer-ngram-lowercase-idx-v2[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-create-analyzer-ngram-lowercase-idx-v2[]
CREATE CUSTOM INDEX comment_ngram_lowercase_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
{"tokenizer" : {"name" : "ngram", "args" : {"minGramSize":"2", "maxGramSize":"3"}},
"filters" : [{"name" : "lowercase"}]
}'};
// end::index-create-analyzer-ngram-lowercase-idx-v2[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Create index comment_ngram_lowercase_idx v2"
tag="index-describe-analyzer-ngram-lowercase-idx-v2[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-describe-analyzer-ngram-lowercase-idx-v2[]
DESCRIBE INDEX cycling.comment_ngram_lowercase_idx;
// end::index-describe-analyzer-ngram-lowercase-idx-v2[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Describe index comment_ngram_lowercase_idx v2"
elif [ $index_version = "v3"]; then
tag="index-create-analyzer-ngram-lowercase-idx-v3[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-create-analyzer-ngram-lowercase-idx-v3[]
CREATE CUSTOM INDEX comment_ngram_lowercase_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
{"tokenizer" : {"name" : "ngram", "args" : {"minGramSize":"2", "maxGramSize":"3"}},
"filters" : [{"name" : "lowercase"}]
}'};
// end::index-create-analyzer-ngram-lowercase-idx-v3[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Create index comment_ngram_lowercase_idx v3"
tag="index-describe-analyzer-ngram-lowercase-idx-v3[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-describe-analyzer-ngram-lowercase-idx-v3[]
DESCRIBE INDEX cycling.comment_ngram_lowercase_idx;
// end::index-describe-analyzer-ngram-lowercase-idx-v3[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Describe index comment_ngram_lowercase_idx v3"
fi
# Query vector search analyzer ngram lowercase
tag="select-from-comments-vs-analyzer-ngram-lowercase[]"
echo "// tag::$tag" >> $results_table
$cqlsh -e "
// tag::select-from-comments-vs-analyzer-ngram-lowercase[]
SELECT comment,comment_vector,commenter FROM cycling.comments_vs
WHERE comment : 'ra';
// end::select-from-comments-vs-analyzer-ngram-lowercase[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Query vector search analyzer ngram lowercase"
# DROP INDEX TO RECREATE
$cqlsh -e "DROP INDEX cycling.comment_ngram_lowercase_idx;"
# Standard analyzer with pattern filter
# Text: fd-786-335-514-x Tokens: 786, 335, 514
if [ $index_version = "v1"]; then
tag="index-create-analyzer-standard-pattern-idx-v1[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-create-analyzer-standard-pattern-idx-v1[]
CREATE CUSTOM INDEX comment_pattern_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
"tokenizer" : {"name" : "simplepattern", "args" : {"pattern":"[0123456789]{3}"}
}'};
// end::index-create-analyzer-standard-pattern-idx-v1[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Create index comment_pattern_idx v1"
tag="index-describe-analyzer-standard-pattern-idx-v1[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-describe-analyzer-standard-pattern-idx-v1[]
DESCRIBE INDEX cycling.comment_pattern_idx;
// end::index-describe-analyzer-standard-pattern-idx-v1[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Describe index comment_pattern_idx v1"
elif [ $index_version = "v2"]; then
tag="index-create-analyzer-standard-pattern-idx-v2[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-create-analyzer-standard-pattern-idx-v2[]
CREATE CUSTOM INDEX comment_pattern_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
"tokenizer" : {"name" : "simplepattern", "args" : {"pattern":"[0123456789]{3}"}
}'};
// end::index-create-analyzer-standard-pattern-idx-v2[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Create index comment_pattern_idx v2"
tag="index-describe-analyzer-standard-pattern-idx-v2[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-describe-analyzer-standard-pattern-idx-v2[]
DESCRIBE INDEX cycling.comment_pattern_idx;
// end::index-describe-analyzer-standard-pattern-idx-v2[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Describe index comment_pattern_idx v2"
elif [ $index_version = "v3"]; then
tag="index-create-analyzer-standard-pattern-idx-v3[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-create-analyzer-standard-pattern-idx-v3[]
CREATE CUSTOM INDEX comment_pattern_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
"tokenizer" : {"name" : "simplepattern", "args" : {"pattern":"[0123456789]{3}"}
}'};
// end::index-create-analyzer-standard-pattern-idx-v3[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Create index comment_pattern_idx v3"
tag="index-describe-analyzer-standard-pattern-idx-v3[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-describe-analyzer-standard-pattern-idx-v3[]
DESCRIBE INDEX cycling.comment_pattern_idx;
// end::index-describe-analyzer-standard-pattern-idx-v3[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Describe index comment_pattern_idx v3"
fi
# Query vector search analyzer standard pattern
# DROP INDEX TO RECREATE
$cqlsh -e "DROP INDEX cycling.comment_pattern_idx;"
# Standard analyzer with keyword tokenizer and htmlstrip charFilter
# Text: Tokens:
if [ $index_version = "v1"]; then
tag ="index-create-analyzer-keyword-htmlstrip-idx-v1[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-create-analyzer-keyword-htmlstrip-idx-v1[]
CREATE CUSTOM INDEX comment_keyword_htmlstrip_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
{
"tokenizer" : {"name" : "keyword"},
"charFilters" : [{"name" : "htmlstrip"}]
}'};
// end::index-create-analyzer-keyword-htmlstrip-idx-v1[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Create index comment_keyword_htmlstrip_idx v1"
tag="index-describe-analyzer-keyword-htmlstrip-idx-v1[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-describe-analyzer-keyword-htmlstrip-idx-v1[]
DESCRIBE INDEX cycling.comment_keyword_htmlstrip_idx;
// end::index-describe-analyzer-keyword-htmlstrip-idx-v1[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Describe index comment_keyword_htmlstrip_idx v1"
elif [ $index_version = "v2"]; then
tag ="index-create-analyzer-keyword-htmlstrip-idx-v2[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-create-analyzer-keyword-htmlstrip-idx-v2[]
CREATE CUSTOM INDEX comment_keyword_htmlstrip_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
{
"tokenizer" : {"name" : "keyword"},
"charFilters" : [{"name" : "htmlstrip"}]
}'};
// end::index-create-analyzer-keyword-htmlstrip-idx-v2[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Create index comment_keyword_htmlstrip_idx v2"
tag="index-describe-analyzer-keyword-htmlstrip-idx-v2[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-describe-analyzer-keyword-htmlstrip-idx-v2[]
DESCRIBE INDEX cycling.comment_keyword_htmlstrip_idx;
// end::index-describe-analyzer-keyword-htmlstrip-idx-v2[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Describe index comment_keyword_htmlstrip_idx v2"
elif [ $index_version = "v3"]; then
tag ="index-create-analyzer-keyword-htmlstrip-idx-v3[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-create-analyzer-keyword-htmlstrip-idx-v3[]
CREATE CUSTOM INDEX comment_keyword_htmlstrip_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
{
"tokenizer" : {"name" : "keyword"},
"charFilters" : [{"name" : "htmlstrip"}]
}'};
// end::index-create-analyzer-keyword-htmlstrip-idx-v3[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Create index comment_keyword_htmlstrip_idx v3"
tag="index-describe-analyzer-keyword-htmlstrip-idx-v3[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-describe-analyzer-keyword-htmlstrip-idx-v3[]
DESCRIBE INDEX cycling.comment_keyword_htmlstrip_idx;
// end::index-describe-analyzer-keyword-htmlstrip-idx-v3[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Describe index comment_keyword_htmlstrip_idx v3"
fi
# Query vector search analyzer keyword htmlstrip
# Query vector search analyzer htmlstrip
tag="select-from-comments-vs-analyzer-htmlstrip[]"
echo "// tag::$tag" >> $results_table
$cqlsh -e "
// tag::select-from-comments-vs-analyzer-htmlstrip[]
SELECT comment,comment_vector,commenter FROM cycling.comments_vs
WHERE comment : 'The gift certificate for winning was the best';
// end::select-from-comments-vs-analyzer-htmlstrip[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Query vector search analyzer htmlstrip"
# LLP: htmlstrip
# cqlsh:cycling> select comment,commenter from comments_vs where comment : 'The gift certificate for winning was the best';
# comment | commenter
#------------------------------------------------------+-----------
# The gift certificate for winning was the best | Amy
# The <B>gift certificate</B> for winning was the best | Amy
#
#(2 rows)
# DROP INDEX TO RECREATE
$cqlsh -e "DROP INDEX cycling.comment_keyword_htmlstrip_idx;"
# Standard analyzer with language and lowercase filters
# Text: panove Tokens: pan (with accents)
if [ $index_version = "v1"]; then
tag="index-create-analyzer-language-lowercase-idx-v1[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-create-analyzer-language-lowercase-idx-v1[]
CREATE CUSTOM INDEX comment_language_lowercase_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
{"tokenizer" : {"name" : "standard"},
"filters" : [{"name" : "lowercase"}, {"name" : "czechstem"}]
}'};
// end::index-create-analyzer-language-lowercase-idx-v1[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Create index comment_language_lowercase_idx v1"
tag="index-describe-analyzer-language-lowercase-idx-v1[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-describe-analyzer-language-lowercase-idx-v1[]
DESCRIBE INDEX cycling.comment_language_lowercase_idx;
// end::index-describe-analyzer-language-lowercase-idx-v1[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Describe index comment_language_lowercase_idx v1"
elif [ $index_version = "v2"]; then
tag="index-create-analyzer-language-lowercase-idx-v2[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-create-analyzer-language-lowercase-idx-v2[]
CREATE CUSTOM INDEX comment_language_lowercase_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
{"tokenizer" : {"name" : "standard"},
"filters" : [{"name" : "lowercase"}, {"name" : "czechstem"}]
}'};
// end::index-create-analyzer-language-lowercase-idx-v2[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Create index comment_language_lowercase_idx v2"
tag="index-describe-analyzer-language-lowercase-idx-v2[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-describe-analyzer-language-lowercase-idx-v2[]
DESCRIBE INDEX cycling.comment_language_lowercase_idx;
// end::index-describe-analyzer-language-lowercase-idx-v2[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Describe index comment_language_lowercase_idx v2"
elif [ $index_version = "v3"]; then
tag="index-create-analyzer-language-lowercase-idx-v3[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-create-analyzer-language-lowercase-idx-v3[]
CREATE CUSTOM INDEX comment_language_lowercase_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
{"tokenizer" : {"name" : "standard"},
"filters" : [{"name" : "lowercase"}, {"name" : "czechstem"}]
}'};
// end::index-create-analyzer-language-lowercase-idx-v3[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Create index comment_language_lowercase_idx v3"
tag="index-describe-analyzer-language-lowercase-idx-v3[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-describe-analyzer-language-lowercase-idx-v3[]
DESCRIBE INDEX cycling.comment_language_lowercase_idx;
// end::index-describe-analyzer-language-lowercase-idx-v3[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Describe index comment_language_lowercase_idx v3"
fi
# Query vector search analyzer language lowercase
# DROP INDEX TO RECREATE
$cqlsh -e "DROP INDEX cycling.comment_language_lowercase_idx;"
# Standard analyzer with stop and lowercase filters
# Text: The Dog And the cow Tokens: dog, cow
if [ $index_version = "v1"]; then
tag="index-create-analyzer-stop-lowercase-idx-v1[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-create-analyzer-stop-lowercase-idx-v1[]
CREATE CUSTOM INDEX comment_stop_lowercase_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
"tokenizer" : {"name" : "stop"},
"filters" : [{"name" : "lowercase"}]
}'};
// end::index-create-analyzer-stop-lowercase-idx-v1[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Create index comment_stop_lowercase_idx v1"
tag="index-describe-analyzer-stop-lowercase-idx-v1[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-describe-analyzer-stop-lowercase-idx-v1[]
DESCRIBE INDEX cycling.comment_stop_lowercase_idx;
// end::index-describe-analyzer-stop-lowercase-idx-v1[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Describe index comment_stop_lowercase_idx v1"
elif [ $index_version = "v2"]; then
tag="index-create-analyzer-stop-lowercase-idx-v2[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-create-analyzer-stop-lowercase-idx-v2[]
CREATE CUSTOM INDEX comment_stop_lowercase_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
"tokenizer" : {"name" : "stop"},
"filters" : [{"name" : "lowercase"}]
}'};
// end::index-create-analyzer-stop-lowercase-idx-v2[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Create index comment_stop_lowercase_idx v2"
tag="index-describe-analyzer-stop-lowercase-idx-v2[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-describe-analyzer-stop-lowercase-idx-v2[]
DESCRIBE INDEX cycling.comment_stop_lowercase_idx;
// end::index-describe-analyzer-stop-lowercase-idx-v2[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Describe index comment_stop_lowercase_idx v2"
elif [ $index_version = "v3"]; then
tag="index-create-analyzer-stop-lowercase-idx-v3[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-create-analyzer-stop-lowercase-idx-v3[]
CREATE CUSTOM INDEX comment_stop_lowercase_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '
"tokenizer" : {"name" : "stop"},
"filters" : [{"name" : "lowercase"}]
}'};
// end::index-create-analyzer-stop-lowercase-idx-v3[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Create index comment_stop_lowercase_idx v3"
tag="index-describe-analyzer-stop-lowercase-idx-v3[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-describe-analyzer-stop-lowercase-idx-v3[]
DESCRIBE INDEX cycling.comment_stop_lowercase_idx;
// end::index-describe-analyzer-stop-lowercase-idx-v3[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Describe index comment_stop_lowercase_idx v3"
fi
# Query vector search analyzer stop lowercase
# DROP INDEX TO RECREATE
$cqlsh -e "DROP INDEX cycling.comment_stop_lowercase_idx;"
# Standard analyzer with synonym and lowercase filters
# Text: rain, drizzle, Rain Tokens: rain, drizzle
if [ $index_version = "v1"]; then
tag="index-create-analyzer-synonym-lowercase-idx-v1[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-create-analyzer-synonym-lowercase-idx-v1[]
CREATE CUSTOM INDEX comment_synonym_lowercase_idx ON cycling.comments_vs (comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '{
"tokenizer": {"name" : "whitespace"},
"filters" : [ {"name" : "lowercase"},
{"name" : "synonym", "args" : {"synonyms" : "rain, drizzle => rain"}}]
}'};
// end::index-create-analyzer-synonym-lowercase-idx-v1[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Create index comment_synonym_lowercase_idx v1"
tag="index-describe-analyzer-synonym-lowercase-idx-v1[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-describe-analyzer-synonym-lowercase-idx-v1[]
DESCRIBE INDEX cycling.comment_synonym_lowercase_idx;
// end::index-describe-analyzer-synonym-lowercase-idx-v1[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Describe index comment_synonym_lowercase_idx v1"
elif [ $index_version = "v2"]; then
tag="index-create-analyzer-synonym-lowercase-idx-v2[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-create-analyzer-synonym-lowercase-idx-v2[]
CREATE CUSTOM INDEX comment_synonym_lowercase_idx ON cycling.comments_vs (comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '{
"tokenizer": {"name" : "whitespace"},
"filters" : [ {"name" : "lowercase"},
{"name" : "synonym", "args" : {"synonyms" : "rain, drizzle => rain"}}]
}'};
// end::index-create-analyzer-synonym-lowercase-idx-v2[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Create index comment_synonym_lowercase_idx v2"
tag="index-describe-analyzer-synonym-lowercase-idx-v2[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-describe-analyzer-synonym-lowercase-idx-v2[]
DESCRIBE INDEX cycling.comment_synonym_lowercase_idx;
// end::index-describe-analyzer-synonym-lowercase-idx-v2[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Describe index comment_synonym_lowercase_idx v2"
elif [ $index_version = "v3"]; then
tag="index-create-analyzer-synonym-lowercase-idx-v3[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-create-analyzer-synonym-lowercase-idx-v3[]
CREATE CUSTOM INDEX comment_synonym_lowercase_idx ON cycling.comments_vs (comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '{
"tokenizer": {"name" : "whitespace"},
"filters" : [ {"name" : "lowercase"},
{"name" : "synonym", "args" : {"synonyms" : "rain, drizzle => rain"}}]
}'};
// end::index-create-analyzer-synonym-lowercase-idx-v3[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Create index comment_synonym_lowercase_idx v3"
tag="index-describe-analyzer-synonym-lowercase-idx-v3[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-describe-analyzer-synonym-lowercase-idx-v3[]
DESCRIBE INDEX cycling.comment_synonym_lowercase_idx;
// end::index-describe-analyzer-synonym-lowercase-idx-v3[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Describe index comment_synonym_lowercase_idx v3"
fi
# Query vector search analyzer synonym lowercase
# Query vector search analyzer synonym lowercase
tag="select-from-comments-vs-analyzer-synonym-lowercase[]"
echo "// tag::$tag" >> $results_table
$cqlsh -e "
// tag:select-from-comments-vs-analyzer-synonym-lowercase[]
SELECT comment, comment_vector, commenter FROM comments_vs WHERE comment : 'drizzle';
SELECT comment, comment_vector, commenter FROM comments_vs WHERE comment : 'rain';
// end::select-from-comments-vs-analyzer-synonym-lowercase[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Query vector search analyzer synonym lowercase"
# DROP INDEX TO RECREATE
$cqlsh -e "DROP INDEX cycling.comment_synonym_lowercase_idx;"
# Standard analyzer with keyword tokenizer and synonym filter
# Text: Tokens:
if [ $index_version = "v1"]; then
tag="index-create-analyzer-synonym-keyword-idx-v1[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-create-analyzer-synonym-keyword-idx-v1[]
CREATE CUSTOM INDEX commenter_synonym_keyword_idx ON cycling.comments_vs(commenter)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '{
"tokenizer": {"name" : "keyword"},
"filters" : [
{"name" : "synonym", "args" : {"synonyms" : "Alex, alex, Alexander, alexander => Alex"}}]
}'};
// end::index-create-analyzer-synonym-keyword-idx-v1[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Create index commenter_synonym_keyword_idx v1"
tag="index-describe-analyzer-synonym-keyword-idx-v1[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-describe-analyzer-synonym-keyword-idx-v1[]
DESCRIBE INDEX cycling.commenter_synonym_keyword_idx;
// end::index-describe-analyzer-synonym-keyword-idx-v1[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Describe index commenter_synonym_keyword_idx v1"
elif [ $index_version = "v2"]; then
tag="index-create-analyzer-synonym-keyword-idx-v2[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-create-analyzer-synonym-keyword-idx-v2[]
CREATE CUSTOM INDEX commenter_synonym_keyword_idx ON cycling.comments_vs(commenter)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '{
"tokenizer": {"name" : "keyword"},
"filters" : [
{"name" : "synonym", "args" : {"synonyms" : "Alex, alex, Alexander, alexander => Alex"}}]
}'};
// end::index-create-analyzer-synonym-keyword-idx-v2[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Create index commenter_synonym_keyword_idx v2"
tag="index-describe-analyzer-synonym-keyword-idx-v2[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-describe-analyzer-synonym-keyword-idx-v2[]
DESCRIBE INDEX cycling.commenter_synonym_keyword_idx;
// end::index-describe-analyzer-synonym-keyword-idx-v2[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Describe index commenter_synonym_keyword_idx v2"
elif [ $index_version = "v3"]; then
tag="index-create-analyzer-synonym-keyword-idx-v3[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-create-analyzer-synonym-keyword-idx-v3[]
CREATE CUSTOM INDEX commenter_synonym_keyword_idx ON cycling.comments_vs(commenter)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '{
"tokenizer": {"name" : "keyword"},
"filters" : [
{"name" : "synonym", "args" : {"synonyms" : "Alex, alex, Alexander, alexander => Alex"}}]
}'};
// end::index-create-analyzer-synonym-keyword-idx-v3[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Create index commenter_synonym_keyword_idx v3"
tag="index-describe-analyzer-synonym-keyword-idx-v3[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-describe-analyzer-synonym-keyword-idx-v3[]
DESCRIBE INDEX cycling.commenter_synonym_keyword_idx;
// end::index-describe-analyzer-synonym-keyword-idx-v3[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Describe index commenter_synonym_keyword_idx v3"
fi
# Query vector search analyzer synonym keyword
tag="select-from-comments-vs-analyzer-synonym-keyword[]"
echo "// tag::$tag" >> $results_table
$cqlsh -e "
// tag:select-from-comments-vs-analyzer-synonym-keyword[]
SELECT * FROM comments_vs WHERE comment : 'Alex';
SELECT * FROM comments_vs WHERE comment : 'alex';
SELECT * FROM comments_vs WHERE commenter : 'Alexander';
// end::select-from-comments-vs-analyzer-synonym-keyword[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Query vector search analyzer synonym keyword"
# DROP INDEX TO RECREATE
$cqlsh -e "DROP INDEX cycling.commenter_synonym_keyword_idx;"
# Standard analyzer with mapping and lowercase filters
# Text: Tokens:
if [ $index_version = "v1"]; then
tag="index-create-analyzer-mapping-lowercase-idx-v1[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-create-analyzer-mapping-lowercase-idx-v1[]
CREATE CUSTOM INDEX comment_mapping_lowercase_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '{"tokenizer" : {"name" : "mapping"},
"filters" : [{"name" : "lowercase"}],
"char_filter": {"my_mappings_char_filter": {
"type": "mapping",
"mappings": [
":) => _happy_",
":( => _sad_"
]
}
}'};
// end::index-create-analyzer-mapping-lowercase-idx-v1[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Create index comment_mapping_lowercase_idx v1"
tag="index-describe-analyzer-mapping-lowercase-idx-v1[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-describe-analyzer-mapping-lowercase-idx-v1[]
DESCRIBE INDEX cycling.comment_mapping_lowercase_idx;
// end::index-describe-analyzer-mapping-lowercase-idx-v1[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Describe index comment_mapping_lowercase_idx v1"
elif [ $index_version = "v2"]; then
tag="index-create-analyzer-mapping-lowercase-idx-v2[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-create-analyzer-mapping-lowercase-idx-v2[]
CREATE CUSTOM INDEX comment_mapping_lowercase_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '{"tokenizer" : {"name" : "mapping"},
"filters" : [{"name" : "lowercase"}],
"char_filter": {"my_mappings_char_filter": {
"type": "mapping",
"mappings": [
":) => _happy_",
":( => _sad_"
]
}
}'};
// end::index-create-analyzer-mapping-lowercase-idx-v2[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Create index comment_mapping_lowercase_idx v2"
tag="index-describe-analyzer-mapping-lowercase-idx-v2[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-describe-analyzer-mapping-lowercase-idx-v2[]
DESCRIBE INDEX cycling.comment_mapping_lowercase_idx;
// end::index-describe-analyzer-mapping-lowercase-idx-v2[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Describe index comment_mapping_lowercase_idx v2"
elif [ $index_version = "v3"]; then
tag="index-create-analyzer-mapping-lowercase-idx-v3[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-create-analyzer-mapping-lowercase-idx-v3[]
CREATE CUSTOM INDEX comment_mapping_lowercase_idx ON cycling.comments_vs(comment)
USING 'StorageAttachedIndex'
WITH OPTIONS = {
'index_analyzer': '{"tokenizer" : {"name" : "mapping"},
"filters" : [{"name" : "lowercase"}],
"char_filter": {"my_mappings_char_filter": {
"type": "mapping",
"mappings": [
":) => _happy_",
":( => _sad_"
]
}
}'};
// end::index-create-analyzer-mapping-lowercase-idx-v3[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Create index comment_mapping_lowercase_idx v3"
tag="index-describe-analyzer-mapping-lowercase-idx-v3[]"
echo -e "\n// tag:$tag" >> $results_table
$cqlsh -e "
// tag::index-describe-analyzer-mapping-lowercase-idx-v3[]
DESCRIBE INDEX cycling.comment_mapping_lowercase_idx;
// end::index-describe-analyzer-mapping-lowercase-idx-v3[]
" >> $results_table
echo "// end::$tag" >> $results_table
echo "Describe index comment_mapping_lowercase_idx v3"
fi
# Query vector search analyzer mapping lowercase DESCRIBE INDEX cycling.comment_whitespace_lowercase_idx; DESCRIBE INDEX cycling.comment_whitespace_lowercase_idx; DESCRIBE INDEX cycling.comment_whitespace_lowercase_idx; DESCRIBE INDEX cycling.comment_whitespace_stemming_idx; DESCRIBE INDEX cycling.comment_whitespace_stemming_idx; DESCRIBE INDEX cycling.comment_whitespace_stemming_idx; DESCRIBE INDEX cycling.comment_ann_idx; DESCRIBE INDEX cycling.comment_ann_idx; DESCRIBE INDEX cycling.comment_ann_idx; DESCRIBE INDEX cycling.commenter_idx; DESCRIBE INDEX cycling.commenter_idx; DESCRIBE INDEX cycling.commenter_idx; DESCRIBE INDEX cycling.commenter_idx; DESCRIBE INDEX cycling.commenter_idx; DESCRIBE INDEX cycling.commenter_idx; DESCRIBE INDEX cycling.created_at_idx; DESCRIBE INDEX cycling.created_at_idx; DESCRIBE INDEX cycling.created_at_idx; DESCRIBE INDEX cycling.comment_sim_function_idx; DESCRIBE INDEX cycling.comment_sim_function_idx; DESCRIBE INDEX cycling.comment_sim_function_idx; DESCRIBE INDEX cycling.comment_source_model_idx; DESCRIBE INDEX cycling.comment_source_model_idx; DESCRIBE INDEX cycling.comment_source_model_idx;DROP INDEX IF EXISTS cycling.comment_ann_idx;DROP INDEX IF EXISTS cycling.comment_sim_function_idx;DROP INDEX IF EXISTS cycling.comment_source_model_idx;DROP INDEX IF EXISTS cycling.commenter_idx;DROP INDEX IF EXISTS cycling.created_at_idx;SELECT comment,comment_vector,commenter FROM cycling.comments_vs;SELECT comment,comment_vector,commenter FROM cycling.comments_vs
WHERE commenter = 'alex';SELECT comment,comment_vector,commenter FROM cycling.comments_vs
WHERE commenter = 'Alex';SELECT * FROM cycling.comments_vs
ORDER BY comment_vector ANN OF [0.15, 0.1, 0.1, 0.35, 0.55]
LIMIT 3;SELECT comment,comment_vector,commenter FROM cycling.comments_vs
WHERE comment : 'The gift certificate for winning was the best';SELECT comment,comment_vector,commenter FROM cycling.comments_vs
WHERE comment : 'Glad you ran the Race in the Rain';SELECT comment,comment_vector,commenter FROM cycling.comments_vs
WHERE comment : 'ra';SELECT comment,comment_vector,commenter FROM cycling.comments_vs
WHERE comment : 'Glad you ran the Race in the Rain';SELECT comment,comment_vector,commenter FROM cycling.comments_vs
WHERE comment : 'rain';SELECT comment,comment_vector,commenter FROM cycling.comments_vs
WHERE comment : 'rain' AND comment: 'race';SELECT comment,comment_vector,commenter FROM cycling.comments_vs
WHERE comment : 'rain' AND comment: 'race';SELECT comment,comment_vector,commenter FROM cycling.comments_vs
WHERE comment : 'Glad you ran the Race in the Rain';SELECT comment, similarity_cosine(comment_vector, [0.2, 0.15, 0.3, 0.2, 0.05])
FROM cycling.comments_vs
ORDER BY comment_vector ANN OF [0.1, 0.15, 0.3, 0.12, 0.05]
LIMIT 3;SELECT * FROM cycling.comments_vs
ORDER BY comment_vector ANN OF [0.15, 0.1, 0.1, 0.35, 0.55]
LIMIT 3;SELECT * FROM cycling.comments_vs
ORDER BY comment_vector ANN OF [0.15, 0.1, 0.1, 0.35, 0.55]
LIMIT 3;SELECT * FROM cycling.comments_vs
WHERE created_at='2017-03-21 21:11:09.999000+0000'
AND commenter = 'Alex';SELECT * FROM cycling.comments_vs
WHERE created_at IN ('2017-03-21 21:11:09.999000+0000','2017-03-22 01:16:59.001000+0000');SELECT * FROM cycling.comments_vs
WHERE created_at='2017-03-21 21:11:09.999000+0000'
OR created_at='2017-03-22 01:16:59.001000+0000';SELECT * FROM cycling.comments_vs WHERE commenter = 'Alex';SELECT id, commenter, toJson(created_at) FROM cycling.comments_vs;ALTER TABLE cycling.comments_vs
ADD comment_vector VECTOR <FLOAT, 5>; (1)CREATE TABLE IF NOT EXISTS cycling.comments_vs (
record_id timeuuid,
id uuid,
commenter text,
comment text,
comment_vector VECTOR <FLOAT, 5>,
created_at timestamp,
PRIMARY KEY (id, created_at)
)
WITH CLUSTERING ORDER BY (created_at DESC);DESCRIBE TABLE cycling.comments_vs;DROP TABLE IF EXISTS cycling.comments_vs;