Essql

does ESSQL support this syntax like(select c1,c2,count(*) from index1 group by c1,c2)in elasticsearch6.3

In 6.3, only a single GROUP BY can be used. That limitation has been addressed though and should be released soon.