I am trying to get min value of an attribute using SQL api. My query looks like this
SELECT MIN(attr1) as min_val from index_name
However, in the output, the value is getting converted to scientific value and is loosing precision. Its showing value as 1.0E18.
Is there any way to retain the value as is? I tried using both variants of CONVERT/CAST on top of MIN. I am getting input mismatch, input '(' expecting ')'.
I am on ES7.2.0 default installation using Windows MSI.