The isuse for sql on ES

1

SELECT min(date_0), max(date_0), (min(date_0)+(300000000000)), (min(date_0)+(3000*100000000)) , (max(date_0) - min(date_0))/3000

the 3000 * 100000000 's result is ERROR

2

Thank you for pointing this out. Nothing to do with ES BTW.
Could you try following?:

Change to:

3000*CAST(100000000 AS BIGINT)

3

I mean, dremio can automatically convert types?

4

Hi @JoyJava

When you say convert data types, yes just to reformat results on the UI and yes we can save a converted result set as a virtual data set.

Type Conversion

Kindly let us know if any additional questions,

Thanks,
@balaji.ramaswamy