本页尚未翻译

本页内容仍为英文原文，源自官方文档 sql/dml/refresh-materialized-view。中文翻译正在分批进行中。

REFRESH MATERIALIZED VIEW

Bringing a materialized view's stored result up to date.

Applies to: Embedded ❌, Enterprise ✅

A LanceDB extension with no DataFusion equivalent.

REFRESH MATERIALIZED VIEW <name>
  [WITH (full = <boolean>)]

REFRESH MATERIALIZED VIEW chunks
REFRESH MATERIALIZED VIEW chunks WITH (full = true)

A refresh updates the view's stored result. Refresh views in dependency order, starting with their source views. full = true forces a complete rebuild even when the sources are unchanged; the default, false, refreshes incrementally when supported and rebuilds otherwise.

说明

CASCADE is not accepted by the SQL implementation described here, regardless of what a local SDK's refresh() method accepts -- do not assume the two option sets match.

Watching a refresh

A refresh submits work that outlives the call. Track it with SHOW JOBS, and diagnose failures with SHOW ERRORS. For per-split progress, worker fleet detail, and a DESCRIBE JOB example, see Watching a refresh.

See also

Materialized ViewCreating the view this refreshes.Refresh a materialized viewThe same operation from the SDKs, and automatic refresh.REFRESH COLUMNFilling a computed column, instead of a view.