Andrei Sereda created CALCITE-2689: -------------------------------------- Summary: ES Adapter. Grouping on date / number fields fails Key: CALCITE-2689 URL: https://issues.apache.org/jira/browse/CALCITE-2689 Project: Calcite Issue Type: Improvement Components: elasticsearch-adapter Reporter: Andrei Sereda Assignee: Julian Hyde
For [TermsĀ Aggregation|https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket-terms-aggregation.html] missing value has to have same type as group key. 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 message was sent by Atlassian JIRA (v7.6.3#76005)