Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-6339

Older client using aggregate queries shows incorrect results.

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 5.1.0, 4.16.0
    • Fix Version/s: 5.1.0, 4.16.0
    • Component/s: None
    • Labels:
      None

      Description

      When running an older client for eg (4.15) against a 4.16 server
      The output of aggregate queries are incorrect -

      expected one row with the count, actual 9 rows with counts.

      The 9 rows correspond to the number of regions in the data set. As shown in the explain plan.

      Connected to: Phoenix (version 4.15)
      Driver: PhoenixEmbeddedDriver (version 4.15)
      Autocommit status: true
      Transaction isolation: TRANSACTION_READ_COMMITTED
      Building list of tables and columns for tab-completion (set fastconnect to true to skip)...
      225/225 (100%) Done
      Done
      sqlline version 1.5.0
      0: jdbc:phoenix:localhost> select count from BENCHMARK.BM_AGGREGATION_TABLE_2;
      -----------

      COUNT(1)

      -----------

      2389483
      2319177
      1958007
      2389483
      2319178
      1958005
      2233646
      2249033
      2183988

      -----------
      9 rows selected (6.56 seconds)
      0: jdbc:phoenix:localhost> explain select count from BENCHMARK.BM_AGGREGATION_TABLE_2;
      ----------------------------------------------------------------------------------------------------------------------------------------------------------+

      PLAN EST_BYTES_READ EST_ROWS_READ EST_INFO_TS

      ----------------------------------------------------------------------------------------------------------------------------------------------------------+

      CLIENT 9-CHUNK 10191406 ROWS 1887436990 BYTES PARALLEL 1-WAY FULL SCAN OVER BENCHMARK.BM_AGGREGATION_TABLE_2 1887436990 10191406 1611584394492
      SERVER FILTER BY FIRST KEY ONLY 1887436990 10191406 1611584394492
      SERVER AGGREGATE INTO SINGLE ROW 1887436990 10191406 1611584394492

      ----------------------------------------------------------------------------------------------------------------------------------------------------------+

        Attachments

          Activity

            People

            • Assignee:
              kozdemir Kadir OZDEMIR
              Reporter:
              jisaac Jacob Isaac

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment