Apache Presto - Decimal Operator


Query 1

presto:default> select decimal '123' + decimal ’22’ as decimal; 

Result

 decimal 
------- 
  145 

The output is decimal addition.

Query 2

presto:default> select decimal '123' - decimal ’22’ as unary_minus;

Result

 unary_minus 
------- 
  101

Query 3

presto:default> select decimal '123' between decimal '100' and 
decimal '200' as decimal_range; 

Result

decimal_range 
--------------- 
   true

Here, 123 lies between the specified range.

apache_presto_basic_sql_operations.htm
Advertisements