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.