hnwkz opened a new issue, #31299:
URL: https://github.com/apache/doris/issues/31299

   ### Search before asking
   
   - [X] I had searched in the 
[issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no 
similar issues.
   
   
   ### Version
   
   doris-2.0.4-rc06-003a815b63
   
   ### What's Wrong?
   
   执行查询语句:
   SELECT
   store_day,
   game_code,
   app_id,
   media,
   os_name,
   creative,
   SUM(cost) AS cost,
   SUM(installs) AS installs,
   SUM(total_pay_amount_after_proportion_1) AS 
total_pay_amount_after_proportion_1,
   SUM(total_pay_amount_after_proportion_3) AS 
total_pay_amount_after_proportion_3,
   SUM(total_pay_amount_after_proportion_7) AS 
total_pay_amount_after_proportion_7
   FROM ads.ads_bi_flat_ad_8
   WHERE media IN('facebook', 'applovin')
   GROUP BY store_day, game_code, app_id, media, os_name, creative;
   
   
   报如下错误:
   [2024-02-23 09:41:56] [HY000][1105] errCode = 2, detailMessage = 
(10.240.4.3)[CANCELLED][INTERNAL_ERROR]failed to initialize storage reader. 
tablet=105669072.1794131352.0542281d7c66c5a9-0333d4769be9169d, 
res=[NOT_IMPLEMENTED_ERROR]to be implemented
   [2024-02-23 09:41:56]        0#  
doris::RowwiseIterator::next_block_view(std::vector<doris::vectorized::IteratorRowRef,
 std::allocator<doris::vectorized::IteratorRowRef> >*) at 
/home/zcp/repo_center/doris_release/doris/be/src/olap/iterators.h:137
   [2024-02-23 09:41:56]        1#  
doris::BetaRowsetReader::next_block_view(std::vector<doris::vectorized::IteratorRowRef,
 std::allocator<doris::vectorized::IteratorRowRef> >*) at 
/home/zcp/repo_center/doris_release/doris/be/src/common/status.h:442
   [2024-02-23 09:41:56]        2#  
doris::vectorized::VCollectIterator::Level0Iterator::refresh_current_row() at 
/home/zcp/repo_center/doris_release/doris/be/src/common/status.h:442
   [2024-02-23 09:41:56]        3#  
doris::vectorized::VCollectIterator::Level0Iterator::init(bool) at 
/home/zcp/repo_center/doris_release/doris/be/src/vec/olap/vcollect_iterator.cpp:472
   [2024-02-23 09:41:56]        4#  
doris::vectorized::VCollectIterator::build_heap(std::vector<std::shared_ptr<doris::RowsetReader>,
 std::allocator<std::shared_ptr<doris::RowsetReader> > >&) at 
/home/zcp/repo_center/doris_release/doris/be/src/common/status.h:442
   [2024-02-23 09:41:56]        5#  
doris::vectorized::BlockReader::_init_collect_iter(doris::TabletReader::ReaderParams
 const&) at /home/zcp/repo_center/doris_release/doris/be/src/common/status.h:442
   [2024-02-23 09:41:56]        6#  
doris::vectorized::BlockReader::init(doris::TabletReader::ReaderParams const&) 
at /home/zcp/repo_center/doris_release/doris/be/src/common/status.h:442
   [2024-02-23 09:41:56]        7#  
doris::vectorized::NewOlapScanner::open(doris::RuntimeState*) at 
/home/zcp/repo_center/doris_release/doris/be/src/common/status.h:442
   [2024-02-23 09:41:56]        8#  
doris::vectorized::ScannerScheduler::_scanner_scan(doris::vectorized::ScannerScheduler*,
 doris::vectorized::ScannerContext*, 
std::shared_ptr<doris::vectorized::VScanner>) at 
/home/zcp/repo_center/doris_release/doris/be/src/common/status.h:354
   [2024-02-23 09:41:56]        9#  std::_Function_handler<void (), 
doris::vectorized::ScannerScheduler::_schedule_scanners(doris::vectorized::ScannerContext*)::$_1::operator()()
 const::{lambda()#3}>::_M_invoke(std::_Any_data const&) at 
/var/local/ldb_toolchain/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/shared_ptr_base.h:701
   [2024-02-23 09:41:56]        10# 
doris::WorkThreadPool<true>::work_thread(int) at 
/var/local/ldb_toolchain/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/atomic_base.h:646
   [2024-02-23 09:41:56]        11# execute_native_thread_routine at 
/data/gcc-11.1.0/build/x86_64-pc-linux-gnu/libstdc++-v3/include/bits/unique_ptr.h:85
   [2024-02-23 09:41:56]        12# start_thread
   [2024-02-23 09:41:56]        13# clone
   [2024-02-23 09:41:56] , backend=10.240.4.3
   [2024-02-23 09:41:56]        0#  
doris::vectorized::NewOlapScanner::open(doris::RuntimeState*) at 
/var/local/ldb_toolchain/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/basic_string.h:187
   [2024-02-23 09:41:56]        1#  
doris::vectorized::ScannerScheduler::_scanner_scan(doris::vectorized::ScannerScheduler*,
 doris::vectorized::ScannerContext*, 
std::shared_ptr<doris::vectorized::VScanner>) at 
/home/zcp/repo_center/doris_release/doris/be/src/common/status.h:354
   [2024-02-23 09:41:56]        2#  std::_Function_handler<void (), 
doris::vectorized::ScannerScheduler::_schedule_scanners(doris::vectorized::ScannerContext*)::$_1::operator()()
 const::{lambda()#3}>::_M_invoke(std::_Any_data const&) at 
/var/local/ldb_toolchain/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/shared_ptr_base.h:701
   [2024-02-23 09:41:56]        3#  
doris::WorkThreadPool<true>::work_thread(int) at 
/var/local/ldb_toolchain/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/atomic_base.h:646
   [2024-02-23 09:41:56]        4#  execute_native_thread_routine at 
/data/gcc-11.1.0/build/x86_64-pc-linux-gnu/libstdc++-v3/include/bits/unique_ptr.h:85
   [2024-02-23 09:41:56]        5#  start_thread
   [2024-02-23 09:41:56]        6#  clone
   
   
   
   通过获取报错的tablet_id,执行
   ADMIN SET REPLICA STATUS PROPERTIES("tablet_id" = "105665808", "backend_id" 
= "79078857", "status" = "bad");
   能恢复正常,但是有时候损坏的tablet太多,使用该语句十分麻烦,只能通过新建一个表结构完全一样的表:
   create table ads.ads_bi_flat_ad_8_temp like ads.ads_bi_flat_ad_8;
   然后再全量insert into 进去:
   insert into ads.ads_bi_flat_ad_8_temp
   select * from ads.ads_bi_flat_ad_8;
   再执行替换表:
   ALTER TABLE ads_bi_flat_ad_8 REPLACE WITH TABLE ads_bi_flat_ad_8_temp 
PROPERTIES('swap' = 'true');
   能恢复正常,该错误随机间隔出现,十分困扰。
   
   
   建表语句如下:
   CREATE TABLE `ads_bi_flat_ad_8` (
     `store_day` date NULL,
     `game_id` int(11) NULL,
     `app_id` varchar(255) NULL,
     `os_name` varchar(64) NULL,
     `media` varchar(512) NULL,
     `country` varchar(32) NULL,
     `af_prt` varchar(512) NULL,
     `campaign` varchar(1024) NULL,
     `adgroup` varchar(1024) NULL,
     `creative` varchar(2048) NULL,
     `game_name` varchar(64) REPLACE_IF_NOT_NULL NULL,
     `game_code` varchar(64) REPLACE_IF_NOT_NULL NULL,
     `media_group` varchar(64) REPLACE_IF_NOT_NULL NULL,
     `country_name` varchar(64) REPLACE_IF_NOT_NULL NULL,
     `country_tier` varchar(64) REPLACE_IF_NOT_NULL NULL,
     `country_group` varchar(64) REPLACE_IF_NOT_NULL NULL,
     `country_group_en` varchar(64) REPLACE_IF_NOT_NULL NULL,
     `app_code` varchar(64) REPLACE_IF_NOT_NULL NULL,
     `app_id_market_code` varchar(64) REPLACE_IF_NOT_NULL NULL,
     `app_id_status` varchar(64) REPLACE_IF_NOT_NULL NULL,
     `sdk_channel_code` varchar(64) REPLACE_IF_NOT_NULL NULL,
     `sdk_channel_name` varchar(64) REPLACE_IF_NOT_NULL NULL,
     `installs` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `install_conversion` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `reinstall` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `dnu` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `role_dnu` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `device_id_dnu` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `dau` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `device_id_dau` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay` double REPLACE_IF_NOT_NULL NULL,
     `cost` double REPLACE_IF_NOT_NULL NULL,
     `impressions` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `clicks` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_num` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `history_first_pay_num` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `register_bind_num` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `login_bind_num` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `admob_pay` double REPLACE_IF_NOT_NULL NULL,
     `total_pay_amount_max_yesterday` double REPLACE_IF_NOT_NULL NULL,
     `total_pay_amount_after_proportion_max_yesterday` double 
REPLACE_IF_NOT_NULL NULL,
     `recall_account` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `wake_account` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `new_add_account_current_month_pay` double REPLACE_IF_NOT_NULL NULL,
     `new_add_account_current_quarter_pay` double REPLACE_IF_NOT_NULL NULL,
     `recall_account_current_month_pay` double REPLACE_IF_NOT_NULL NULL,
     `recall_account_current_quarter_pay` double REPLACE_IF_NOT_NULL NULL,
     `retention_1` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `retention_2` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `retention_3` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `retention_4` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `retention_5` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `retention_6` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `retention_7` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `retention_14` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `retention_30` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `retention_60` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `retention_90` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `retention_120` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `retention_150` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `retention_180` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `retention_210` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `retention_240` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `retention_270` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `retention_300` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `retention_330` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `retention_360` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `retention_540` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `retention_720` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_login_retention_1` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_login_retention_2` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_login_retention_3` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_login_retention_4` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_login_retention_5` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_login_retention_6` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_login_retention_7` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_login_retention_14` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_login_retention_30` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_login_retention_60` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_login_retention_90` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_login_retention_120` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_login_retention_150` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_login_retention_180` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_login_retention_210` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_login_retention_240` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_login_retention_270` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_login_retention_300` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_login_retention_330` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_login_retention_360` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_login_retention_540` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_login_retention_720` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_num_1` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_num_2` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_num_3` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_num_4` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_num_5` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_num_6` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_num_7` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_num_14` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_num_30` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_num_60` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_num_90` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_num_120` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_num_150` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_num_180` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_time_1` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_time_2` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_time_3` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_time_4` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_time_5` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_time_6` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_time_7` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_time_14` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_time_30` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_time_60` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_time_90` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_time_120` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_time_150` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `pay_time_180` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `total_pay_amount_1` double REPLACE_IF_NOT_NULL NULL,
     `total_pay_amount_2` double REPLACE_IF_NOT_NULL NULL,
     `total_pay_amount_3` double REPLACE_IF_NOT_NULL NULL,
     `total_pay_amount_4` double REPLACE_IF_NOT_NULL NULL,
     `total_pay_amount_5` double REPLACE_IF_NOT_NULL NULL,
     `total_pay_amount_6` double REPLACE_IF_NOT_NULL NULL,
     `total_pay_amount_7` double REPLACE_IF_NOT_NULL NULL,
     `total_pay_amount_14` double REPLACE_IF_NOT_NULL NULL,
     `total_pay_amount_30` double REPLACE_IF_NOT_NULL NULL,
     `total_pay_amount_60` double REPLACE_IF_NOT_NULL NULL,
     `total_pay_amount_90` double REPLACE_IF_NOT_NULL NULL,
     `total_pay_amount_120` double REPLACE_IF_NOT_NULL NULL,
     `total_pay_amount_150` double REPLACE_IF_NOT_NULL NULL,
     `total_pay_amount_180` double REPLACE_IF_NOT_NULL NULL,
     `total_pay_amount_after_proportion_1` double REPLACE_IF_NOT_NULL NULL,
     `total_pay_amount_after_proportion_2` double REPLACE_IF_NOT_NULL NULL,
     `total_pay_amount_after_proportion_3` double REPLACE_IF_NOT_NULL NULL,
     `total_pay_amount_after_proportion_4` double REPLACE_IF_NOT_NULL NULL,
     `total_pay_amount_after_proportion_5` double REPLACE_IF_NOT_NULL NULL,
     `total_pay_amount_after_proportion_6` double REPLACE_IF_NOT_NULL NULL,
     `total_pay_amount_after_proportion_7` double REPLACE_IF_NOT_NULL NULL,
     `total_pay_amount_after_proportion_14` double REPLACE_IF_NOT_NULL NULL,
     `total_pay_amount_after_proportion_30` double REPLACE_IF_NOT_NULL NULL,
     `total_pay_amount_after_proportion_60` double REPLACE_IF_NOT_NULL NULL,
     `total_pay_amount_after_proportion_90` double REPLACE_IF_NOT_NULL NULL,
     `total_pay_amount_after_proportion_120` double REPLACE_IF_NOT_NULL NULL,
     `total_pay_amount_after_proportion_150` double REPLACE_IF_NOT_NULL NULL,
     `total_pay_amount_after_proportion_180` double REPLACE_IF_NOT_NULL NULL,
     `total_pay_num_1` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `total_pay_num_2` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `total_pay_num_3` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `total_pay_num_4` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `total_pay_num_5` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `total_pay_num_6` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `total_pay_num_7` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `total_pay_num_14` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `total_pay_num_30` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `total_pay_num_60` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `total_pay_num_90` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `total_pay_num_120` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `total_pay_num_150` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `total_pay_num_180` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `total_pay_time_1` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `total_pay_time_2` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `total_pay_time_3` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `total_pay_time_4` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `total_pay_time_5` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `total_pay_time_6` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `total_pay_time_7` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `total_pay_time_14` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `total_pay_time_30` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `total_pay_time_60` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `total_pay_time_90` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `total_pay_time_120` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `total_pay_time_150` bigint(20) REPLACE_IF_NOT_NULL NULL,
     `total_pay_time_180` bigint(20) REPLACE_IF_NOT_NULL NULL
   ) ENGINE=OLAP
   AGGREGATE KEY(`store_day`, `game_id`, `app_id`, `os_name`, `media`, 
`country`, `af_prt`, `campaign`, `adgroup`, `creative`)
   COMMENT 'OLAP'
   PARTITION BY RANGE(`store_day`)
   ()
   DISTRIBUTED BY HASH(`game_id`) BUCKETS 1
   PROPERTIES (
   "replication_allocation" = "tag.location.default: 3",
   "is_being_synced" = "false",
   "dynamic_partition.enable" = "true",
   "dynamic_partition.time_unit" = "DAY",
   "dynamic_partition.time_zone" = "Europe/London",
   "dynamic_partition.start" = "-2147483648",
   "dynamic_partition.end" = "7",
   "dynamic_partition.prefix" = "p",
   "dynamic_partition.replication_allocation" = "tag.location.default: 3",
   "dynamic_partition.buckets" = "1",
   "dynamic_partition.create_history_partition" = "true",
   "dynamic_partition.history_partition_num" = "2529",
   "dynamic_partition.hot_partition_num" = "0",
   "dynamic_partition.reserved_history_periods" = "NULL",
   "dynamic_partition.storage_policy" = "",
   "dynamic_partition.storage_medium" = "SSD",
   "storage_format" = "V2",
   "light_schema_change" = "true",
   "disable_auto_compaction" = "false",
   "enable_single_replica_compaction" = "false"
   );
   
   示例数据如下:
   insert into ads.ads_bi_flat_ad_8 (store_day, game_id, app_id, os_name, 
media, country, af_prt, campaign, adgroup, creative, game_name, game_code, 
media_group, country_name, country_tier, country_group, country_group_en, 
app_code, app_id_market_code, app_id_status, sdk_channel_code, 
sdk_channel_name, installs, install_conversion, reinstall, dnu, role_dnu, 
device_id_dnu, dau, device_id_dau, pay, cost, impressions, clicks, pay_num, 
history_first_pay_num, register_bind_num, login_bind_num, admob_pay, 
total_pay_amount_max_yesterday, 
total_pay_amount_after_proportion_max_yesterday, recall_account, wake_account, 
new_add_account_current_month_pay, new_add_account_current_quarter_pay, 
recall_account_current_month_pay, recall_account_current_quarter_pay, 
retention_1, retention_2, retention_3, retention_4, retention_5, retention_6, 
retention_7, retention_14, retention_30, retention_60, retention_90, 
retention_120, retention_150, retention_180, retention_210, retention_240, 
retention_270, ret
 ention_300, retention_330, retention_360, retention_540, retention_720, 
pay_login_retention_1, pay_login_retention_2, pay_login_retention_3, 
pay_login_retention_4, pay_login_retention_5, pay_login_retention_6, 
pay_login_retention_7, pay_login_retention_14, pay_login_retention_30, 
pay_login_retention_60, pay_login_retention_90, pay_login_retention_120, 
pay_login_retention_150, pay_login_retention_180, pay_login_retention_210, 
pay_login_retention_240, pay_login_retention_270, pay_login_retention_300, 
pay_login_retention_330, pay_login_retention_360, pay_login_retention_540, 
pay_login_retention_720, pay_num_1, pay_num_2, pay_num_3, pay_num_4, pay_num_5, 
pay_num_6, pay_num_7, pay_num_14, pay_num_30, pay_num_60, pay_num_90, 
pay_num_120, pay_num_150, pay_num_180, pay_time_1, pay_time_2, pay_time_3, 
pay_time_4, pay_time_5, pay_time_6, pay_time_7, pay_time_14, pay_time_30, 
pay_time_60, pay_time_90, pay_time_120, pay_time_150, pay_time_180, 
total_pay_amount_1, total_pay_amount_2, total_pay_a
 mount_3, total_pay_amount_4, total_pay_amount_5, total_pay_amount_6, 
total_pay_amount_7, total_pay_amount_14, total_pay_amount_30, 
total_pay_amount_60, total_pay_amount_90, total_pay_amount_120, 
total_pay_amount_150, total_pay_amount_180, 
total_pay_amount_after_proportion_1, total_pay_amount_after_proportion_2, 
total_pay_amount_after_proportion_3, total_pay_amount_after_proportion_4, 
total_pay_amount_after_proportion_5, total_pay_amount_after_proportion_6, 
total_pay_amount_after_proportion_7, total_pay_amount_after_proportion_14, 
total_pay_amount_after_proportion_30, total_pay_amount_after_proportion_60, 
total_pay_amount_after_proportion_90, total_pay_amount_after_proportion_120, 
total_pay_amount_after_proportion_150, total_pay_amount_after_proportion_180, 
total_pay_num_1, total_pay_num_2, total_pay_num_3, total_pay_num_4, 
total_pay_num_5, total_pay_num_6, total_pay_num_7, total_pay_num_14, 
total_pay_num_30, total_pay_num_60, total_pay_num_90, total_pay_num_120, 
total_pay_num_150, t
 otal_pay_num_180, total_pay_time_1, total_pay_time_2, total_pay_time_3, 
total_pay_time_4, total_pay_time_5, total_pay_time_6, total_pay_time_7, 
total_pay_time_14, total_pay_time_30, total_pay_time_60, total_pay_time_90, 
total_pay_time_120, total_pay_time_150, total_pay_time_180)
   values  ('2017-06-22', 10002, 'xxxxxxxxx', 'android', 'facebook', 'at', 
'facebook', null, null, null, 'War and Magic', 'WAM', '自投', '奥地利', 'T1', '西欧', 
'EU', 'WAM-GB', 'gb', 'enable', 'android', 'GooglePlay', null, null, null, 
null, null, null, 3, 0, 4.99, null, null, null, 1, null, null, null, null, 
null, null, null, null, null, null, null, null, null, null, null, null, null, 
null, null, null, null, null, null, null, null, null, null, null, null, null, 
null, null, null, null, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, null, null, 
null, null, null, null, null, null, null, null, null, null, null, null, null, 
null, null, null, null, null, null, null, null, null, null, null, null, null, 
null, null, null, null, null, null, null, null, null, null, null, null, null, 
null, null, null, null, null, null, null, null, null, null, null, null, null, 
null, null, null, null, null, null, null, null, null, null, null, null, null, 
null, null, null, null, null, null, null, null, null, nu
 ll, null, null, null, null, null, null, null, null, null, null, null, null, 
null, null, null),
           ('2017-06-22', 10002, 'xxxxxx', 'android', 'facebook', 'au', 
'facebook', null, null, null, 'War and Magic', 'WAM', '自投', '澳大利亚', 'T1', '英语', 
'EN', 'WAM-GB', 'gb', 'enable', 'android', 'GooglePlay', null, null, null, 
null, null, null, 13, 0, 4.99, null, null, null, 1, null, null, null, null, 
null, null, null, null, null, null, null, null, null, null, null, null, null, 
null, null, null, null, null, null, null, null, null, null, null, null, null, 
null, null, null, null, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, null, null, 
null, null, null, null, null, null, null, null, null, null, null, null, null, 
null, null, null, null, null, null, null, null, null, null, null, null, null, 
null, null, null, null, null, null, null, null, null, null, null, null, null, 
null, null, null, null, null, null, null, null, null, null, null, null, null, 
null, null, null, null, null, null, null, null, null, null, null, null, null, 
null, null, null, null, null, null, null, null, null, n
 ull, null, null, null, null, null, null, null, null, null, null, null, null, 
null, null, null),
           ('2017-06-22', 10002, 'xxxxxxxxxx', 'android', 'facebook', 'ba', 
'facebook', null, null, null, 'War and Magic', 'WAM', '自投', '波斯尼亚和黑塞哥维那', 'T5', 
'东欧', 'EU', 'WAM-GB', 'gb', 'enable', 'android', 'GooglePlay', null, null, 
null, 1, null, 0, 1, 0, null, null, null, null, null, null, null, null, null, 
null, null, null, null, null, null, null, null, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, null, null, null, null, null, null, null, 
null, null, null, null, null, null, null, null, null, null, null, null, null, 
null, null, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 
0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
           ('2017-06-22', 10002, 'xxxxxxxxxxxxxxxxxxxx', 'android', 'facebook', 
'be', 'facebook', null, null, null, 'War and Magic', 'WAM', '自投', '比利时', 'T2', 
'西欧', 'EU', 'WAM-GB', 'gb', 'enable', 'android', 'GooglePlay', null, null, 
null, 2, null, 0, 2, 0, null, null, null, null, null, null, null, null, null, 
null, null, null, null, null, null, null, null, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, null, null, null, null, null, null, null, 
null, null, null, null, null, null, null, null, null, null, null, null, null, 
null, null, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 
0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
           ('2017-06-22', 10002, 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', 'android', 
'facebook', 'bg', 'facebook', null, null, null, 'War and Magic', 'WAM', '自投', 
'保加利亚', 'T3', '东欧', 'EU', 'WAM-GB', 'gb', 'enable', 'android', 'GooglePlay', 
null, null, null, 1, null, 0, 2, 0, null, null, null, null, null, null, null, 
null, null, null, null, null, null, null, null, null, null, 1, 0, 0, 0, 0, 0, 
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, null, null, null, null, null, 
null, null, null, null, null, null, null, null, null, null, null, null, null, 
null, null, null, null, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
   
   
   ### What You Expected?
   
   解决该bug
   
   ### How to Reproduce?
   
   _No response_
   
   ### Anything Else?
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [ ] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of 
Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
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.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

Reply via email to