doris 2.1.5 create as select报错

Viewed 77

建表语句

create table szmssq_dwd.dwd_order_t2 PROPERTIES("replication_num" = "1") as SELECT order_id, punish_object FROM ( SELECT order_id, FIRST_VALUE( assess_result_cd ) OVER ( PARTITION BY order_id ORDER BY data_date DESC ) AS assess_result_cd, FIRST_VALUE( punish_object ) OVER ( PARTITION BY order_id ORDER BY data_date DESC ) AS punish_object, FIRST_VALUE( state ) OVER ( PARTITION BY order_id ORDER BY data_date DESC ) AS state FROM tidb_ca_exec.szmssq_ads.ads_szmssq_fact_order_assess_sync WHERE assess_result_cd = '0' AND state <> 'SX' ) t GROUP BY order_id, punish_object;

fe报错信息

java.lang.NullPointerException: null
        at org.apache.doris.datasource.InternalCatalog.createTableAsSelect(InternalCatalog.java:1268) ~[doris-fe.jar:1.2-SNAPSHOT]
        at org.apache.doris.catalog.Env.createTableAsSelect(Env.java:3136) ~[doris-fe.jar:1.2-SNAPSHOT]
        at org.apache.doris.qe.DdlExecutor.execute(DdlExecutor.java:163) ~[doris-fe.jar:1.2-SNAPSHOT]
        at org.apache.doris.qe.StmtExecutor.handleCtasStmt(StmtExecutor.java:2774) ~[doris-fe.jar:1.2-SNAPSHOT]
        at org.apache.doris.qe.StmtExecutor.executeByLegacy(StmtExecutor.java:910) ~[doris-fe.jar:1.2-SNAPSHOT]
        at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:591) ~[doris-fe.jar:1.2-SNAPSHOT]
        at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:517) ~[doris-fe.jar:1.2-SNAPSHOT]
        at org.apache.doris.qe.ConnectProcessor.executeQuery(ConnectProcessor.java:328) ~[doris-fe.jar:1.2-SNAPSHOT]
        at org.apache.doris.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:206) ~[doris-fe.jar:1.2-SNAPSHOT]
        at org.apache.doris.qe.MysqlConnectProcessor.handleQuery(MysqlConnectProcessor.java:260) ~[doris-fe.jar:1.2-SNAPSHOT]
        at org.apache.doris.qe.MysqlConnectProcessor.dispatch(MysqlConnectProcessor.java:288) ~[doris-fe.jar:1.2-SNAPSHOT]
        at org.apache.doris.qe.MysqlConnectProcessor.processOnce(MysqlConnectProcessor.java:341) ~[doris-fe.jar:1.2-SNAPSHOT]
        at org.apache.doris.mysql.ReadListener.lambda$handleEvent$0(ReadListener.java:52) ~[doris-fe.jar:1.2-SNAPSHOT]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_311]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_311]
        at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_311]

2.1.3版本的时候没问题,升级到2.1.5后报错

1 Answers

老师,您方便的话,加下我主页微信,可能需要取下case 复现下了