doubei2231 2016-08-24 06:39
浏览 115
已采纳

不能在Elasticsearch中使用两个或更多过滤器

I'm using Elasticsearch in my project. My Elasticsearch query is like that:

Array(
    [index] => galaxy
    [type] => galaxy
    [size] => 1000
    [from] => 0
    [body] => Array(
        [query] => Array(
            [filtered] => Array(
                [query] => Array(
                    [query_string] => Array(
                        [default_operator] => AND
                        [query] => vestel*
                    )
                )
                [filter] => Array(
                    [bool] => Array(
                        [must] => Array(
                            [term] => Array(
                                [fk_product_category] => 1
                                [fk_product_group] => 1
                            )
                        )
                    )
                )
            )
        )
    )
)

When I remove one of the filters terms for example fk_product_group it works perfectly but when use both filters I get fatal error with code 400 Bad request.

  • 写回答

1条回答 默认 最新

  • dsj8000 2016-08-24 06:56
    关注

    Each filter must be in its own term filter

    Array(
        [index] => galaxy
        [type] => galaxy
        [size] => 1000
        [from] => 0
        [body] => Array(
            [query] => Array(
                [filtered] => Array(
                    [query] => Array(
                        [query_string] => Array(
                            [default_operator] => AND
                            [query] => vestel*
                        )
                    )
                    [filter] => Array(
                        [bool] => Array(
                            [must] => Array(
                                Array(
                                   [term] => Array(
                                       [fk_product_category] => 1
                                   )
                                ),
                                Array(
                                   [term] => Array(
                                       [fk_product_group] => 1
                                   )
                                )
                            )
                        )
                    )
                )
            )
        )
    )
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 求解,我这个代码为什么运行不了
  • ¥15 remotes安装提示没有description文件
  • ¥15 AttributeError: 'NoneType' object has no attribute 'drop_duplicates'报错
  • ¥15 以下代码,运行结果报错
  • ¥15 Vivado仿真数据出错
  • ¥15 银河麒麟不支持vant等前端框架怎么办?
  • ¥15 vue3的子组件在父页面调用不显示不生效问题
  • ¥15 cadence PEX
  • ¥15 phython创建了文件 显示在项目下面,但运行不了,运行时还是运行main文件,并且说main文件不允许并行运行
  • ¥15 FutureWarning:不推荐使用空或全 NA 条目的 DataFrame 串联行为。怎么改呢?