Re: Decimal type, limitation on scale

Hi Zoltan, Ryan, Thanks for the quick replies! Responses inline below. > My biggest issue with the current decimal spec is that it does not encode the scale (uses the scale defined in the schema), as such it cannot accommodate a Oracle and Postgres NUMBER without scale coercion. This is exactly

Re: Decimal type, limitation on scale

It looks like the "scale must be less than precision" rule comes from Hive requirements[1] (although while searching, this is called into question elsewhere in Hive[2]). From the design document, the requirement was specifically to avoid variable (per-row scale): > For instance, applications (part

Re: Decimal type, limitation on scale

+dev adding the dev mailing list, maybe somebody there can answer the reasoning. when comparing sql server with Oracle and Postgress: https://docs.microsoft.com/en-us/sql/t-sql/data-types/decimal-and-numeric-transact-sql?view=sql-server-ver15