建表语句
CREATE TABLE dwd_app_package_site (
app varchar(32) NULL COMMENT “”,
siteid varchar(32) NULL COMMENT “”,
num BIGINT SUM DEFAULT “0” COMMENT “出现次数”
) ENGINE=OLAP
AGGREGATE KEY(app, siteid)
COMMENT “OLAP”
DISTRIBUTED BY HASH(app) BUCKETS 6
PROPERTIES (
“replication_num” = “3”,
“in_memory” = “false”,
“storage_format” = “DEFAULT”
);
创建查询视图报错
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) process failed.
org.apache.doris.common.DdlException: failed to init view stmt
at org.apache.doris.catalog.Catalog.createView(Catalog.java:5711) ~[starrocks-fe.jar:?]
at org.apache.doris.qe.DdlExecutor.execute(DdlExecutor.java:190) ~[starrocks-fe.jar:?]
at org.apache.doris.qe.StmtExecutor.handleDdlStmt(StmtExecutor.java:1139) ~[starrocks-fe.jar:?]
at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:411) ~[starrocks-fe.jar:?]
at org.apache.doris.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:241) ~[starrocks-fe.jar:?]
at org.apache.doris.qe.ConnectProcessor.dispatch(ConnectProcessor.java:390) ~[starrocks-fe.jar:?]
at org.apache.doris.qe.ConnectProcessor.processOnce(ConnectProcessor.java:626) ~[starrocks-fe.jar:?]
at org.apache.doris.mysql.nio.ReadListener.lambda$handleEvent$417(ReadListener.java:50) ~[starrocks-fe.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_271]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_271]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_271]
Caused by: org.apache.doris.common.UserException: Failed to parse view-definition statement of view: dwd_app_site_view
at org.apache.doris.catalog.View.init(View.java:165) ~[starrocks-fe.jar:?]
at org.apache.doris.catalog.Catalog.createView(Catalog.java:5709) ~[starrocks-fe.jar:?]
… 10 more