gitbbrid commented on issue #10100: URL: https://github.com/apache/incubator-doris/issues/10100#issuecomment-1155018428
> Please give schema of table apply_info_v3, and some test data to reproduce the problem is better. Table of apply_info_v3 create table apply_info_v3 ( id bigint default '0' comment '自增', apply_no varchar(64) default '' comment '申请编号', customer_no varchar(64) default '' comment '客户编号', apply_amt bigint default '0' comment '授信额度', apply_status tinyint default '0' comment '申请状态 0/1/2/3 1-通过', rs_status tinyint default '0' comment '人工审核状态 1/2/3/4 4-完成', refuse_code varchar(64) default '' comment '拒绝原因码', channel_code varchar(16) default '' comment '渠道编码', create_time datetime default '1000-01-01 00:00:00' comment '创建时间', update_time datetime default '1000-01-01 00:00:00' comment '更新时间', update_year char(4) default '' comment '更新时间所在年', update_month char(7) default '' comment '更新时间所在月', update_week char(8) default '' comment '更新时间所在周', update_day char(10) default '' comment '更新时间所在天', create_week char(8) default '' comment '创建时间所在周', create_month char(7) default '' comment '创建时间所在月份', create_day char(10) default '' comment '创建时间所在天', create_year char(4) default '' comment '创建时间所在年份' ) COMMENT "额度申请" DISTRIBUTED BY HASH(id) BUCKETS 3 PROPERTIES ( "replication_num" = "1" ); test data of apply_info_v3 http://101.43.23.40/fintell_asset_data_show_apply_info_v3.json > Table of apply_info_v3 create table apply_info_v3 ( id bigint default '0' comment '自增', apply_no varchar(64) default '' comment '申请编号', customer_no varchar(64) default '' comment '客户编号', apply_amt bigint default '0' comment '授信额度', apply_status tinyint default '0' comment '申请状态 0/1/2/3 1-通过', rs_status tinyint default '0' comment '人工审核状态 1/2/3/4 4-完成', refuse_code varchar(64) default '' comment '拒绝原因码', channel_code varchar(16) default '' comment '渠道编码', create_time datetime default '1000-01-01 00:00:00' comment '创建时间', update_time datetime default '1000-01-01 00:00:00' comment '更新时间', update_year char(4) default '' comment '更新时间所在年', update_month char(7) default '' comment '更新时间所在月', update_week char(8) default '' comment '更新时间所在周', update_day char(10) default '' comment '更新时间所在天', create_week char(8) default '' comment '创建时间所在周', create_month char(7) default '' comment '创建时间所在月份', create_day char(10) default '' comment '创建时间所在天', create_year char(4) default '' comment '创建时间所在年份' ) COMMENT "额度申请" DISTRIBUTED BY HASH(id) BUCKETS 3 PROPERTIES ( "replication_num" = "1" ); > test data of apply_info_v3 [http://101.43.23.40/fintell_asset_data_show_apply_info_v3.json](http://101.43.23.40/fintell_asset_data_show_apply_info_v3.json) > CPU info  -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
