Why Crate Sql is slower than elasticsearch http API

I am testing the crateDB performance.
There are 78164052 docs in CrateDB on 1 node server.

select “year”,count(hotel_code) as count from f_and_b group by “year” limit 100;
will take SELECT OK, 18 rows in set (6.020 sec)

but when I query same data from es api in the same crateDB:

“size”: 0,
“aggs”: {
“group_by_year”: {
“terms”: {
“field”: “year”
will response