search

opendistro-for-elasticsearch / sql

🔍 Open Distro SQL Plugin
https://opendistro.github.io/for-elasticsearch/features/SQL%20Support.html
Apache License 2.0
620 stars 186 forks source link

Kibana cannot display the response data when "opendistro.sql.query.response.format" is set json #1098

Open STTianXiang opened 3 years ago

STTianXiang commented 3 years ago

Hi， environment： server opendistro 1.13.2

opendistro Sql settings：

PUT /_opendistro/_sql/settings { "transient" : { "opendistro.sql.enabled" : "true", "opendistro.sql.query.response.format":"json", "opendistro.sql.cursor.enabled": "true", "opendistro.sql.cursor.fetch_size" : "5000", "opendistro.sql.cursor.keep_alive" : "5m", "opendistro.sql.engine.new.enabled": "true", "opendistro.sql.query.slowlog": "20", "opendistro.sql.query.analysis.semantic.suggestion": "true" } }

I query through kibana Query Workbench, and the query data can be returned normally, but it cannot be displayed normally, and an error occurs in the Chrome Console.

like this image

chloe-zh commented 3 years ago

Hi @STTianXiang thank you for reporting this issue! The workbench is generating the result table from the JDBC formatted result set from the SQL plugin, that explains why it does not work with your current config since the response format has been set to Json rather than JDBC. That should be working if you update the config of response format to "jdbc". Please let us know if any further question or issue coming up, thanks!

STTianXiang commented 3 years ago

Hi @STTianXiang thank you for reporting this issue! The workbench is generating the result table from the JDBC formatted result set from the SQL plugin, that explains why it does not work with your current config since the response format has been set to Json rather than JDBC. That should be working if you update the config of response format to "jdbc". Please let us know if any further question or issue coming up, thanks!

Hi chole-zh thank you for answer. I have modified the current configuration（jdbc）, but I may use json format in other places, so this is not universal, I hope that it will be compatible with other format response in the future.

dai-chen commented 3 years ago

Hi @STTianXiang thank you for reporting this issue! The workbench is generating the result table from the JDBC formatted result set from the SQL plugin, that explains why it does not work with your current config since the response format has been set to Json rather than JDBC. That should be working if you update the config of response format to "jdbc". Please let us know if any further question or issue coming up, thanks!

Hi chole-zh thank you for answer. I have modified the current configuration（jdbc）, but I may use json format in other places, so this is not universal, I hope that it will be compatible with other format response in the future.

Hi @STTianXiang , you can make default format JDBC so Workbench can work. When you need JSON response, you can pass HTTP param format=json with your query. Thanks!