Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[array low cardinality] alter table error in aggregate table #45532

Open
wangruin opened this issue May 13, 2024 · 0 comments
Open

[array low cardinality] alter table error in aggregate table #45532

wangruin opened this issue May 13, 2024 · 0 comments
Assignees
Labels
type/bug Something isn't working

Comments

@wangruin
Copy link
Contributor

Steps to reproduce the behavior (Required)

mysql>  CREATE TABLE `array_low_cardinality_aggregate` ( `c1` date NULL COMMENT "", `c2` int(11) NULL COMMENT "", `c3` int(11) NULL COMMENT "", `c4` varchar(20) NULL COMMENT "", `c5` varchar(20) NULL COMMENT "", `c6` array<date> replace NULL COMMENT "", `c7` array<int(11)> replace NULL COMMENT "", `c8` array<int(11)> replace NULL COMMENT "", `c9` array<varchar(20)> replace NULL COMMENT "", `c10` array<varchar(20)> replace NULL COMMENT "", `c11` array<varchar(20)> replace NULL COMMENT "", `c12` array<array<varchar(20)>> replace NULL COMMENT "" ) ENGINE=OLAP aggregate KEY(`c1`, `c2`, `c3`, `c4`, `c5`) PARTITION BY RANGE(`c1`) (PARTITION p1 VALUES [("0000-01-01"), ("1993-01-01")), PARTITION p2 VALUES [("1993-01-01"), ("1994-01-01")), PARTITION p3 VALUES [("1994-01-01"), ("1995-01-01")), PARTITION p4 VALUES [("1995-01-01"), ("1996-01-01")), PARTITION p5 VALUES [("1996-01-01"), ("1997-01-01")), PARTITION p6 VALUES [("1997-01-01"), ("1998-01-01")), PARTITION p7 VALUES [("1998-01-01"), ("1999-01-01"))) DISTRIBUTED BY HASH(`c1`) BUCKETS 48 PROPERTIES ("replication_num" = "3");
Query OK, 0 rows affected (0.24 sec)

mysql> alter table array_low_cardinality_aggregate MODIFY COLUMN c10 array<varchar(20)> AFTER c5;
ERROR 1064 (HY000): Unexpected exception: null

Expected behavior (Required)

alter table success

Real behavior (Required)

ERROR 1064 (HY000): Unexpected exception: null

2024-05-13 15:32:58.754+08:00 WARN (thrift-server-pool-78|244) [StmtExecutor.handleDdlStmt():1607] DDL statement (alter table array_low_cardinality_aggregate MODIFY COLUMN c10 array<varc
har(20)> AFTER c5) process failed.
java.lang.IllegalArgumentException: null
        at com.google.common.base.Preconditions.checkArgument(Preconditions.java:129) ~[spark-dpp-1.0.0.jar:?]
        at com.starrocks.alter.SchemaChangeHandler.processModifyColumn(SchemaChangeHandler.java:434) ~[starrocks-fe.jar:?]
        at com.starrocks.alter.SchemaChangeHandler.analyzeAndCreateJob(SchemaChangeHandler.java:1650) ~[starrocks-fe.jar:?]
        at com.starrocks.alter.SchemaChangeHandler.process(SchemaChangeHandler.java:1764) ~[starrocks-fe.jar:?]
        at com.starrocks.alter.AlterJobMgr.processAlterTable(AlterJobMgr.java:565) ~[starrocks-fe.jar:?]
        at com.starrocks.server.LocalMetastore.alterTable(LocalMetastore.java:3062) ~[starrocks-fe.jar:?]
        at com.starrocks.server.MetadataMgr.alterTable(MetadataMgr.java:313) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.DDLStmtExecutor$StmtExecutorVisitor.lambda$visitAlterTableStatement$13(DDLStmtExecutor.java:355) ~[starrocks-fe.jar:?]
        at com.starrocks.common.ErrorReport.wrapWithRuntimeException(ErrorReport.java:108) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.DDLStmtExecutor$StmtExecutorVisitor.visitAlterTableStatement(DDLStmtExecutor.java:354) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.DDLStmtExecutor$StmtExecutorVisitor.visitAlterTableStatement(DDLStmtExecutor.java:180) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.ast.AlterTableStmt.accept(AlterTableStmt.java:64) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.ast.AstVisitor.visit(AstVisitor.java:70) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.DDLStmtExecutor.execute(DDLStmtExecutor.java:166) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.StmtExecutor.handleDdlStmt(StmtExecutor.java:1577) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.StmtExecutor.execute(StmtExecutor.java:642) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.ConnectProcessor.proxyExecute(ConnectProcessor.java:850) ~[starrocks-fe.jar:?]
        at com.starrocks.service.FrontendServiceImpl.forward(FrontendServiceImpl.java:1154) ~[starrocks-fe.jar:?]
        at com.starrocks.thrift.FrontendService$Processor$forward.getResult(FrontendService.java:4276) ~[starrocks-fe.jar:?]
        at com.starrocks.thrift.FrontendService$Processor$forward.getResult(FrontendService.java:4256) ~[starrocks-fe.jar:?]
        at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:38) ~[libthrift-0.13.0.jar:0.13.0]
        at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:38) ~[libthrift-0.13.0.jar:0.13.0]
        at com.starrocks.common.SRTThreadPoolServer$WorkerProcess.run(SRTThreadPoolServer.java:311) ~[starrocks-fe.jar:?]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) ~[?:?]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) ~[?:?]
        at java.lang.Thread.run(Thread.java:829) ~[?:?]

StarRocks version (Required)

  • You can get the StarRocks version by executing SQL select current_version()
    branch-3.3-0e79074
@wangruin wangruin added the type/bug Something isn't working label May 13, 2024
@wyb wyb assigned wyb and unassigned Seaven May 13, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/bug Something isn't working
Projects
None yet
Development

No branches or pull requests

3 participants