[jira] [Commented] (CASSANDRA-11183) Enable SASI index for static columns
[ https://issues.apache.org/jira/browse/CASSANDRA-11183?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15223954#comment-15223954 ] Sam Tunnicliffe commented on CASSANDRA-11183: - [~xedin] great, thanks! > Enable SASI index for static columns > > > Key: CASSANDRA-11183 > URL: https://issues.apache.org/jira/browse/CASSANDRA-11183 > Project: Cassandra > Issue Type: Improvement > Components: sasi >Reporter: DOAN DuyHai >Assignee: DOAN DuyHai >Priority: Minor > Fix For: 3.6 > > Attachments: CASSANDRA-11183-statics.patch, > patch_SASI_for_Static_FINAL_Review.txt > > > This is a follow up ticket for post Cassandra 3.4 SASI integration. > Since [CASSANDRA-8103] it is possible to index static columns, which is > *extremely useful* for some scenarios (find all sensors whose characteristics > are saved in static columns) > /cc [~xedin] [~rustyrazorblade] [~jkrupan] -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (CASSANDRA-11183) Enable SASI index for static columns
[ https://issues.apache.org/jira/browse/CASSANDRA-11183?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15223900#comment-15223900 ] Pavel Yaskevich commented on CASSANDRA-11183: - [~beobal] My commit also fixes SecondaryIndexTest for LIKE operator after CASSANDRA-11434 has added support for prefix/eq for CONTAINS mode. > Enable SASI index for static columns > > > Key: CASSANDRA-11183 > URL: https://issues.apache.org/jira/browse/CASSANDRA-11183 > Project: Cassandra > Issue Type: Improvement > Components: sasi >Reporter: DOAN DuyHai >Assignee: DOAN DuyHai >Priority: Minor > Fix For: 3.6 > > Attachments: CASSANDRA-11183-statics.patch, > patch_SASI_for_Static_FINAL_Review.txt > > > This is a follow up ticket for post Cassandra 3.4 SASI integration. > Since [CASSANDRA-8103] it is possible to index static columns, which is > *extremely useful* for some scenarios (find all sensors whose characteristics > are saved in static columns) > /cc [~xedin] [~rustyrazorblade] [~jkrupan] -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (CASSANDRA-11183) Enable SASI index for static columns
[ https://issues.apache.org/jira/browse/CASSANDRA-11183?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15223802#comment-15223802 ] Pavel Yaskevich commented on CASSANDRA-11183: - Thanks, [~doanduyhai]! I've fixed a couple of styling errors, removed old param from JavaDoc for localSatisfiedBy, fixed ColumnIndex to flush staticRow and added flush to the SASI test to make sure that it works for both memtable and sstable (it was only testing memtable). Everything is pushed and I've kicked off CI build ||branch||testall||dtest|| |[CASSANDRA-11183|https://github.com/xedin/cassandra/tree/CASSANDRA-11183]|[testall|http://cassci.datastax.com/job/xedin-CASSANDRA-11183-testall/]|[dtest|http://cassci.datastax.com/job/xedin-CASSANDRA-11183-dtest/]| > Enable SASI index for static columns > > > Key: CASSANDRA-11183 > URL: https://issues.apache.org/jira/browse/CASSANDRA-11183 > Project: Cassandra > Issue Type: Improvement > Components: sasi >Reporter: DOAN DuyHai >Assignee: DOAN DuyHai >Priority: Minor > Fix For: 3.6 > > Attachments: CASSANDRA-11183-statics.patch, > patch_SASI_for_Static_FINAL_Review.txt > > > This is a follow up ticket for post Cassandra 3.4 SASI integration. > Since [CASSANDRA-8103] it is possible to index static columns, which is > *extremely useful* for some scenarios (find all sensors whose characteristics > are saved in static columns) > /cc [~xedin] [~rustyrazorblade] [~jkrupan] -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (CASSANDRA-11183) Enable SASI index for static columns
[
https://issues.apache.org/jira/browse/CASSANDRA-11183?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15223100#comment-15223100
]
Pavel Yaskevich commented on CASSANDRA-11183:
-
I think it would be better if instead of Set satisfiesBy and
localSatisfiesBy methods are to have staticRow instead e.g.
{{\{local\}SatisfiedBy(Unfiltered currentCluster, Row statics, boolean
allowMissingColumns)}} and {{ColumnIndex.getValue(ColumnDefinition, Row
cluster, Row statics, int now)}} would just pick correct row to get value data
from by adding {{case STATIC}}.
> Enable SASI index for static columns
>
>
> Key: CASSANDRA-11183
> URL: https://issues.apache.org/jira/browse/CASSANDRA-11183
> Project: Cassandra
> Issue Type: Improvement
> Components: CQL
>Reporter: DOAN DuyHai
>Assignee: DOAN DuyHai
>Priority: Minor
> Fix For: 3.6
>
> Attachments: patch_SASI_for_Static.txt
>
>
> This is a follow up ticket for post Cassandra 3.4 SASI integration.
> Since [CASSANDRA-8103] it is possible to index static columns, which is
> *extremely useful* for some scenarios (find all sensors whose characteristics
> are saved in static columns)
> /cc [~xedin] [~rustyrazorblade] [~jkrupan]
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (CASSANDRA-11183) Enable SASI index for static columns
[
https://issues.apache.org/jira/browse/CASSANDRA-11183?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15222859#comment-15222859
]
DOAN DuyHai commented on CASSANDRA-11183:
-
*Test scenario*
*Schema* & *data*:
{noformat}
CREATE TABLE sensors(
sensor_id int,
sensor_type text static,
date bigint,
value double,
variance int,
PRIMARY KEY(sensor_id, date)
);
INSERT INTO sensors(sensor_id,sensor_type) VALUES(1, 'TEMPERATURE');
INSERT INTO sensors(sensor_id,date,value,variance) VALUES(1, 20160401, 24.46,
2);
INSERT INTO sensors(sensor_id,date,value,variance) VALUES(1, 20160402, 25.62,
5);
INSERT INTO sensors(sensor_id,date,value,variance) VALUES(1, 20160403, 24.96,
4);
INSERT INTO sensors(sensor_id,sensor_type) VALUES(2, 'PRESSURE');
INSERT INTO sensors(sensor_id,date,value,variance) VALUES(2, 20160401, 1.03, 9);
INSERT INTO sensors(sensor_id,date,value,variance) VALUES(2, 20160402, 1.04, 7);
INSERT INTO sensors(sensor_id,date,value,variance) VALUES(2, 20160403, 1.01, 4);
CREATE CUSTOM INDEX ON test.sensors (sensor_type) USING
'org.apache.cassandra.index.sasi.SASIIndex' WITH OPTIONS = {'mode': 'PREFIX',
'analyzer_class':
'org.apache.cassandra.index.sasi.analyzer.NonTokenizingAnalyzer',
'case_sensitive': 'false'};
CREATE CUSTOM INDEX ON test.sensors (variance) USING
'org.apache.cassandra.index.sasi.SASIIndex';
CREATE CUSTOM INDEX ON test.sensors (value) USING
'org.apache.cassandra.index.sasi.SASIIndex';
{noformat}
*Tests*:
{noformat}
//All data
SELECT * FROM sensors ;
sensor_id | date | sensor_type | value | variance
---+--+-+---+--
1 | 20160401 | TEMPERATURE | 24.46 |2
1 | 20160402 | TEMPERATURE | 25.62 |5
1 | 20160403 | TEMPERATURE | 24.96 |4
2 | 20160401 |PRESSURE | 1.03 |9
2 | 20160402 |PRESSURE | 1.04 |7
2 | 20160403 |PRESSURE | 1.01 |4
// Static column only with prefix
SELECT * FROM sensors WHERE sensor_type LIKE 'temp%';
sensor_id | date | sensor_type | value | variance
---+--+-+---+--
1 | 20160401 | TEMPERATURE | 24.46 |2
1 | 20160402 | TEMPERATURE | 25.62 |5
1 | 20160403 | TEMPERATURE | 24.96 |4
// EQ on static column combined with non static columns
SELECT * FROM sensors WHERE sensor_type='pressure' AND value >= 1.02 AND value
<= 1.05 AND variance = 7 ALLOW FILTERING;
sensor_id | date | sensor_type | value | variance
---+--+-+---+--
2 | 20160402 |PRESSURE | 1.04 |7
// Non static columns only
SELECT * FROM sensors WHERE value >= 1.02 AND variance <= 7 ALLOW FILTERING;
sensor_id | date | sensor_type | value | variance
---+--+-+---+--
1 | 20160401 | TEMPERATURE | 24.46 |2
1 | 20160402 | TEMPERATURE | 25.62 |5
1 | 20160403 | TEMPERATURE | 24.96 |4
2 | 20160402 |PRESSURE | 1.04 |7
{noformat}
> Enable SASI index for static columns
>
>
> Key: CASSANDRA-11183
> URL: https://issues.apache.org/jira/browse/CASSANDRA-11183
> Project: Cassandra
> Issue Type: Improvement
> Components: CQL
>Reporter: DOAN DuyHai
>Assignee: DOAN DuyHai
>Priority: Minor
> Attachments: patch_SASI_for_Static.txt
>
>
> This is a follow up ticket for post Cassandra 3.4 SASI integration.
> Since [CASSANDRA-8103] it is possible to index static columns, which is
> *extremely useful* for some scenarios (find all sensors whose characteristics
> are saved in static columns)
> /cc [~xedin] [~rustyrazorblade] [~jkrupan]
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
