Skip to main content
Version: current

Decimal Support

Dremio supports decimal to decimal mappings for external sources. That is, when connecting a new external source, the default is to map decimal to decimal.

SourceDecimal Support
Relational databases: See Data Type Mappings for External Sources for the current list of supported databases.Decimal-to-decimal
Parquet (AWS Glue), Hive (Parquet/ORC)Decimal data types
Text (CSV), JSON filesCast strings and integers to decimals with decimal precision and scale.

Mixed Decimal Types​

Reviewers:

Verify whether the following statement is true. Based on Cloud docs, but need to verify this is the case for Hive datasets. Current posted sw doc states ORC does not support mixed decimal types: https://docs.dremio.com/software/sql-reference/data-types/#mixed-decimal-types

Dremio supports mixed decimal types for AWS Glue and Hive datasets that are either in Parquet files or Optimized Row Columnar (ORC) files.

{{% snippet "data-types/data-types-mixed-decimal-snippet.md" %}}

Limitations​

{{% snippet "data-types/data-types-decimal-limitations-snippet.md" %}}