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).