What's wrong with this SQL syntax in ES:
SELECT sum(net_value), sales_manager_name FROM "sales*"
It generates error:
Whoops! Expression failed
Expression failed with the message:
[essql] > Unexpected error from Elasticsearch: [verification_exception] Found 1 problem(s) line 1:45: Cannot use non-grouped column [sales_manager_name], expected
This is right SQL syntax.