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 machine that it output the average column like 0.0.
Can someone help me to get the correct settings?
vbox picture like below:
redhat machine1 like below:
I have two redhat machine, and one works normally.
redhat machine2 like below: