数据仓库服务 GaussDB(DWS)-做源表:语法格式

时间:2025-02-12 15:05:07

语法格式

用DWS-Connector做源表时,DWS-Connector实现了SupportsLimitPushDown和SupportsFilterPushDown接口,支持将limit和where条件下推到数据库执行。

 1 2 3 4 5 6 7 8 910111213
create table dwsSource (  attr_name attr_type   (',' attr_name attr_type)*   (','PRIMARY KEY (attr_name, ...) NOT ENFORCED)  (',' watermark for rowtime_column_name as watermark-strategy_expression))with (  'connector' = 'dws',  'url' = '',  'tableName' = '',  'username' = '',  'password' = '');
support.huaweicloud.com/tg-dws/dws_07_0183.html