Peng Huo

@michelle-q , 因为NLPchina不再维护了, 可以参考我们的解决方案。 https://github.com/opendistro-for-elasticsearch/sql/pull/278 我们提供了不同的分发包，你可以直接下载：https://opendistro.github.io/for-elasticsearch/downloads.html 和 https://opendistro.github.io/for-elasticsearch-docs/docs/install/plugins/#sql 再有问题欢迎给我们开Issue。

## Root Cause Elasticsearch support ingest [geo-point](https://www.elastic.co/guide/en/elasticsearch/reference/current/geo-point.html) in five ways. Currently, the query engine use [Source filtering](https://www.elastic.co/guide/en/elasticsearch/reference/7.11/search-fields.html#source-filtering) to retrieve the field value, the [parser](https://github.com/opendistro-for-elasticsearch/sql/blob/develop/elasticsearch/src/main/java/com/amazon/opendistroforelasticsearch/sql/elasticsearch/data/utils/ElasticsearchJsonContent.java#L112) can only parse the numeric value....

Thanks for reporting the issue. Could you share the raw docs for debuing the issue? 1. Using the explain api to get the Elasticsearch DSL. ``` POST _opendistro/_sql/_explain { "query":...

Thanks for the info, looking at the issue now.

In ODFE 1.11.0, we add the DateFieldFormatter to format the result as JDBC required `yyyy-MM-dd HH:mm:ss.SSS`. But unfortunatelly, there is a [bug](https://github.com/opendistro-for-elasticsearch/sql/blob/develop/legacy/src/main/java/com/amazon/opendistroforelasticsearch/sql/legacy/executor/format/DateFieldFormatter.java#L93) which only format the first raw and exist....

@davide-malagoli , does the topic in here help https://discuss.opendistrocommunity.dev/t/opendistro-sql-jdbc-driver/2265 Have u try to include the username and password?

+1 ## Query ``` SELECT NotExistName, MAX(FlightDelayMin) FROM kibana_sample_data_flights GROUP BY DestCityName ``` ## Result in sql-kibana is unexpected ``` Kibana_sample_data_flights group: no response ``` ## Result in devtools is...

Are you trying to build plugin only? If so, you could use `./gradlew plugin:build` which will build plugin without run test. Which branch you run test against? Have you considered...

Thanks for reaching out. Could you give some example that how to use SQL to read docvalue?

Currently, no plan. Any specific feature you are thinking of?