Ask Your Question
1

What do the terms "hive table" and "delta table" refer to in Databricks?

asked 2023-05-17 03:47:41 +0000

nofretete gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
1

answered 2023-05-17 04:09:02 +0000

pufferfish gravatar image

"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.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer


Question Tools

Stats

Asked: 2023-05-17 03:47:41 +0000

Seen: 19 times

Last updated: May 17 '23