[jira] [Commented] (CASSANDRA-13817) cassandra allow filtering bug
[ https://issues.apache.org/jira/browse/CASSANDRA-13817?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16146877#comment-16146877 ] wang huatao commented on CASSANDRA-13817: - cql: SELECT id, name, tankinbattle, level, gold, sliver, globalexp FROM player WHERE name = ? ALLOW FILTERING scala: run(query[Player].filter(_.name == lift(name.toLowerCase)).allowFiltering).headOption > cassandra allow filtering bug > - > > Key: CASSANDRA-13817 > URL: https://issues.apache.org/jira/browse/CASSANDRA-13817 > Project: Cassandra > Issue Type: Bug > Components: CQL, Libraries >Reporter: wang huatao >Assignee: Benjamin Lerer > Labels: allow-filtering > Fix For: 3.10 > > Attachments: player_201708301613.csv > > > I have one bug about cassandra cql, when I use select * from table where > name = 'myName' alllow filtering, sometimes can be found, but sometimes can > not found. I am very sure the row data existed. my data was very small, just > 2000 rows.and only one node. i use cassandra 3.10, ubuntu 14. -- This message was sent by Atlassian JIRA (v6.4.14#64029) - To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org
[jira] [Commented] (CASSANDRA-13817) cassandra allow filtering bug
[ https://issues.apache.org/jira/browse/CASSANDRA-13817?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16146871#comment-16146871 ] wang huatao commented on CASSANDRA-13817: - i upload my test data. > cassandra allow filtering bug > - > > Key: CASSANDRA-13817 > URL: https://issues.apache.org/jira/browse/CASSANDRA-13817 > Project: Cassandra > Issue Type: Bug > Components: CQL, Libraries >Reporter: wang huatao >Assignee: Benjamin Lerer > Labels: allow-filtering > Fix For: 3.10 > > Attachments: player_201708301613.csv > > > I have one bug about cassandra cql, when I use select * from table where > name = 'myName' alllow filtering, sometimes can be found, but sometimes can > not found. I am very sure the row data existed. my data was very small, just > 2000 rows.and only one node. i use cassandra 3.10, ubuntu 14. -- This message was sent by Atlassian JIRA (v6.4.14#64029) - To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org
[jira] [Updated] (CASSANDRA-13817) cassandra allow filtering bug
[ https://issues.apache.org/jira/browse/CASSANDRA-13817?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] wang huatao updated CASSANDRA-13817: Attachment: player_201708301613.csv > cassandra allow filtering bug > - > > Key: CASSANDRA-13817 > URL: https://issues.apache.org/jira/browse/CASSANDRA-13817 > Project: Cassandra > Issue Type: Bug > Components: CQL, Libraries >Reporter: wang huatao >Assignee: Benjamin Lerer > Labels: allow-filtering > Fix For: 3.10 > > Attachments: player_201708301613.csv > > > I have one bug about cassandra cql, when I use select * from table where > name = 'myName' alllow filtering, sometimes can be found, but sometimes can > not found. I am very sure the row data existed. my data was very small, just > 2000 rows.and only one node. i use cassandra 3.10, ubuntu 14. -- This message was sent by Atlassian JIRA (v6.4.14#64029) - To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org
[jira] [Commented] (CASSANDRA-13817) cassandra allow filtering bug
[ https://issues.apache.org/jira/browse/CASSANDRA-13817?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16146867#comment-16146867 ] wang huatao commented on CASSANDRA-13817: - no,only 2000. > cassandra allow filtering bug > - > > Key: CASSANDRA-13817 > URL: https://issues.apache.org/jira/browse/CASSANDRA-13817 > Project: Cassandra > Issue Type: Bug > Components: CQL, Libraries >Reporter: wang huatao >Assignee: Benjamin Lerer > Labels: allow-filtering > Fix For: 3.10 > > > I have one bug about cassandra cql, when I use select * from table where > name = 'myName' alllow filtering, sometimes can be found, but sometimes can > not found. I am very sure the row data existed. my data was very small, just > 2000 rows.and only one node. i use cassandra 3.10, ubuntu 14. -- This message was sent by Atlassian JIRA (v6.4.14#64029) - To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org
[jira] [Commented] (CASSANDRA-13817) cassandra allow filtering bug
[ https://issues.apache.org/jira/browse/CASSANDRA-13817?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16146848#comment-16146848 ] wang huatao commented on CASSANDRA-13817: - id maybe have 2000,and the name have 2000. > cassandra allow filtering bug > - > > Key: CASSANDRA-13817 > URL: https://issues.apache.org/jira/browse/CASSANDRA-13817 > Project: Cassandra > Issue Type: Bug > Components: CQL, Libraries >Reporter: wang huatao >Assignee: Benjamin Lerer > Labels: allow-filtering > Fix For: 3.10 > > > I have one bug about cassandra cql, when I use select * from table where > name = 'myName' alllow filtering, sometimes can be found, but sometimes can > not found. I am very sure the row data existed. my data was very small, just > 2000 rows.and only one node. i use cassandra 3.10, ubuntu 14. -- This message was sent by Atlassian JIRA (v6.4.14#64029) - To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org
[jira] [Commented] (CASSANDRA-13817) cassandra allow filtering bug
[
https://issues.apache.org/jira/browse/CASSANDRA-13817?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16146819#comment-16146819
]
wang huatao commented on CASSANDRA-13817:
-
i use the scala library io.getquill . the scala code like:
def findPlayerByName(name: String) = {
run(query[Player].filter(_.name ==
lift(name.toLowerCase)).allowFiltering).headOption
}
> cassandra allow filtering bug
> -
>
> Key: CASSANDRA-13817
> URL: https://issues.apache.org/jira/browse/CASSANDRA-13817
> Project: Cassandra
> Issue Type: Bug
> Components: CQL, Libraries
>Reporter: wang huatao
>Assignee: Benjamin Lerer
> Labels: allow-filtering
> Fix For: 3.10
>
>
> I have one bug about cassandra cql, when I use select * from table where
> name = 'myName' alllow filtering, sometimes can be found, but sometimes can
> not found. I am very sure the row data existed. my data was very small, just
> 2000 rows.and only one node. i use cassandra 3.10, ubuntu 14.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
-
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
[jira] [Commented] (CASSANDRA-13817) cassandra allow filtering bug
[ https://issues.apache.org/jira/browse/CASSANDRA-13817?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16146815#comment-16146815 ] wang huatao commented on CASSANDRA-13817: - i have just one node,and the rows only 2000. the problem is sometimes i can get the result, sometimes not > cassandra allow filtering bug > - > > Key: CASSANDRA-13817 > URL: https://issues.apache.org/jira/browse/CASSANDRA-13817 > Project: Cassandra > Issue Type: Bug > Components: CQL, Libraries >Reporter: wang huatao >Assignee: Benjamin Lerer > Labels: allow-filtering > Fix For: 3.10 > > > I have one bug about cassandra cql, when I use select * from table where > name = 'myName' alllow filtering, sometimes can be found, but sometimes can > not found. I am very sure the row data existed. my data was very small, just > 2000 rows.and only one node. i use cassandra 3.10, ubuntu 14. -- This message was sent by Atlassian JIRA (v6.4.14#64029) - To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org
[jira] [Commented] (CASSANDRA-13817) cassandra allow filtering bug
[
https://issues.apache.org/jira/browse/CASSANDRA-13817?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16146448#comment-16146448
]
wang huatao commented on CASSANDRA-13817:
-
CREATE TABLE IF NOT EXISTS player (
id text,
name text,
globalexp int,
gold int,
level int,
sliver int,
tankinbattle text,
PRIMARY KEY (id, name)
) WITH CLUSTERING ORDER BY ( name ASC )
AND bloom_filter_fp_chance = 0.01
AND comment = ''
AND crc_check_chance = 1.0
AND dclocal_read_repair_chance = 0.1
AND default_time_to_live = 0
AND gc_grace_seconds = 864000
AND max_index_interval = 2048
AND memtable_flush_period_in_ms = 0
AND min_index_interval = 128
AND read_repair_chance = 0.0
AND speculative_retry = '99.0PERCENTILE'
AND caching = {
'keys' : 'ALL',
'rows_per_partition' : 'ALL'
}
AND compression = {
'chunk_length_in_kb' : 64,
'class' : 'LZ4Compressor',
'enabled' : true
}
AND compaction = {
'class' : 'SizeTieredCompactionStrategy',
'max_threshold' : 32,
'min_threshold' : 4
};
> cassandra allow filtering bug
> -
>
> Key: CASSANDRA-13817
> URL: https://issues.apache.org/jira/browse/CASSANDRA-13817
> Project: Cassandra
> Issue Type: Bug
> Components: CQL, Libraries
>Reporter: wang huatao
> Labels: allow-filtering
> Fix For: 3.10
>
>
> I have one bug about cassandra cql, when I use select * from table where
> name = 'myName' alllow filtering, sometimes can be found, but sometimes can
> not found. I am very sure the row data existed. my data was very small, just
> 2000 rows.and only one node. i use cassandra 3.10, ubuntu 14.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
-
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
[jira] [Updated] (CASSANDRA-13817) cassandra allow filtering bug
[ https://issues.apache.org/jira/browse/CASSANDRA-13817?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] wang huatao updated CASSANDRA-13817: Labels: allow-filtering (was: ) > cassandra allow filtering bug > - > > Key: CASSANDRA-13817 > URL: https://issues.apache.org/jira/browse/CASSANDRA-13817 > Project: Cassandra > Issue Type: Bug > Components: CQL, Libraries >Reporter: wang huatao > Labels: allow-filtering > Fix For: 3.10 > > > I have one bug about cassandra cql, when I use select * from table where > name = 'myName' alllow filtering, sometimes can be found, but sometimes can > not found. I am very sure the row data existed. my data was very small, just > 2000 rows.and only one node. i use cassandra 3.10, ubuntu 14. -- This message was sent by Atlassian JIRA (v6.4.14#64029) - To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org
[jira] [Created] (CASSANDRA-13817) cassandra allow filtering bug
wang huatao created CASSANDRA-13817: --- Summary: cassandra allow filtering bug Key: CASSANDRA-13817 URL: https://issues.apache.org/jira/browse/CASSANDRA-13817 Project: Cassandra Issue Type: Bug Components: CQL, Libraries Reporter: wang huatao Fix For: 3.10 I have one bug about cassandra cql, when I use select * from table where name = 'myName' alllow filtering, sometimes can be found, but sometimes can not found. I am very sure the row data existed. my data was very small, just 2000 rows.and only one node. i use cassandra 3.10, ubuntu 14. -- This message was sent by Atlassian JIRA (v6.4.14#64029) - To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org
