MATERIALIZATION

在Aloudata AIR中，一个PROJECTION PROJECTION下面可能会包含一个或多个MATERIALIZATION；

DROP MATERIALIZATION INSTANCE

删除物化实例

• 语法说明

INTERNAL DROP MATERIALIZATION <materializationPath>

• 使用示例

interal drop materialization "default"."materialization"."path";

ALTER MATERIALIZATION

DROP MATERIALIZATION PARTITION

删除分区

• 语法说明

[ INTERNAL ] ALTER MATERIALIZATION <tableName> DROP [IF EXISTS] PARTITION <pt_spec> [, PARTITION <pt_spec> ...]

• 参数说明

• 使用示例

internal alter meterialization
  "default_catalog"."aloudata_project"."c83_xxx" 
drop if exists 
  partition (sale_date = '202307', region='hangzhou'),
  partition(sale_date='202312', region='shanghai');