Name |
Delta Lake |
Apache ORC |
Description |
Delta Lake is an open-source storage framework that enables building a Lakehouse architecture. |
ORC is a self-describing type-aware columnar file format designed for Hadoop workloads. |
License |
Apache license 2.0 |
Apache license 2.0 |
Source code |
https://github.com/delta-io/delta |
https://github.com/apache/orc |
Website |
https://delta.io/ |
https://orc.apache.org/ |
Year created |
2019 |
2013 |
Company |
Databricks |
Hortonworks, Facebook |
Language support |
scala, java, python, rust |
java, scala, c++, python |
Use cases |
Write once read many, Analytics, Efficient storage, ACID transactions |
Write once read many, Analytics, Efficient storage, ACID transactions |
Is human readable |
no
|
no
|
Orientation |
column |
row |
Has type system |
yes
|
yes
|
Has nested structure support |
yes
|
yes
|
Has native compression |
yes
|
yes
|
Has encoding support |
yes
|
yes
|
Has constraint support |
yes
|
no
|
Has acid support |
yes
|
no
|
Has metadata |
yes
|
yes
|
Has encryption support |
maybe
|
yes
|
Data processing framework support |
Apache Drill,
Apache Flink,
Apache Spark,
|
Apache Flink,
Apache Gobblin,
Apache Hadoop,
Apache NiFi,
Apache Pig,
Apache Spark,
|
Analytics query support |
Apache Hive,
AWS Athena,
Azure Synapse,
BigQuery,
Clickhouse,
Dremio,
Presto,
Trino,
|
Apache Impala,
Apache Druid,
Apache Hive,
Apache Pinot,
AWS Athena,
BigQuery,
Clickhouse,
Firebolt,
Presto,
Trino,
|