在elasticsearch中组合字段(combine fields in elasticsearch)

 假设我在SQL中有一个表，我将两个字段合并为一个 
 
A    |     B
-----|--------         => select A+' '+ B as Name => BMW X-Series
BMW  |   3-Series
BMW  |     X3
 
 我把它转储到临时表中，然后在临时表上进行通配符搜索，返回带有count的结果 
 
select Name,count(Name) as frequency from Table where Name like '%3%' group by Name

     Name        Frequency
     ------------------  
    BMW 3-Series |  1
    BMW  X3      |  1
 
 现在我如何实现同样的弹性搜索，因为A和B是单独的字段。 
 
 我试过这个： 
 
{ "query":{
      "query_string":{
          "fields":["A","B"],
          "query":"3"
      }
      }, "aggs": {
    "count": {
      "terms": {
        "field": "A"
      },
      "aggs": {
        "count": {
          "terms": {
            "field": "B"
          }

        }
      }
    }
  }

}
 
 如何在查询上添加正则表达式 

Suppose I have a table in SQL where I combine two fields as one
 
A    |     B
-----|--------         => select A+' '+ B as Name => BMW X-Series
BMW  |   3-Series
BMW  |     X3
 
I dump it into a temp table and I do a wildcard search on the temp table which returns the result with count
 
select Name,count(Name) as frequency from Table where Name like '%3%' group by Name

     Name        Frequency
     ------------------  
    BMW 3-Series |  1
    BMW  X3      |  1
 
Now how do I achieve the same is elasticsearch given that A and B are seperate fields.
 
I tried this:
 
{ "query":{
      "query_string":{
          "fields":["A","B"],
          "query":"3"
      }
      }, "aggs": {
    "count": {
      "terms": {
        "field": "A"
      },
      "aggs": {
        "count": {
          "terms": {
            "field": "B"
          }

        }
      }
    }
  }

}
 
How do I add regular expression on the query

原文：https://stackoverflow.com/questions/37364155