ES 如何实现 SQL 查询条件 （name=1 or name=2 ） and （status=1 or status =2）

POST _sql/translate

{

  "query": "select * from log_5c54dd7a87604fa195aad3224ab93a49 where (test=1 or test=2) and (test2=1 or test2 =2)"

}

{

  "size": 1000,

  "query": {

    "bool": {

      "must": [

        {

          "bool": {

            "should": [

              {

                "term": {

                  "test.keyword": {

                    "value": 1,

                    "boost": 1

                  }

                }

              },

              {

                "term": {

                  "test.keyword": {

                    "value": 2,

                    "boost": 1

                  }

                }

              }

            ],

            "adjust_pure_negative": true,

            "boost": 1

          }

        },

        {

          "bool": {

            "should": [

              {

                "term": {

                  "test2.keyword": {

                    "value": 1,

                    "boost": 1

                  }

                }

              },

              {

                "term": {

                  "test2.keyword": {

                    "value": 2,

                    "boost": 1

                  }

                }

              }

            ],

            "adjust_pure_negative": true,

            "boost": 1

          }

        }

      ],

      "adjust_pure_negative": true,

      "boost": 1

    }

  },

  "_source": {

    "includes": [

      "input.type",

      "test",

      "test2"

    ],

    "excludes": [



    ]

  },

  "docvalue_fields": [

    {

      "field": "@timestamp",

      "format": "epoch_millis"

    }

  ],

  "sort": [

    {

      "_doc": {

        "order": "asc"

      }

    }

  ]

}