DROP [ MATERIALIZED ] VIEW [ IF EXISTS ] view_name 参数IF EXISTS 如果已指定,则当视图不存在时,不会引发 TABLE_OR_VIEW_NOT_FOUND 错误。 view_name 要删除的视图的名称。如果找不到视图,Azure Databricks 会引发 TABLE_OR_VIEW_NOT_FOUND 错误。示例...
DROP VIEW October 10, 2023 Applies to: Databricks SQL Databricks Runtime Removes the metadata associated with a specified view from the catalog. To drop a view you must be its owner, or the owner of the schema, catalog, or metastore the view resides in....
如果找不到表,Azure Databricks 会引发 TABLE_OR_VIEW_NOT_FOUND 错误。示例SQL 复制 -- Assumes a table named `employeetable` exists. > DROP TABLE employeetable; -- Assumes a table named `employeetable` exists in the `userdb` schema > DROP TABLE userdb.employeetable; -- Assumes a table ...
工作区本地组未同步到 Azure Databricks 帐户,并且与 Unity Catalog 不兼容。 有关详细信息,请参阅管理工作区本地组(旧版)。 语法 DROP GROUP group_principal 参数 group_principal 要删除的现有工作区本地组的名称。 示例 SQL复制 -- Create `aliens` Group>CREATEGROUPaliensWITHGROUPtv_aliens;-- Drop `ali...
CACHE (Delta Lake en Azure Databricks) CLONE (Delta Lake en Azure Databricks) CONVERT TO DELTA (Delta Lake en Azure Databricks) COPY INTO (Delta Lake en Azure Databricks) CREATE BLOOMFILTER INDEX (Delta Lake en Azure Databricks) DELETE FROM (Delta Lake en Azure Databricks) DESCRIBE HISTORY ...
override def dropTempView(viewName: String): Boolean = { sparkSession.sessionState.catalog.getTempView(viewName).exists { viewDef => sparkSession.sharedState.cacheManager.uncacheQuery( sparkSession, viewDef, cascade = false) try { val plan = sparkSession.sessionState.executePlan(viewDef) sparkSe...
如果找不到表,Azure Databricks 会引发 TABLE_OR_VIEW_NOT_FOUND 错误。示例SQL 复制 -- Assumes a table named `employeetable` exists. > DROP TABLE employeetable; -- Assumes a table named `employeetable` exists in the `userdb` schema > DROP TABLE userdb.employeetable; -- Assumes...
如果找不到视图,Azure Databricks 会引发 TABLE_OR_VIEW_NOT_FOUND 错误。示例SQL 复制 -- Assumes a view named `employeeView` exists. > DROP VIEW employeeView; -- Assumes a view named `employeeView` exists in the `usersc` schema > DROP VIEW usersc.employeeView; -- Assumes a view named ...
Databricks SQL Databricks Runtime 从目录中删除与指定视图关联的元数据。 若要删除某个视图,你必须是该视图的所有者,或者是该视图所在的架构、目录或元存储的所有者。 语法 DROP [ MATERIALIZED ] VIEW [ IF EXISTS ] view_name 参数 示例 SQL复制
Databricks SQL Databricks Runtime 從目錄中移除與指定檢視相關聯的中繼資料。 若要卸載檢視,您必須是檢視的擁有者,或架構、目錄或中繼存放區的擁有者。 語法 複製 DROP [ MATERIALIZED ] VIEW [ IF EXISTS ] view_name 參數 例子 SQL複製 -- Assumes a view named `employeeView` exists.>DROPVIEWemployeeV...