1. select * from abc
Post abc/_search
{
"query": {
"match_all": {}
}
}
2.select * from abc where a=1 and b=2
Post abc/_search
{
"query": {
"bool": {
"filter": [{
"term": {
"a": 1
}
},
{
"term": {
"b": 2
}
}
]
}
}
}
3.select * from abc where a in(1,2)
{
"query": {
"bool": {
"filter": [
{
"terms": {
"a": [
1,
2
]
}
}
]
}
}
}
4.select * from abc where a between 1and 3
{
"query": {