how to query fieldA=fieldB in ElasticSearch?

Question

I want to query similary follow's SQL :

select * from talbe where id=cityid

Who know how to implement in es ?

thanks for your answer !

duplicate question stackoverflow.com/questions/31615142/…

MrRolling
– MrRolling

2016-08-09 08:22:20 +00:00
Commented Aug 9, 2016 at 8:22 — MrRolling
– MrRolling, Commented Aug 9, 2016 at 8:22
stackoverflow.com/questions/36539447/…

MrRolling
– MrRolling

2016-08-09 08:25:21 +00:00
Commented Aug 9, 2016 at 8:25 — MrRolling
– MrRolling, Commented Aug 9, 2016 at 8:25

Val · Accepted Answer · 2016-08-09 05:23:07Z

0

You can do this with a script filter like this:

POST /table/_search
{
  "query": {
    "bool": {
      "filter": {
        "script": {
          "script": "doc.id.value == doc.cityid.value"
        }
      }
    }
  }
}

answered Aug 9, 2016 at 5:23

Val

218k14 gold badges377 silver badges384 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Qin Dong Liang Over a year ago

Only numeric fields may be accessed，Do you have any other way ?

Qin Dong Liang Over a year ago

my id and cityid is string

Val Over a year ago

have you tried the script? == in groovy is like equals in Java

Qin Dong Liang Over a year ago

thanks @Val , i need time to study how to use groovy in es, if sucess, i can update this problem status ,thanks again !

Val Over a year ago

You simply need to enable dynamic scripting in elasticsearch.yml, restart ES and that's it.

|

Collectives™ on Stack Overflow

how to query fieldA=fieldB in ElasticSearch?

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related