Dremio supports a variety of data sources, including NoSQL databases, relational databases, Hadoop, local filesystems, and cloud storage.
Case-sensitive source data file/table names are not supported.
In Dremio, data filenames in your data source are "seen" in a case-insensitive manner. So, if you have to three (3) file names with difference cases (for example,
joe), Dremio "sees" the files as having the same name. Thus, searching on
joe, can result in unanticipated data results.
In addition, column names within a table that have the same name with different cases are not supported. For example, if two (2) columns named
trip_pickup_datetimeexist in the table, one of the columns may disappear when the header is extracted.
Files and Directories
As of Dremio 4.0, decimal-to-decimal mappings are supported for relational database sources.
Relational database sources must have a collation equivalent to
LATIN1_GENERAL_BIN2to ensure consistent results when operations are pushed down. For non-equivalent collations, create a view that coerces the collation to one that is equivalent to
LATIN1_GENERAL_BIN2and access that view.