数据仓库服务 GAUSSDB(DWS)-DML(Netezza):GaussDB(DWS)关键字:SOURCE指定为无AS关键字的列别名

时间:2024-10-26 11:41:17

GaussDB (DWS)关键字:SOURCE指定为无AS关键字的列别名

Netezza语法

迁移后语法

1
2
3
4
SELECT SUBSTR( OP_SOURCE ,1 ,4 ) SOURCE
     , ONLINE_FLAG, 'TRD' AS SRC_SYS
     , CURRENT_TIMESTAMP AS ETL_LOAD_TIME
  FROM tb_keyword_source;
1
2
3
4
SELECT SUBSTR( OP_SOURCE ,1 ,4 ) AS SOURCE
     , ONLINE_FLAG, 'TRD' AS SRC_SYS
     , CURRENT_TIMESTAMP AS ETL_LOAD_TIME
  FROM tb_keyword_source;
support.huaweicloud.com/tg-dws/dws_07_6826.html