[CALCITE-2585] Support NOT Operator in ElasticSearch Adapter

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.18.0
• Component/s: elasticsearch-adapter
• Assignee: Julian Hyde
• Reporter: Andrei Sereda
• Created: 21/Sep/18 21:04
• Updated: 23/Dec/18 00:11
• Resolved: 21/Sep/18 22:33

Description

NOT boolean expressions should be correctly processed by Calcite (ES adapter):

select * from elastic where not foo = 1
select * from elastic where not foo in (1, 2, 3)
select * from elastic where foo not in (1, 2, 3)
select * from elastic where not (foo in (1, 2, 3) and bar in (42, 43, 44))

In elastic, they're converted to must_not BoolQuery.

Issue Links

• links to: PR#851