Page History

...

Decimal also supports many arithmetic operators, mathematical UDFs and UDAFs with the same syntax as used in the case of DOUBLE.

...

• Positive
• Negative
• Addition
• Subtraction
• Multiplication
• Division
• Average (avg)
• Sum
• Count
• Modulus (pmod)
• Sign
• Exp
• Log (ln)
• Log2
• Log10
• Sqrt
• sin
• asin
• cos
• acos
• tan
• atan
• radians
• Sign – Hive 0.13.0 and later
• Exp – Hive 0.13.0 and later
• Ln – Hive 0.13.0 and later
• Log2 – Hive 0.13.0 and later
• Log10 – Hive 0.13.0 and later
• Log(base) – Hive 0.13.0 and later
• Sqrt – Hive 0.13.0 and later
• Sin – Hive 0.13.0 and later
• Asin – Hive 0.13.0 and later
• Cos – Hive 0.13.0 and later
• Acos – Hive 0.13.0 and later
• Tan – Hive 0.13.0 and later
• Atan – Hive 0.13.0 and later
• Radians – Hive 0.13.0 and later
• Degrees – Hive 0.13.0 and laterdegrees

These rounding functions can also take decimal types:

...