Elasticsearch和PHP。在一个查询中组合match和multi\u match

Question

我有三个字段-一个是整数类型（field1），两个是十进制类型（field2，field3）。我希望能够按所有字段进行查询。在我的情况下，这些单独的查询非常有效：

$params = [
    'index' => 'test_index',
    'type' => 'text_index_type',
    'body' => [
        'query' => [
            'match' => [
                'field1' => '12'
            ]
        ]
    ]
];

这个查询运行良好：

$params = [
    'index' => 'test_index',
    'type' => 'text_index_type',
    'body' => [
        'query' => [
            'multi_match' => [
                'query' => '345',
                'fields' => ['field2', 'field3']
            ]
        ]
    ]
];

但是，如果我将它们结合起来：

$params = [
    'index' => 'test_index',
    'type' => 'text_index_type',
    'body' => [
        'query' => [
            'match' => [
                'field1' => '12'
            ],
           'multi_match' => [
                'query' => '345',
                'fields' => ['field2', 'field3']
            ]
        ]
    ]

];

我得到一个错误：

未捕获的异常'Elasticsearch\Common\Exceptions\BadRequest est400Exception'...[匹配]格式错误的查询，意外的[FIELD_NAME]找到[multi_match]

那么，这有什么问题，我该如何解决呢？

附言。就SQL而言，这是我想要实现的：

 SELECT * FROM mytable where field1 = 12 or field2 = 345 or field3 = 345

Answer 1

您可以将它们与bool查询结合起来

$params = [
    'index' => 'test_index',
    'type' => 'test_index_type',
    'body' => [
        'query' => [
            'bool' => [
                'should' => [
                    [ 'match' => [ 'field1' => '12' ] ],
                    [ 'multi_match' => [ 'query' => '345',
                                         'fields' => ['field2', 'field3']] ],
                ]
            ]
        ]
    ]
];

应该等同于“或”，而必须等同于“与”