"Hive table" refers to a table that is stored in the Hive metastore, which is a centralized repository of metadata that provides information about the data stored in Hadoop Distributed File System (HDFS). Hive tables can be used with HiveQL, SQL-like query language, to query data stored in HDFS.
"Delta table" refers to a table that is stored in Delta Lake, an open-source storage layer that provides ACID transactions, data versioning, and schema enforcement for data lakes. Delta tables are used to manage large amounts of data and ensure data integrity, consistency, and reliability. They support features such as time travel, which allows users to query and restore a table to any point in time.
Asked: 2023-05-17 03:47:41 +0000
Seen: 19 times
Last updated: May 17 '23