为了更快的定位您的问题，请提供以下信息，谢谢
【详述】用的表达式分区 overwrite指定分区是正常的 insert into会失败 3.3.6和3.2.7都可以复现
insert into scores_dt partition(dt = ‘2024-02-29’) select ‘2024-02-29’ as dt,id,name,subject,score from scores;–失败
insert into scores_dt select ‘2024-02-29’ as dt,id,name,subject,score from scores; --成功
insert overwrite scores_dt partition(dt = ‘2024-02-29’) select ‘2024-02-29’ as dt,id,name,subject,score from scores; – 成功
【背景】
【业务影响】
【是否存算分离】
【StarRocks版本】3.3.6和3.2.7
【集群规模】例如：3fe（1 follower+2observer）+5be（fe与be混部）
【机器信息】CPU虚拟核/内存/网卡，例如：48C/64G/万兆
【联系方式】为了在解决问题过程中能及时联系到您获取一些日志信息，请补充下您的联系方式，例如：社区群4-小李或者邮箱，谢谢
【附件】
- fe.log/beINFO/相应截图
报错信息
Caused by: com.starrocks.common.UserException: Required field ‘partitions’ was not present! Struct: TOlapTablePartitionParam(db_id:48146449, table_id:49661878, version:0, partitions:null, partition_columns:[dt], partition_exprs:[TExpr(nodes:[TExprNode(node_type:FUNCTION_CALL, type:TTypeDesc(types:[TTypeNode(type:SCALAR, scalar_type:TScalarType(type:DATETIME))]), num_children:2, output_scale:-1, fn:TFunction(name:TFunctionName(function_name:date_trunc), binary_type:BUILTIN, arg_types:[TTypeDesc(types:[TTypeNode(type:SCALAR, scalar_type:TScalarType(type:VARCHAR, len:-1))]), TTypeDesc(types:[TTypeNode(type:SCALAR, scalar_type:TScalarType(type:DATETIME))])], ret_type:TTypeDesc(types:[TTypeNode(type:SCALAR, scalar_type:TScalarType(type:DATETIME))]), has_var_args:false, scalar_fn:TScalarFunction(symbol:), id:50340, fid:50340, could_apply_dict_optimize:false, ignore_nulls:false, isolated:true), has_nullable_child:false, is_nullable:true, is_monotonic:false, is_index_only_filter:false), TExprNode(node_type:STRING_LITERAL, type:TTypeDesc(types:[TTypeNode(type:SCALAR, scalar_type:TScalarType(type:VARCHAR, len:-1))]), num_children:0, string_literal:TStringLiteral(value:day), output_scale:-1, has_nullable_child:false, is_nullable:false, is_monotonic:true, is_index_only_filter:false), TExprNode(node_type:SLOT_REF, type:TTypeDesc(types:[TTypeNode(type:SCALAR, scalar_type:TScalarType(type:DATETIME))]), num_children:0, slot_ref:TSlotRef(slot_id:0, tuple_id:2), output_scale:-1, output_column:-1, has_nullable_child:false, is_nullable:false, is_monotonic:true, is_index_only_filter:false)])], enable_automatic_partition:false) backend [id=10004] [host=cube-env-test01-data]
at com.starrocks.qe.DefaultCoordinator.handleErrorExecution(DefaultCoordinator.java:656) ~[starrocks-fe.jar:?]
at com.starrocks.qe.scheduler.Deployer.waitForDeploymentCompletion(Deployer.java:250) ~[starrocks-fe.jar:?]
at com.starrocks.qe.scheduler.Deployer.deployFragments(Deployer.java:121) ~[starrocks-fe.jar:?]
at com.starrocks.qe.scheduler.dag.AllAtOnceExecutionSchedule.schedule(AllAtOnceExecutionSchedule.java:40) ~[starrocks-fe.jar:?]
at com.starrocks.qe.DefaultCoordinator.deliverExecFragments(DefaultCoordinator.java:637) ~[starrocks-fe.jar:?]
at com.starrocks.qe.DefaultCoordinator.startScheduling(DefaultCoordinator.java:535) ~[starrocks-fe.jar:?]
at com.starrocks.qe.scheduler.Coordinator.startScheduling(Coordinator.java:113) ~[starrocks-fe.jar:?]
at com.starrocks.qe.scheduler.Coordinator.exec(Coordinator.java:92) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.handleDMLStmt(StmtExecutor.java:2240) ~[starrocks-fe.jar:?]
… 9 more
建表语句
CREATE TABLE scores_dt (
dt datetime NOT NULL COMMENT “日分区”,
id int(11) NOT NULL COMMENT “”,
name varchar(11) NOT NULL COMMENT “”,
subject varchar(11) NULL COMMENT “”,
score int(11) NULL COMMENT “”
) ENGINE=OLAP
PRIMARY KEY(dt,id,name)
PARTITION BY date_trunc(‘day’, dt)
PROPERTIES (
“compression” = “LZ4”,
“fast_schema_evolution” = “false”,
“replicated_storage” = “true”,
“replication_num” = “1”
);
- 慢查询：
- Profile信息
- 并行度：show variables like ‘%parallel_fragment_exec_instance_num%’;
- pipeline是否开启：show variables like ‘%pipeline%’;
- be节点cpu和内存使用率截图
- 查询报错：
- query_dump，怎么获取query_dump文件
- be crash
- be.out
- 外表查询报错
- be.out和fe.warn.log