【详述】问题详细描述
drop table if exists m_prv_vdm_stream_tenant_node_hh_1;
create table if not exists m_prv_vdm_stream_tenant_node_hh_1
(
id bigint ,
gmt_create string,
gmt_modified string,
node_id string,
tenant_id string,
project_id string,
ds date
)
partition by date_trunc(‘day’,ds)
(
)
distributed by hash(id)
properties(
“partition_live_number” = “3”
);
select * from emr_dataphin_meta.m_prv_vdm_stream_tenant_node_hh_1
insert overwrite m_prv_vdm_stream_tenant_node_hh_1 partition (p20230701)
select 1 as id,‘2023-07-01 12:00:00’ as gmt_create, ‘2023-07-01 12:00:00’ as gmt_modified, ‘n_1234554321’ as node_id, ‘300000806’ as tenant_id, ‘398720547276’ as project_id, 20230701 as ds;
报错如下：
【背景】
需要使用自动创建分区+insert overwrite功能
【业务影响】
影响产品对接StarRocks
【StarRocks版本】3.0.3
