CREATE VIEW 创建失败 版本1.18.4

[jingdan]

@U_1637133352178_7951

CREATE VIEW dwd_app_package_site(app, site) as
select S.app, S.siteid
from dwd_app_package_site S
join (select siteid, max(num) num from dwd_app_package_site group by siteid) A
on S.siteid=A.siteid and S.num>=A.num)

咱们现在使用的版本是？
可以这样试试嘛
CREATE VIEW dwd_app_package_site as
select S.app as app, S.siteid as site
from dwd_app_package_site S
join (select siteid, max(num) num from dwd_app_package_site group by siteid) A
on S.siteid=A.siteid and S.num>=A.num)