数据仓库服务 GAUSSDB(DWS)-ALTER SERVER:示例

时间:2024-10-16 16:27:24

示例

建立一个hdfs_server,其中hdfs_fdw为数据库中存在的foreign data wrapper:

1
2
3
4
5
CREATE SERVER hdfs_server FOREIGN DATA WRAPPER HDFS_FDW OPTIONS 
   (address '10.10.0.100:25000,10.10.0.101:25000',
    hdfscfgpath '/opt/hadoop_client/HDFS/hadoop/etc/hadoop', 
    type 'HDFS'
) ;

修改现有名为hdfs_server的address:

1
ALTER SERVER hdfs_server OPTIONS ( SET address '10.10.0.110:25000,10.10.0.120:25000');

修改现有名为hdfs_server的hdfscfgpath:

1
ALTER SERVER hdfs_server OPTIONS ( SET hdfscfgpath '/opt/bigdata/hadoop');
support.huaweicloud.com/sqlreference-dws/dws_06_0138.html