You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by "Andrei Sereda (JIRA)" <ji...@apache.org> on 2018/09/12 14:04:00 UTC

[jira] [Created] (CALCITE-2553) Support NullDirection in Sorting for ElasticSearch Adapter

Andrei Sereda created CALCITE-2553:
--------------------------------------

             Summary: Support NullDirection in Sorting for ElasticSearch Adapter
                 Key: CALCITE-2553
                 URL: https://issues.apache.org/jira/browse/CALCITE-2553
             Project: Calcite
          Issue Type: Bug
          Components: elasticsearch-adapter
            Reporter: Andrei Sereda
            Assignee: Julian Hyde


Allow {{NULLS FIRST / LAST}} in {{ORDER BY}} clauses in ES adapter. Currently they're ignored.

This can be possibly achieved with [Bucket aggregation sorting|https://www.elastic.co/guide/en/elasticsearch/reference/6.1/search-aggregations-pipeline-bucket-sort-aggregation.html] (for aggregations) and/or [Script Based Sorting|https://www.elastic.co/guide/en/elasticsearch/reference/current/search-request-sort.html#_script_based_sorting] (for regular queries). 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)