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
+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
Hi all,
I've been trying to do some research on the logical decimal type and why
the scale of a decimal type must be between zero and the precision of the
type, inclusive. The ticket https://issues.apache.org/jira/browse/AVRO-1402 has
a lot of discussion around the design of the type, but I