databricks - LIVE TABLE 和 STREAMING LIVE TABLE 的区别

Question

当使用 DLT 时，我们可以使用 STREAMING LIVE TABLE 或 LIVE TABLE 创建一个实时表，如文档中所写:

CREATE OR REFRESH { STREAMING LIVE TABLE | LIVE TABLE } table_name

这两种语法有什么区别？

Answer 1

它在 Concepts' page 上的文档中进行了描述.

A live table or view always reflects the results of the query that defines it, including when the query defining the table or view is updated, or an input data source is updated. Like a traditional materialized view, a live table or view may be entirely computed when possible to optimize computation resources and time.

A streaming live table or view processes data that has been added only since the last pipeline update. Streaming tables and views are stateful; if the defining query changes, new data will be processed based on the new query and existing data is not recomputed.