在match_phrase中设置slop

[yuanxiaoqi]

怎么在sql语句中设置slop啊。默认是0

[shi-yuan]

目前不支持呢，这个近期会加上的，谢谢

[yuanxiaoqi]

你好，我在paramer里面设置了一下判断，当sqlExpr不是SQLIntegerExpr的时候就把sqlExpr强转为SQLUnaryExpr，然后获取它的expr当slop，在数字前面加~和！都被算是unary，然后可以正确取到slop，不过+和-还是被算作是boost的类型。这样简单实现了一下。。谢谢！

[shi-yuan]

select address from bank where address= matchPhrase(query='671 Bristol Street', analyzer='keyword', boost=1.0, slop=0)

{
    "from": 0,
    "size": 200,
    "query": {
        "bool": {
            "filter": [
                {
                    "bool": {
                        "must": [
                            {
                                "match_phrase": {
                                    "address": {
                                        "query": "671 Bristol Street",
                                        "analyzer": "keyword",
                                        "slop": 0,
                                        "boost": 1
                                    }
                                }
                            }
                        ],
                        "disable_coord": false,
                        "adjust_pure_negative": true,
                        "boost": 1
                    }
                }
            ],
            "disable_coord": false,
            "adjust_pure_negative": true,
            "boost": 1
        }
    },
    "_source": {
        "includes": [
            "address"
        ],
        "excludes": []
    }
}