guomm commented on issue #13702:
URL: https://github.com/apache/doris/issues/13702#issuecomment-1293232367
same sql，sometimes success，sometimes crash。
table：
CREATE TABLE `dwd_xx_order_df_test`
(
`shop_id` bigint(20) NULL COMMENT "id",
`receiving_scan_time` varchar(32) NULL COMMENT "时间",
`order_no` varchar(32) NULL COMMENT "x",
`order_details_id` varchar(32) NULL COMMENT "x",
`is_anti_spam` int(11) NULL COMMENT "x",
`item_id` bigint(20) NULL COMMENT "x",
`status` int(11) NULL COMMENT "x",
`receiving_scan_flag` int(11) NULL COMMENT "x",
`user_id` bigint(20) NULL COMMENT "x",
`mobile` varchar(255) NULL COMMENT "x",
`address` text NULL COMMENT "x",
`vid` text NULL COMMENT "x",
`vcid` bigint(20) NULL COMMENT "x",
`tcid` bigint(20) NULL COMMENT "x",
`item_num` bigint(20) NULL COMMENT "x",
`purchase_price` double NULL COMMENT "x",
`total_amount` double NULL COMMENT "x",
`tid` bigint(20) NULL COMMENT "x",
`is_lack` int(11) NULL COMMENT "x",
`city_market_id` bigint(20) NULL COMMENT "x",
`is_same_city` int(11) NULL COMMENT "x",
`product_label_status` int(11) NULL COMMENT "x",
`qc_status` int(11) NULL COMMENT "x",
`create_time` varchar(32) NULL COMMENT "x",
`pay_time` varchar(32) NULL COMMENT "x",
`dt` varchar(32) NULL COMMENT "x"
) ENGINE=OLAP
DUPLICATE KEY(`shop_id`, `receiving_scan_time`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`shop_id`) BUCKETS 5
PROPERTIES (
"replication_allocation" = "tag.location.default: 1",
"in_memory" = "false",
"storage_format" = "V2"
);
query sql：
select shop_id,
receiving_scan_time,
order_no,
order_details_id,
case when product_label_status = 9 then '是' else '否' end as
is_cancel,
case
when is_anti_spam = 0 then '非作弊'
when is_anti_spam = 1 then '作弊1'
when is_anti_spam = 2 then '作弊2'
when is_anti_spam = 3 then '作弊3' end as
is_anti_spam,
item_id,
case when status = 0 then 'off' when status = 1 then 'on' end as
status,
receiving_scan_flag,
user_id,
mobile,
address,
vid,
vcid,
tcid,
item_num,
purchase_price,
total_amount,
tid,
is_lack,
city_market_id,
is_same_city,
product_label_status,
qc_status,
create_time,
pay_time,
dt
from dwd_old_order_df_test
where receiving_scan_time >= '2022-10-01';
> I briefly reproduced your scene, but there was no be crash. Could you
please describe your usage in detail, such as providing scheme and query
--
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: commits-unsubscr...@doris.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
