Presto 0.127t Documentation

13.2. Decimal data type limitations

13.2. Decimal data type limitations

  1. Currently only basic arithmetic operators and inequality operators are supported.
  2. Automatic coercions are only supported between DECIMAL types (where possible). Other supported casts must be specified explicitly by the user is SQL.
  3. Performance of decimal types longer than 17 digits may be not satisfactory.
  4. INSERT flow is not supported for DECIMAL columns.
  5. Currently only Hive connector supports exposing DECIMAL columns.