数据湖探索 DLI-修改表分区位置(只支持OBS表):示例

时间:2023-11-03 17:00:59

示例

将student表的分区dt='2008-08-08',city='xxx'的OBS路径设置为“obs://bucketName/fileName/student/dt=2008-08-08/city=xxx”

1
2
3
ALTER TABLE student
  PARTITION(dt='2008-08-08',city='xxx')
  SET LOCATION 'obs://bucketName/fileName/student/dt=2008-08-08/city=xxx';
support.huaweicloud.com/sqlref-spark-dli/dli_08_0084.html