ACID Table Features Engine MatrixΒΆ
The following table provides a matrix of ACID features on Hive, Presto, and Spark engines.
ACID Features | Hive | Presto | Spark |
---|---|---|---|
Operations | INSERT , UPDATE , SELECT
INSERT OVERWRITE , DELETE ,
and MERGE . |
Read-only support (SELECT ) |
INSERT , INSERT OVERWRITE ,
UPDATE , SELECT and
DELETE . |
Insert-only Table | All file formats | All file formats | All file formats |
Full ACID Table | Only the ORC format |
Only the ORC format |
Only the ORC format |
Compaction | Yes | No | No |
Streaming Data ** Ingestion APIs | Yes | No | No |
** For more information, see Streaming Data Ingestion API.
Note
Insert-only tables support file formats such as TextFile
, SequenceFile
, RCfile
, ORC
, and parquet
.
The default file format of Hive-managed tables in Qubole is TextFile
, which is also the default format for Insert-only tables.