I am using elastic 6.4, and using /_xpack/sql to output some columns. Due to use order by command, have to average number columns that output just have 1 decimal place. In my case, I use my local vbox with ubuntu 18.04 and elasticsearch sql can output many decimal place, but I using the redhat mac…

Want to elasticsearch sql select the decimal column output more decimal place

zxc654951 November 28, 2018, 2:34am 2

Hello. Does my environment of elasticsearch set wrong?

Update:
Using es query and output result didn't have decimal
And another redhat machine has same problem in this morning.

Topic		Replies	Views
Doing math with fields values does not show decimals Elasticsearch elastic-stack-sql	3	483	March 20, 2019
JDBC River decimal problem Elasticsearch	2	361	July 6, 2017
ElasticSearch automatically skips decimals in floating numbers Elasticsearch	4	457	September 9, 2020
Elasticsearch returns different values from DSL and SQL query Elasticsearch elastic-stack-sql	10	1581	February 8, 2021
Elasticsearch logstash JDBC giving exception for data type casting float to long and long to float Elasticsearch	2	768	July 16, 2018