Hive Serde table vs Delta table

herry
New Contributor III

This might be stupid question. Does the Hive Serde table have the same features (e.g. transactions) comparing to the Delta table?

I tried to find the information in the Databricks documentation but I cannot find a clear answer.

I create the Hive Serde table using this SQL statement

CREATE EXTERNAL TABLE mydb.mytable (col1 string, col2 boolean)
ROW FORMAT serde 'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.SymlinkTextInputFormat'
OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
LOCATION 's3://path/to/table/';

and I create the Delta table

CREATE mydb.mytable
  (col1 string, col2 boolean)
  USING DELTA
  LOCATION 's3://path/to/table'