[
https://issues.apache.org/jira/browse/CALCITE-2553?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Andrei Sereda updated CALCITE-2553:
-----------------------------------
Description:
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 was discussed as followup to
[PR-822|https://github.com/apache/calcite/pull/822#discussion_r217044753]
was:
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).
> 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
> Priority: Major
>
> 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 was discussed as followup to
> [PR-822|https://github.com/apache/calcite/pull/822#discussion_r217044753]
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
