cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrés de la Peña (JIRA) <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-13817) cassandra allow filtering bug
Date Wed, 25 Oct 2017 17:58:00 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-13817?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16219190#comment-16219190
] 

Andrés de la Peña commented on CASSANDRA-13817:
-----------------------------------------------

I have tested this with the provided schema and dataset in a 3.10 single-node cluster:
{code}
public static void main(String[] args)
{
    Cluster cluster = Cluster.builder().addContactPoint("localhost").build();
    Session session = cluster.newSession();

    // Get the names and their number of occurrences
    Map<String, Integer> names = session.execute("SELECT name FROM k.player")
                                        .all()
                                        .stream()
                                        .map(row -> row.getString("name"))
                                        .collect(Collectors.toConcurrentMap(name -> name,
name -> 1, Integer::sum));

    // For each name, verify that the query returns the same number of occurrences
    PreparedStatement query = session.prepare("SELECT * FROM k.player WHERE name=? ALLOW FILTERING");
    names.forEach((name, occurrences) -> {
        if (session.execute(query.bind(name)).all().size() != occurrences)
            throw new RuntimeException("Error at name: " + name);
    });

    session.close();
    cluster.close();
}
{code}
The test is able to retrieve each of the 1580 names in the provided CSV file (there is a single
id per name). Could you please run this test in your cluster?

> 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: Andrés de la Peña
>              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-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org


Mime
View raw message