Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-1580

Druid adapter: Wrong semantics for ordering within groupBy queries

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • 1.11.0
    • 1.12.0
    • druid-adapter
    • None

    Description

      The scope of the ordering seems to be for each different granularity value instead of global.

      It can be reproduce with the following kind of query, where there exist multiple values for floor_day(`__time`):

      SELECT i_brand_id, floor_day(`__time`), max(ss_quantity), sum(ss_wholesale_cost) as s
FROM store_sales_sold_time_subset
GROUP BY i_brand_id, floor_day(`__time`)
ORDER BY i_brand_id
LIMIT 10;

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. HIVE-15639 Hive/Druid integration: wrong semantics for ordering within groupBy queries

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

              jcamacho Jesús Camacho Rodríguez
              jcamacho Jesús Camacho Rodríguez
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: