[CALCITE-4860] In Elasticsearch adapter, support NULLS FIRST and NULLS LAST query

• Type: Bug
• Status: In Progress
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.27.0
• Component/s: elasticsearch-adapter
• Labels: pull-request-available
• Assignee: ZheHu
• Reporter: xiong duan
• Created: 19/Oct/21 06:20
• Updated: 09/May/23 08:22

Description

In Elasticsearch Adapter, The SQL:

@Test void integerCat3() {
  CalciteAssert.that()
      .with(newConnectionFactory())
      .query("select cat1 from view order by cat1 nulls first")
      .returns("cat1=a\n" +
          "cat1=b\n" +
          "cat1=null\n");
}

NULLS FIRST don't handle.

According  es_missing_values . We can add another parameter in the script to implement this.

Issue Links

• links to: GitHub Pull Request #2657