Hive Serde table vs Delta table
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-15-2021 04:47 AM
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'
Labels:
- Labels:
-
Hive Table
-
Table