drrvnbwle80177811 2016-02-01 06:07
浏览 236
已采纳

Elasticsearch NOT带有AND和OR的布尔运算符

I want to include and exclude the expertise using AND and OR ,Include with AND and OR operation working fine.But when using exclude expertise with AND and OR ,returns the same result count as 3. I am using elastic search version 1.4. Help me to fix this issue. Thanks in advance.

Below is my code OR operation with NOT

{
  "query_string": {
    "query": "et_tax:\"Commercial\" et_tax: \"Technology, Media & Telecoms\" AND ( -et_tax:\"Hotel,Leisure & Hospitality\" OR  -et_tax:\"Mergers & Acquisitions\")"
  }
}      

AND operation with NOT

{
  "query_string": {
    "query": "et_tax:\"Commercial\" et_tax: \"Technology, Media & Telecoms\" AND  -et_tax:\"Hotel,Leisure & Hospitality\" AND  -et_tax:\"Mergers & Acquisitions\""
  }
}
  • 写回答

1条回答 默认 最新

  • doudi8829 2016-02-03 11:28
    关注

    I found the answer for my question for AND operation

    AND NOT(et_tax:\"Hotel,Leisure & Hospitality\" AND et_tax:\"Mergers & Acquisitions\")

    For OR operation

    AND NOT(et_tax:\"Hotel,Leisure & Hospitality\" OR et_tax:\"Mergers & Acquisitions\")

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 (希望可以解决问题)ma和mb文件无法正常打开,打开后是空白,但是有正常内存占用,但可以在打开Maya应用程序后打开场景ma和mb格式。
  • ¥20 ML307A在使用AT命令连接EMQX平台的MQTT时被拒绝
  • ¥20 腾讯企业邮箱邮件可以恢复么
  • ¥15 有人知道怎么将自己的迁移策略布到edgecloudsim上使用吗?
  • ¥15 错误 LNK2001 无法解析的外部符号
  • ¥50 安装pyaudiokits失败
  • ¥15 计组这些题应该咋做呀
  • ¥60 更换迈创SOL6M4AE卡的时候,驱动要重新装才能使用,怎么解决?
  • ¥15 让node服务器有自动加载文件的功能
  • ¥15 jmeter脚本回放有的是对的有的是错的