Elastic Search adapter not identifying columns
I am trying to use calcite elasticsearch adapter via sqlline. I am
successfully able to connect to elastic search and able to run
*select * from zips.*
However I am not able to get specific fields in sql such has
*select "id" from "zips";*
It gives following error
*Error: Error while executing SQL "select "id" from "zips"": From line 1,
column 8 to line 1, column 11: Column 'id' not found in any table
Similarly the columns are not identified in *where* condition. I see that
its returning only one column as *_MAPS *and whole json document as one row.
Does adapter not support columns for elasticsearch?