[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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?

Shashwat Kumar