The Elasticsearch Adapter of the current master branch has some problems when querying for group by clause without aggregation function. For example, when I query the following SQL:
After translation, adapter should return the following JSON:
But it returns the following JSON now:
The reason for this problem is that there is a missing condition for judging the aggregation query.
In addition, there is the other associated problem. After building aggregation JSON, the code of current version will remove empty aggregation block in ElasticsearchTable class, the code just like this:
But if input the JSON like above, this code will not work out.