Data Sources

Dremio supports a variety of data sources, including NoSQL databases, relational databases, Hadoop, local filesystems, and cloud storage.

[warning] IMPORTANT

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 Joe, and joe), Dremio "sees" the files as having the same name. Thus, searching on Joe, JOE, or 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_DateTime and trip_pickup_datetime exist in the table, one of the columns may disappear when the header is extracted.

Files and Directories

Relational databases

[info] Decimal Support

As of Dremio 4.0, decimal-to-decimal mappings are supported for relational database sources.

Distributed Filesystems

NoSQL & Hadoop

results matching ""

    No results matching ""