Hi, 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 (state=,code=0)* 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? -- Regards Shashwat Kumar
