【详述】创建内表，然后insert外表查询数据，验证insert数据是否与外表数据一致
DROP TABLE IF EXISTS t_client_info;
CREATE TABLE IF NOT EXISTS t_client_info (
client_id varchar(255),
client_name BIGINT(20),
short_name varchar(255),
master_client_id INT(11),
master_client_name varchar(255),
yh_channel_id char(5),
yh_channel_name varchar(20),
channel_id varchar(255),
channel_name varchar(255),
channel_feature varchar(255),
cooperate_mode varchar(255),
cooperate_start_time DATETIME,
cooperate_end_time DATETIME,
account_limit INT(11),
client_discount SMALLINT(6),
is_salecenter_client TINYINT(1),
is_important_client TINYINT(1),
is_online TINYINT(1),
level char(1),
settlement_type varchar(4),
settlement_type_code TINYINT(4),
client_type varchar(1),
province_id BIGINT(20),
province_name varchar(255),
city_id char(4),
city_name varchar(255),
manager_id INT(11),
manager_real_name varchar(255),
manager_org_id INT(11),
manager_org2_id INT(11),
manager_org3_id INT(11),
manager_org4_id INT(11),
sale_center_org_id varchar(255),
area_id varchar(255),
area_name varchar(255),
area_manager_id BIGINT(20),
area_manager_real_name varchar(255),
area_org1_id BIGINT(20),
area_org1_name varchar(255),
area_org1_manager_id INT(11),
area_org1_manager_real_name varchar(255),
area_org2_id BIGINT(20),
area_org2_name varchar(255),
area_org2_manager_id INT(11),
area_org2_manager_real_name varchar(255),
area_org3_id BIGINT(20),
area_org3_name varchar(255),
area_org3_manager_id INT(11),
area_org3_manager_real_name varchar(255),
client_org_id INT(11),
client_org_name varchar(255),
client_org_manager_id varchar(1048576),
client_org_manager_real_name varchar(255),
other_operator_ids varchar(1048576),
other_operator_real_names varchar(1048576),
client_is_delete TINYINT(1),
client_create_time DATETIME,
client_update_time DATETIME,
offline_province varchar(255),
convert_month INT(11),
convert_from_code varchar(255),
convert_from varchar(255)
)
PRIMARY KEY (client_id )
DISTRIBUTED BY HASH (client_id )
PROPERTIES (
“replication_num”=“1”
)
insert into t_client_info
SELECT client_id, client_name, short_name, master_client_id, master_client_name, yh_channel_id, yh_channel_name, channel_id, channel_name, channel_feature, cooperate_mode, cooperate_start_time, cooperate_end_time, account_limit, client_discount, is_salecenter_client, is_important_client, is_online, level, settlement_type, settlement_type_code, client_type, province_id, province_name, city_id, city_name, manager_id, manager_real_name, manager_org_id, manager_org2_id, manager_org3_id, manager_org4_id, sale_center_org_id, area_id, area_name, area_manager_id, area_manager_real_name, area_org1_id, area_org1_name, area_org1_manager_id, area_org1_manager_real_name, area_org2_id, area_org2_name, area_org2_manager_id, area_org2_manager_real_name, area_org3_id, area_org3_name, area_org3_manager_id, area_org3_manager_real_name, client_org_id, client_org_name, client_org_manager_id, client_org_manager_real_name, other_operator_ids, other_operator_real_names, client_is_delete, client_create_time, client_update_time, offline_province, convert_month, convert_from_code, convert_from FROM mysql_rds_0.xiron_analysis.view_client
数据没有全部insert成功
【StarRocks版本】3.1.3
【集群规模】1FE+1BE
【机器信息】4U、32G
【联系方式】社区群11-数字化个体户
【附件】
