When you migrate workloads to Delta Lake, you should be aware of the following simplifications and differences compared with the data sources provided by Apache Spark and Apache Hive.
Delta Lake handles the following operations automatically, which you should never perform manually:
- Load a single partition
- As an optimization, you may sometimes directly load the partition of data you are interested in. For example,
spark.read.parquet("/data/date=2017-01-01"). This is unnecessary with Delta Lake, since it can quickly scan the list of files to find the list of relevant ones. If you are interested in a single partition, specify it using a
WHEREclause. For example,
spark.read.delta("/data").where("date = '2017-01-01'").
When you port an existing application to Delta Lake, you should avoid the following operations, which bypass the transaction log:
- Manually modify data
- Delta Lake uses the transaction log to atomically commit changes to the table. Because the log is the source of truth, files that are written out but not added to the transaction log are not read by Spark. Similarly, even if you manually delete a file, a pointer to the file is still present in the transaction log.
- External readers
- The data stored in Delta Lake is encoded as Parquet files. However, accessing these files using an external reader is not safe.