Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-6826

Query returns different number of results depending on fetchsize

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Normal
    • Resolution: Fixed
    • None
    • None
    • None
    • quad-core Windows 7 x64, single node cluster
      Cassandra 2.0.5

    • Normal

    Description

      I issue a query across the set of partitioned wide rows for one logical row, where s, l, and partition specify the composite primary key for the row:
      SELECT ec, ea, rd FROM sr WHERE s = ? and partition IN ? and l = ? ALLOW FILTERING;

      If I set fetchSize to only 1000 when the Cluster is configured, the query sometimes does not return all the results. In the particular case I am chasing, it returns a total of 98586 rows. If I increase the fetchsize to 100000, all the 99999 actual rows are returned. This suggests there is some problem with fetchsize re-establishing the position on the next segment of the result set, at least when multiple partitions are being accessed.

      Attachments

        Issue Links

          Activity

            People

              slebresne Sylvain Lebresne
              wtmitchell3 Bill Mitchell
              Sylvain Lebresne
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: