[
https://issues.apache.org/jira/browse/CALCITE-4292?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17218294#comment-17218294
]
Shlok Srivastava edited comment on CALCITE-4292 at 10/21/20, 1:58 PM:
----------------------------------------------------------------------
[~danny0405] Updated the defect description.
was (Author: shlok7296):
[~danny0405] As must_not API corresponds to notLike query in elasticsearch,
therefore removing the must clause from notLike QueryBuilder in order to keep
the queries in sync.
> Remove exist condition from Not equals criteria
> -----------------------------------------------
>
> Key: CALCITE-4292
> URL: https://issues.apache.org/jira/browse/CALCITE-4292
> Project: Calcite
> Issue Type: Bug
> Components: elasticsearch-adapter
> Reporter: Shlok Srivastava
> Assignee: Bill Neil
> Priority: Major
> Labels: ElasticSearch, NotEquals, QueryBuilder, calcite,
> pull-request-available
> Time Spent: 10m
> Remaining Estimate: 0h
>
> Sample Elasticsearch query prepared by calcite for *notEqual* condition :
> {code:java}
> Name != "NMQAX"{code}
> RelNode for same -
> {code:java}
> relB.not(relb.literal("Name"),relb.literal"NMQAX"){code}
>
> The elasticsearch query formed is this :
> {code:java}
> {
> "query": {
> "constant_score": {
> "filter": {
> "bool": {
> "must": {
> "exists": {
> "field": "Name"
> }
> },
> "must_not": {
> "term": {
> "Name": "NMQAX"
> }
> }
> }
> }
> }
> }
> }
> {code}
> *Problem* : The above query ignores document which do not have _Name_ field
> which is ideally included by elasticsearch but ignored due to must exists
> condition.
> *Solution* : Remove the exists condition from Not equals Query Expression.
> Elasticsearch doesn't put this condition therefore keeping queries in sync.
> [Code|https://github.com/apache/calcite/blob/1050b36cafbb0c487b7a2ade3efd12850609717e/elasticsearch/src/main/java/org/apache/calcite/adapter/elasticsearch/PredicateAnalyzer.java#L782]
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
