[
https://issues.apache.org/jira/browse/CASSANDRA-11136?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15141635#comment-15141635
]
Ariel Weisberg commented on CASSANDRA-11136:
--------------------------------------------
I am having trouble after this commit. Things work if I revert
[f8e86eb341aa5bb36e747ce4f31f56dcbaea7089|https://github.com/apache/cassandra/commit/f8e86eb341aa5bb36e747ce4f31f56dcbaea7089].
{noformat}
Ariels-MBP-2:schema aweisberg$ ../../../../bin/cqlsh
Connected to Test Cluster at blade:9042.
[cqlsh 5.0.1 | Cassandra 3.4-SNAPSHOT | DSE | CQL spec 3.4.0 | Native protocol
v4]
Use HELP for help.
cqlsh> describe keyspaces;
system_traces system_schema system_auth system system_distributed
cqlsh> ^D
Ariels-MBP-2:schema aweisberg$ ../../../../bin/cqlsh -f
create_table_geo_sasi.cql
create_table_geo_sasi.cql:17:ConfigurationException: <ErrorMessage code=2300
[Query invalid because of configuration issue] message="Index on 'latitude'
already exists, SASI doesn't support multiple indexes per column.">
create_table_geo_sasi.cql:18:ConfigurationException: <ErrorMessage code=2300
[Query invalid because of configuration issue] message="Index on 'latitude'
already exists, SASI doesn't support multiple indexes per column.">
create_table_geo_sasi.cql:19:ConfigurationException: <ErrorMessage code=2300
[Query invalid because of configuration issue] message="Index on 'latitude'
already exists, SASI doesn't support multiple indexes per column.">
create_table_geo_sasi.cql:20:ConfigurationException: <ErrorMessage code=2300
[Query invalid because of configuration issue] message="Index on 'latitude'
already exists, SASI doesn't support multiple indexes per column.">
create_table_geo_sasi.cql:21:ConfigurationException: <ErrorMessage code=2300
[Query invalid because of configuration issue] message="Index on 'latitude'
already exists, SASI doesn't support multiple indexes per column.">
create_table_geo_sasi.cql:22:ConfigurationException: <ErrorMessage code=2300
[Query invalid because of configuration issue] message="Index on 'latitude'
already exists, SASI doesn't support multiple indexes per column.">
Ariels-MBP-2:schema aweisberg$ cat create_table_geo_sasi.cql
CREATE KEYSPACE IF NOT EXISTS demo WITH REPLICATION = { 'class' :
'SimpleStrategy', 'replication_factor' : 1 };
USE demo;
create table if not exists geort (
"id" VARCHAR PRIMARY KEY,
"name" VARCHAR,
"latitude" VARCHAR,
"longitude" VARCHAR,
"country" VARCHAR,
"timezone" VARCHAR,
"published" VARCHAR,
"text" TEXT);
create custom index on geort (latitude) USING
'org.apache.cassandra.index.sasi.SASIIndex' WITH OPTIONS = { 'analyzer_class' :
'org.apache.cassandra.index.sasi.analyzer.NonTokenizingAnalyzer', 'mode' :
'PREFIX' };
create custom index on geort (longitude) USING
'org.apache.cassandra.index.sasi.SASIIndex' WITH OPTIONS = { 'analyzer_class' :
'org.apache.cassandra.index.sasi.analyzer.NonTokenizingAnalyzer', 'mode' :
'PREFIX' };
create custom index on geort (name) USING
'org.apache.cassandra.index.sasi.SASIIndex' WITH OPTIONS = { 'analyzer_class' :
'org.apache.cassandra.index.sasi.analyzer.StandardAnalyzer', 'mode' :
'CONTAINS' };
create custom index on geort (country) USING
'org.apache.cassandra.index.sasi.SASIIndex' WITH OPTIONS = { 'analyzer_class' :
'org.apache.cassandra.index.sasi.analyzer.StandardAnalyzer', 'mode' :
'CONTAINS' };
create custom index on geort (timezone) USING
'org.apache.cassandra.index.sasi.SASIIndex' WITH OPTIONS = { 'analyzer_class' :
'org.apache.cassandra.index.sasi.analyzer.StandardAnalyzer', 'mode' :
'CONTAINS' };
create custom index on geort (published) USING
'org.apache.cassandra.index.sasi.SASIIndex' WITH OPTIONS = { 'analyzer_class' :
'org.apache.cassandra.index.sasi.analyzer.NonTokenizingAnalyzer', 'mode' :
'PREFIX' };
create custom index on geort (text) USING
'org.apache.cassandra.index.sasi.SASIIndex' WITH OPTIONS = { 'analyzer_class' :
'org.apache.cassandra.index.sasi.analyzer.StandardAnalyzer', 'mode' :
'CONTAINS' };
{noformat}
> SASI index options validation
> -----------------------------
>
> Key: CASSANDRA-11136
> URL: https://issues.apache.org/jira/browse/CASSANDRA-11136
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Reporter: Pavel Yaskevich
> Assignee: Pavel Yaskevich
> Fix For: 3.4
>
>
> This is an umbrella issue for CASSANDRA-\{11129, 11132, 11133, 11134\}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
