What is search query
{ "query": { "match_all": {} } }
params
- match_all
- size (default to 10) how many search hits
- from - where to start, useful for paging (default 0)
- sort
- balance -> order
- _source - can be specified to only return specific fields (SQL select from)
- match (SQL where)
- match_phrase (SQL where exact)
- bool
- must/must_not -> array contains params and relationship
- should -> ... or relationship
- _score - result relevancy
- filter
- range - balance -> gte, lte, etc, use with filter
aggrgation
- aggs (SQL group by)
- group_by_.. -> terms -> field ===
SELECT state, count(*) from bank GROUP BY state ORDER BY count(*) DESC - average_balance -> avg -> field
can be embeeddededdeed
