Integer and numeric properties
Data Catalog object meta data properties that are defined as type:integer or type:numeric have these attributes in Compass:
- INFORMATION_SCHEMA.COLUMNS NUMERIC_PRECISION, NUMERIC_SCALE, and NUMERIC_RADIX.
- JDBC getColumns method includes the NUM_PREC_RADIX, DECIMAL_DIGITS, and COLUMN_SIZE.
- BigInt definitions over 23 digits in length are considered decimals.
- Compass has a maximum decimal size of decimal(38,15). Numeric definitions over decimal(38,15) are not supported.
- Numeric definitions without the multipleOf, maximum, and exclusiveMaximum attributes default to decimal(38,15).