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

ES Adapter. Grouping on date / number fields fails

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.18.0
    • Component/s: elasticsearch-adapter
    • Labels:
      None

      Description

      For Terms Aggregation missing value has to have same type as group key:

      select max(amount), date from orders group by date -- date column is of type date (in ES)
      

      Currently single (text) key is used _MISSING_ which fails when grouping on non-string fields (eg. dates, numbers or booleans).

      When using missing (value) query converter should consider field type.

      This logic should be reviewed once we migrate to composite aggregations (available since 6.1 see PR26800)

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                julianhyde Julian Hyde
                Reporter:
                sereda Andrei Sereda
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: