[GitHub] [doris] guomm commented on issue #13702: [Bug] be crash

[GitBox <gi...@apache.org>]

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-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org