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

ES Adapter. Grouping on date / number fields fails

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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

          Activity

            People

            • Assignee:
              julianhyde Julian Hyde
              Reporter:
              sereda Andrei Sereda

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment