Multiple Group by errors

[vitaneyeyu]

sql like : select count(id) from A where A.id > 5 group by A.a, A.b;
because of
innerMap["terms"] = msi{ "field": colName.Name.String(), "size": 0, }
will gen the dsl like: "terms":{"field":"field2","size":0}
and then make a error: "reason":"[size] must be greater than 0
using es7.X

[cch123]

Sorry for the late reply

Does changing the SQL to 'select count(id) from A where A.id > 5 group by A.a, A.b limit 100' solves the problem?

[vitaneyeyu]

I tried it and it still didn't work

[cch123]

you can consider this change by one of this lib's user, I dont know whether this is a common fix

https://github.com/amitvijayant/elasticsql