You can create tables with a Decimal datatype when:
- creating a new schema using 5.8.06, the datatype with precision and scale variable will have a logicalType of decimal.
- using the same model from 5.8.05 version in 5.8.06, attributes with Float data type will still be treated as FLOAT supporting backward compatibility (WITHOUT REFRESH).
Compatibility settings
If the user wants to refresh the schema to use the decimal data type in Avro, the compatibility mode for schema should be changed to NONE before using refresh to upgrade the model from 5.8.05 to 5.8.06. The default is BACKWARD.
If the mode is not changed, and the user tries to REFRESH the schema, the update fails with a pop-up error in the Director indicating the mode should be changed.