search

StarRocks / starrocks

The world's fastest open query engine for sub-second analytics both on and off the data lakehouse. With the flexibility to support nearly any scenario, StarRocks provides best-in-class performance for multi-dimensional analytics, real-time analytics, and ad-hoc queries. A Linux Foundation project.
https://starrocks.io
Apache License 2.0
8.94k stars 1.8k forks source link

import csv file via stream_load into an large table failed with error #35421

Closed sanikoyes closed 5 months ago

sanikoyes commented 11 months ago

import csv file via stream_load into an large table failed with error

Steps to reproduce the behavior (Required)

  1. CREATE TABLE 
    CREATE TABLE `ta_event_119` (
`$part_date` varchar(4096) NOT NULL COMMENT "",
`$part_event` varchar(4096) NOT NULL COMMENT "",
`#user_id` bigint(20) NULL COMMENT "",
`#event_time` datetime NULL COMMENT "",
`#app_id` varchar(4096) NULL COMMENT "",
`#account_id` varchar(4096) NULL COMMENT "",
`#distinct_id` varchar(4096) NULL COMMENT "",
`#server_time` datetime NULL COMMENT "",
`#kafka_offset` bigint(20) NULL COMMENT "",
`#uuid` varchar(4096) NULL COMMENT "",
`#dw_create_time` datetime NULL COMMENT "",
`#dw_update_time` datetime NULL COMMENT "",
`#lib_version` varchar(4096) NULL COMMENT "",
`#zone_offset` double NULL COMMENT "",
`#os` varchar(4096) NULL COMMENT "",
`#ip` varchar(4096) NULL COMMENT "",
`#ram` varchar(4096) NULL COMMENT "",
`#data_source` varchar(4096) NULL COMMENT "",
`#screen_height` double NULL COMMENT "",
`#system_language` varchar(4096) NULL COMMENT "",
`#device_model` varchar(4096) NULL COMMENT "",
`#network_type` varchar(4096) NULL COMMENT "",
`#lib` varchar(4096) NULL COMMENT "",
`#device_type` varchar(4096) NULL COMMENT "",
`#city` varchar(4096) NULL COMMENT "",
`#disk` varchar(4096) NULL COMMENT "",
`#carrier` varchar(4096) NULL COMMENT "",
`#country_code` varchar(4096) NULL COMMENT "",
`#resume_from_background` boolean NULL COMMENT "",
`#device_id` varchar(4096) NULL COMMENT "",
`#province` varchar(4096) NULL COMMENT "",
`#bundle_id` varchar(4096) NULL COMMENT "",
`#screen_width` double NULL COMMENT "",
`#install_time` datetime NULL COMMENT "",
`#simulator` boolean NULL COMMENT "",
`#country` varchar(4096) NULL COMMENT "",
`#fps` double NULL COMMENT "",
`#manufacturer` varchar(4096) NULL COMMENT "",
`#app_version` varchar(4096) NULL COMMENT "",
`#os_version` varchar(4096) NULL COMMENT "",
`step_id` double NULL COMMENT "",
`duration` double NULL COMMENT "",
`result` varchar(4096) NULL COMMENT "",
`platform_type` varchar(4096) NULL COMMENT "",
`step_name` varchar(4096) NULL COMMENT "",
`fail_reason` varchar(4096) NULL COMMENT "",
`pkg_type` varchar(4096) NULL COMMENT "",
`url` varchar(4096) NULL COMMENT "",
`failed_reason` varchar(4096) NULL COMMENT "",
`lag` double NULL COMMENT "",
`monoheapsize` double NULL COMMENT "",
`monousedsize` double NULL COMMENT "",
`login_type` varchar(4096) NULL COMMENT "",
`login_id` varchar(4096) NULL COMMENT "",
`device_type` varchar(4096) NULL COMMENT "",
`picture_quality` varchar(4096) NULL COMMENT "",
`stamina` double NULL COMMENT "",
`gene` double NULL COMMENT "",
`level` double NULL COMMENT "",
`role_name` varchar(4096) NULL COMMENT "",
`gem` double NULL COMMENT "",
`life` double NULL COMMENT "",
`gold` double NULL COMMENT "",
`attack` double NULL COMMENT "",
`game_version` varchar(4096) NULL COMMENT "",
`stage` double NULL COMMENT "",
`#screen_name` varchar(4096) NULL COMMENT "",
`#duration` double NULL COMMENT "",
`#start_reason` varchar(65536) NULL COMMENT "",
`#background_duration` double NULL COMMENT "",
`role_id` varchar(4096) NULL COMMENT "",
`scene` varchar(4096) NULL COMMENT "",
`ectype_name` varchar(4096) NULL COMMENT "",
`hero_star_lev` double NULL COMMENT "",
`rune` varchar(4096) NULL COMMENT "",
`repeat_challenge_time` varchar(4096) NULL COMMENT "",
`last_ectype` varchar(4096) NULL COMMENT "",
`hero_name` varchar(4096) NULL COMMENT "",
`ectype_id` double NULL COMMENT "",
`hero_id` double NULL COMMENT "",
`equip` varchar(4096) NULL COMMENT "",
`hero_lev` double NULL COMMENT "",
`skill` varchar(4096) NULL COMMENT "",
`combatlevel` double NULL COMMENT "",
`speed` varchar(4096) NULL COMMENT "",
`life_inside` double NULL COMMENT "",
`kill_enemy` varchar(4096) NULL COMMENT "",
`is_frist_battle` boolean NULL COMMENT "",
`obtain_item` varchar(4096) NULL COMMENT "",
`attack_inside` double NULL COMMENT "",
`kill_boss` varchar(4096) NULL COMMENT "",
`prod_type` double NULL COMMENT "",
`is_success` boolean NULL COMMENT "",
`prod_id` double NULL COMMENT "",
`price` double NULL COMMENT "",
`transaction_id` varchar(4096) NULL COMMENT "",
`is_first_time` boolean NULL COMMENT "",
`prod_name` varchar(4096) NULL COMMENT "",
`pay_result` varchar(4096) NULL COMMENT "",
`currency_type` varchar(4096) NULL COMMENT "",
`pay_channel` varchar(4096) NULL COMMENT "",
`order_id` varchar(4096) NULL COMMENT "",
`event_time` double NULL COMMENT "",
`rune_name` varchar(4096) NULL COMMENT "",
`rune_quality` double NULL COMMENT "",
`rune_id` double NULL COMMENT "",
`hero_gain_mode` varchar(4096) NULL COMMENT "",
`tab_duration` double NULL COMMENT "",
`tab_name` varchar(4096) NULL COMMENT "",
`silver_coin_num` double NULL COMMENT "",
`gold_num` double NULL COMMENT "",
`strength_num` double NULL COMMENT "",
`charecter_lev` double NULL COMMENT "",
`guide_name` varchar(4096) NULL COMMENT "",
`guide_id` double NULL COMMENT "",
`is_skip` boolean NULL COMMENT "",
`talent_lev` double NULL COMMENT "",
`psign_in_opentime` varchar(4096) NULL COMMENT "",
`psign_in_reward_day` double NULL COMMENT "",
`psign_in_reward_date` varchar(4096) NULL COMMENT "",
`psign_in_points` double NULL COMMENT "",
`task_name` varchar(4096) NULL COMMENT "",
`task_id` double NULL COMMENT "",
`task_sub_type` varchar(4096) NULL COMMENT "",
`task_type` varchar(4096) NULL COMMENT "",
`remaining_time` double NULL COMMENT "",
`reward_lev` double NULL COMMENT "",
`position_price` varchar(4096) NULL COMMENT "",
`position_item` varchar(4096) NULL COMMENT "",
`position_id` double NULL COMMENT "",
`challenge_name` varchar(4096) NULL COMMENT "",
`challenge_id` double NULL COMMENT "",
`package_id` double NULL COMMENT "",
`num_of_clicks` double NULL COMMENT "",
`first_click` boolean NULL COMMENT "",
`package_price` double NULL COMMENT "",
`package_name` varchar(4096) NULL COMMENT "",
`equip_boolean` boolean NULL COMMENT "",
`equip_name` varchar(4096) NULL COMMENT "",
`equip_ectype_id` double NULL COMMENT "",
`equip_lev` double NULL COMMENT "",
`equip_position` varchar(4096) NULL COMMENT "",
`equip_quality` varchar(4096) NULL COMMENT "",
`bf_equip_lev` double NULL COMMENT "",
`af_equip_lev` double NULL COMMENT "",
`activity_name` varchar(4096) NULL COMMENT "",
`activity_id` double NULL COMMENT "",
`ad_type` varchar(4096) NULL COMMENT "",
`ad_position` varchar(4096) NULL COMMENT "",
`total_points` double NULL COMMENT "",
`mission_days` double NULL COMMENT "",
`mission_name` varchar(4096) NULL COMMENT "",
`recruit_num` double NULL COMMENT "",
`recruit_content` varchar(4096) NULL COMMENT "",
`recruit_type` varchar(4096) NULL COMMENT "",
`sign_in_opentime` varchar(4096) NULL COMMENT "",
`sign_in_type` varchar(4096) NULL COMMENT "",
`yaquprops` varchar(4096) NULL COMMENT "",
`yaqupower` double NULL COMMENT "",
`yaqupoints` double NULL COMMENT "",
`yaqugame_type` double NULL COMMENT "",
`yaquprops_num` double NULL COMMENT "",
`sign_in_day` double NULL COMMENT "",
`pubg_rank` double NULL COMMENT "",
`pubg_stay_time` double NULL COMMENT "",
`damage_scale` double NULL COMMENT "",
`boss_name` varchar(4096) NULL COMMENT "",
`points_all` double NULL COMMENT "",
`boss_id` double NULL COMMENT "",
`points_3` double NULL COMMENT "",
`points_2` double NULL COMMENT "",
`points_1` double NULL COMMENT "",
`#app_crashed_reason` varchar(65536) NULL COMMENT "",
`talent_tree_id` varchar(4096) NULL COMMENT "",
`mine_rank_open` double NULL COMMENT "",
`mine_open_depth` double NULL COMMENT "",
`mine_open_manuscript` double NULL COMMENT "",
`mine_close_manuscript` double NULL COMMENT "",
`mine_close_depth` double NULL COMMENT "",
`fail_result` varchar(4096) NULL COMMENT "",
`patrols_type` varchar(4096) NULL COMMENT "",
`activity_props_name` varchar(4096) NULL COMMENT "",
`first_draw` boolean NULL COMMENT "",
`bf_draws_props_num` double NULL COMMENT "",
`award_name_activity` varchar(4096) NULL COMMENT "",
`number_of_draws` double NULL COMMENT "",
`award_num_activity` double NULL COMMENT "",
`award_id_activity` double NULL COMMENT "",
`af_draws_props_num` double NULL COMMENT "",
`reward_days` double NULL COMMENT "",
`reward_points` double NULL COMMENT "",
`fund_type` varchar(4096) NULL COMMENT "",
`lev` double NULL COMMENT "",
`package_metod` varchar(4096) NULL COMMENT "",
`special_talent_lev` double NULL COMMENT "",
`talent_tree_jump` varchar(4096) NULL COMMENT "",
`af_equip_quality` varchar(4096) NULL COMMENT "",
`bf_equip_quality` varchar(4096) NULL COMMENT "",
`yaqu_position_id` double NULL COMMENT "",
`yaqu_position_item` varchar(4096) NULL COMMENT "",
`herotask_reward_details` varchar(4096) NULL COMMENT "",
`herotask_rewar_chestid` varchar(4096) NULL COMMENT "",
`bf_challenage_maxlev_dp` double NULL COMMENT "",
`bf_challenage_division` varchar(4096) NULL COMMENT "",
`bf_challenage_ranking` double NULL COMMENT "",
`bf_challenage_total_dp` double NULL COMMENT "",
`zones_entry_time` varchar(4096) NULL COMMENT "",
`rank_reward` varchar(4096) NULL COMMENT "",
`rank` double NULL COMMENT "",
`task` double NULL COMMENT "",
`task_reward` varchar(4096) NULL COMMENT "",
`rune_at_quality` double NULL COMMENT "",
`rune_bf_quality` double NULL COMMENT "",
`fish_id` varchar(4096) NULL COMMENT "",
`bait_name` varchar(4096) NULL COMMENT "",
`fishing_result` varchar(4096) NULL COMMENT "",
`fish_name` varchar(4096) NULL COMMENT "",
`fish_type` varchar(4096) NULL COMMENT "",
`backup_group_level` varchar(4096) NULL COMMENT "",
`backup_group_all` varchar(4096) NULL COMMENT "",
`dismissal_id` varchar(4096) NULL COMMENT "",
`group_name` varchar(4096) NULL COMMENT "",
`dismissal_name` varchar(4096) NULL COMMENT "",
`addgroup_name` varchar(4096) NULL COMMENT "",
`backup_group_type` varchar(4096) NULL COMMENT "",
`addgroup_id` varchar(4096) NULL COMMENT "",
`combat_time` double NULL COMMENT "",
`af_challenage_division` varchar(4096) NULL COMMENT "",
`challenage_type` varchar(4096) NULL COMMENT "",
`ranking_change_time` varchar(4096) NULL COMMENT "",
`division_change_time` varchar(4096) NULL COMMENT "",
`boss` varchar(4096) NULL COMMENT "",
`instancezones_tdp` double NULL COMMENT "",
`af_challenage_maxlev_dp` double NULL COMMENT "",
`chest_num` double NULL COMMENT "",
`af_challenage_total_dp` double NULL COMMENT "",
`af_challenage_ranking` double NULL COMMENT "",
`daily_challenge_id` double NULL COMMENT "",
`daily_challenge_name` varchar(4096) NULL COMMENT "",
`type` varchar(4096) NULL COMMENT "",
`joincount` double NULL COMMENT "",
`runeword_type` varchar(4096) NULL COMMENT "",
`runeword_id` double NULL COMMENT "",
`runeword_way` varchar(4096) NULL COMMENT "",
`runeword_quality` double NULL COMMENT "",
`runeword_name` varchar(4096) NULL COMMENT "",
`kill_monster` double NULL COMMENT "",
`get_num` double NULL COMMENT "",
`kill_player` double NULL COMMENT "",
`position` double NULL COMMENT "",
`time` double NULL COMMENT "",
`af_hero_star_lev` double NULL COMMENT "",
`bf_hero_star_lev` double NULL COMMENT "",
`af_hero_lev` double NULL COMMENT "",
`bf_hero_lev` double NULL COMMENT "",
`action` varchar(4096) NULL COMMENT "",
`mail_annex` varchar(4096) NULL COMMENT "",
`mail_id` varchar(4096) NULL COMMENT "",
`mail_title` varchar(4096) NULL COMMENT "",
`mail_context` varchar(4096) NULL COMMENT "",
`mail_sender_id` varchar(4096) NULL COMMENT "",
`mail_send_time` varchar(4096) NULL COMMENT "",
`mail_type` varchar(4096) NULL COMMENT "",
`mail_receiver_id` varchar(4096) NULL COMMENT "",
`yaquprops__change_type` varchar(4096) NULL COMMENT "",
`yaquprops__method` varchar(4096) NULL COMMENT "",
`fishing_name` varchar(4096) NULL COMMENT "",
`heroshop_prod_name` varchar(4096) NULL COMMENT "",
`heroshop_prod_id` double NULL COMMENT "",
`heroshop_price` double NULL COMMENT "",
`heroshop_buy_result` varchar(4096) NULL COMMENT "",
`backup_group_schedule` varchar(4096) NULL COMMENT "",
`matrix_type` varchar(4096) NULL COMMENT "",
`matrix_quality` double NULL COMMENT "",
`matrix_name` varchar(4096) NULL COMMENT "",
`matrix_id` double NULL COMMENT "",
`book_name` varchar(4096) NULL COMMENT "",
`book_name_1` varchar(4096) NULL COMMENT "",
`book_id` varchar(4096) NULL COMMENT "",
`#relaunched_in_background` boolean NULL COMMENT "",
`#mp_platform` varchar(4096) NULL COMMENT "",
`#jobid` varchar(4096) NULL COMMENT "",
`#utm` varchar(4096) NULL COMMENT "",
`#scene` double NULL COMMENT "",
`change_type` varchar(4096) NULL COMMENT "",
`currency` varchar(4096) NULL COMMENT "",
`method` varchar(4096) NULL COMMENT "",
`method_type` varchar(4096) NULL COMMENT "",
`item` varchar(4096) NULL COMMENT "",
`equip_time` double NULL COMMENT "",
`isfirstbuy` boolean NULL COMMENT "",
`product_num` double NULL COMMENT "",
`product_name` varchar(4096) NULL COMMENT "",
`chest_id` double NULL COMMENT "",
`chest_name` varchar(4096) NULL COMMENT "",
`arena_present_num` double NULL COMMENT "",
`arena_entry_num` double NULL COMMENT "",
`arena_left_time` double NULL COMMENT "",
`arena_tdp` double NULL COMMENT "",
`position_require` varchar(4096) NULL COMMENT "",
`izchest_name` varchar(4096) NULL COMMENT "",
`izchest_id` varchar(4096) NULL COMMENT "",
`zones_entry_num` double NULL COMMENT "",
`notice_type` varchar(4096) NULL COMMENT "",
`notice_closetime` varchar(4096) NULL COMMENT "",
`notice_opentime` varchar(4096) NULL COMMENT "",
`yaquitem_currency_type` double NULL COMMENT "",
`yaqushop_prod_type` double NULL COMMENT "",
`yaqushop_prod_id` double NULL COMMENT "",
`yaqushop_buy_result` varchar(4096) NULL COMMENT "",
`yaquitem_is_success` boolean NULL COMMENT "",
`yaquitem_price` double NULL COMMENT "",
`yaquitem_is_first_time` boolean NULL COMMENT "",
`yaqushop_prod_name` varchar(4096) NULL COMMENT "",
`award_name` varchar(4096) NULL COMMENT "",
`award_num` double NULL COMMENT "",
`award_id` double NULL COMMENT "",
`gametype` varchar(4096) NULL COMMENT "",
`id` double NULL COMMENT "",
`combatendtime` double NULL COMMENT "",
`bf_clicks_num` double NULL COMMENT "",
`first_clicks` boolean NULL COMMENT "",
`clicks_num` double NULL COMMENT "",
`#browser` varchar(4096) NULL COMMENT "",
`#ua` varchar(4096) NULL COMMENT "",
`#browser_version` varchar(4096) NULL COMMENT "",
`partner_id` varchar(4096) NULL COMMENT "",
`boomgames_id` varchar(4096) NULL COMMENT "",
`ecpm` double NULL COMMENT "",
`earnings` double NULL COMMENT "",
`ad_platform` varchar(4096) NULL COMMENT "",
`adunit_id` varchar(4096) NULL COMMENT "",
`sample_rate_wfb` double NULL COMMENT "",
`ad_channel` varchar(4096) NULL COMMENT "",
`yaqupower_change_type` double NULL COMMENT "",
`ride` varchar(4096) NULL COMMENT "",
`country` varchar(4096) NULL COMMENT "",
`load_sort` double NULL COMMENT "",
`mediation_rit` varchar(4096) NULL COMMENT "",
`link_id` varchar(4096) NULL COMMENT "",
`req_id` varchar(4096) NULL COMMENT "",
`sub_adtype` double NULL COMMENT "",
`if_test` double NULL COMMENT "",
`app_id` varchar(4096) NULL COMMENT "",
`waterfall_abtest` varchar(4096) NULL COMMENT "",
`exchange_rate` varchar(4096) NULL COMMENT "",
`adn_preload` double NULL COMMENT "",
`event_extra` varchar(4096) NULL COMMENT "",
`mediationrit_req_type` double NULL COMMENT "",
`waterfall_extra` varchar(4096) NULL COMMENT "",
`block_show_count` double NULL COMMENT "",
`show_sort` double NULL COMMENT "",
`version` varchar(4096) NULL COMMENT "",
`origin_type` double NULL COMMENT "",
`error_code` double NULL COMMENT "",
`prime_rit` varchar(4096) NULL COMMENT "",
`rit_cpm` varchar(4096) NULL COMMENT "",
`req_bidding_type` double NULL COMMENT "",
`client_req_id` varchar(4096) NULL COMMENT "",
`waterfall_id` double NULL COMMENT "",
`primerit_req_type` double NULL COMMENT "",
`app_abtest` varchar(4096) NULL COMMENT "",
`user_defined_grouping_params` varchar(4096) NULL COMMENT "",
`parallel_type` double NULL COMMENT "",
`req_type` double NULL COMMENT "",
`msdk_session_id` varchar(4096) NULL COMMENT "",
`timestamp` double NULL COMMENT "",
`adtype` double NULL COMMENT "",
`error_msg` varchar(4096) NULL COMMENT "",
`req_parallel_num` double NULL COMMENT "",
`adn_count` double NULL COMMENT "",
`adn_name` varchar(4096) NULL COMMENT "",
`block_pacing` double NULL COMMENT "",
`transparent_params` varchar(4096) NULL COMMENT "",
`reyun_id` varchar(4096) NULL COMMENT "",
`p` varchar(4096) NULL COMMENT "",
`ad_sdk_version` varchar(4096) NULL COMMENT "",
`media_req_type` double NULL COMMENT "",
`adn_count_in_curr_level` double NULL COMMENT "",
`ad_count` double NULL COMMENT "",
`mediation_req_type` double NULL COMMENT "",
`#title` varchar(4096) NULL COMMENT "",
`gogo` varchar(4096) NULL COMMENT "",
`wxtotalmemsize` double NULL COMMENT "",
`wxusedmemsize` double NULL COMMENT "",
`guide_guideevent` varchar(4096) NULL COMMENT "",
`guide_nowguideid` double NULL COMMENT "",
`nag` double NULL COMMENT "",
`pangle` varchar(4096) NULL COMMENT "",
`gdt` varchar(4096) NULL COMMENT "",
`dateformat` varchar(4096) NULL COMMENT "",
`locale` varchar(4096) NULL COMMENT "",
`formatterbehavior` double NULL COMMENT "",
`divinatory_sign` varchar(4096) NULL COMMENT "",
`militarytally_num` double NULL COMMENT "",
`hero_vouchers` double NULL COMMENT "",
`hero_equipment` varchar(4096) NULL COMMENT "",
`wave` double NULL COMMENT "",
`city_name` varchar(4096) NULL COMMENT "",
`grain` double NULL COMMENT "",
`city_luck` double NULL COMMENT "",
`city_health` double NULL COMMENT "",
`recruitment_num` double NULL COMMENT "",
`e_hero_name` varchar(4096) NULL COMMENT "",
`zhu_hero_id` double NULL COMMENT "",
`fu_hero_name` varchar(4096) NULL COMMENT "",
`combination_level` double NULL COMMENT "",
`zhu_hero_name` varchar(4096) NULL COMMENT "",
`fu_hero_id` double NULL COMMENT "",
`fu_hero_star_lev` double NULL COMMENT "",
`all_hero_star_lev` double NULL COMMENT "",
`zhu_hero_lev` double NULL COMMENT "",
`zhu_hero_star_lev` double NULL COMMENT "",
`fu_hero_lev` double NULL COMMENT "",
`cypher` double NULL COMMENT "",
`inventory` double NULL COMMENT "",
`capacity` double NULL COMMENT "",
`unlock_pets_name` varchar(4096) NULL COMMENT "",
`battle_pet` varchar(4096) NULL COMMENT "",
`go_territory` varchar(4096) NULL COMMENT "",
`gather` varchar(4096) NULL COMMENT "",
`reward_name` varchar(4096) NULL COMMENT "",
`reward_id` double NULL COMMENT "",
`rewards` varchar(4096) NULL COMMENT "",
`worker_trusteeship` varchar(4096) NULL COMMENT "",
`pay_channel_new` varchar(4096) NULL COMMENT "",
`app_version` varchar(4096) NULL COMMENT "",
`isfusion` boolean NULL COMMENT "",
`conn_type` double NULL COMMENT "",
`mediation_sdk_version` varchar(4096) NULL COMMENT "",
`device_info` varchar(4096) NULL COMMENT "",
`event_id` varchar(4096) NULL COMMENT "",
`calendar` varchar(4096) NULL COMMENT "",
`timezone` varchar(4096) NULL COMMENT "",
`hero_awaken_step` varchar(4096) NULL COMMENT "",
`hero_awaken_point` varchar(4096) NULL COMMENT "",
`hero_awaken_level` varchar(4096) NULL COMMENT "",
`_kcfstreamtlsminimumversion` double NULL COMMENT "",
`soul_name_1` varchar(4096) NULL COMMENT "",
`soul_type` varchar(4096) NULL COMMENT "",
`soul_name` varchar(4096) NULL COMMENT "",
`soul_id` double NULL COMMENT "",
`soul_id_1` double NULL COMMENT "",
`nt` double NULL COMMENT "",
`event` varchar(4096) NULL COMMENT ""
) ENGINE=OLAP 
DUPLICATE KEY(`$part_date`, `$part_event`)
DISTRIBUTED BY HASH(`#user_id`)
PROPERTIES (
"replication_num" = "1",
"in_memory" = "false",
"enable_persistent_index" = "false",
"replicated_storage" = "true",
"compression" = "LZ4"
);

    imported csv file:

    
"2023-11-15","ta_mg_show",1162375454133334016,"2023-11-15 08:02:14.685","6a951866a9724d338dcb9a76566101d0","124719674","9380690657-1699648917583","2023-11-12 08:02:19.936",5720434626,"718cc30d-1d24-427c-b869-f300f48abbe7","2023-11-12 08:02:20.585",,"2.2.0",8.0,"iOS","222.211.172.29",,"Mini_Game",852.0,,"unknown<iPhone15,4>","wifi","MG",,"成都",,,"CN",,"9380690657-1699648917583","四川",,393.0,,,"中国",,"iPhone",,"17.0.3",,,,"WX",,,,,,204.0,122888192.0,122888192.0,,,"次绑定","high",1.0,0.0,40.0,"DevilZero",31393.0,12910.0,90305.0,4496.0,"6.0.0",23.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"wechat",,"{}",1089.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,805306368.0,0.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"2023-11-15","start_game",1162375454133334016,"2023-11-15 08:02:14.871","6a951866a9724d338dcb9a76566101d0","124719674","9380690657-1699648917583","2023-11-12 08:02:20.024",5720434650,"44b8807f-3df0-4165-9d59-5db4f83c3fc6","2023-11-12 08:02:20.585",,"2.2.0",8.0,"iOS","222.211.172.29",,"Mini_Game",852.0,,"unknown<iPhone15,4>","wifi","MG",,"成都",,,"CN",,"9380690657-1699648917583","四川",,393.0,,,"中国",,"iPhone",,"17.0.3",1.0,0.0,"成功","WX","1.进入游戏","","",,,204.0,122888192.0,122888192.0,,,"次绑定","high",1.0,0.0,40.0,"DevilZero",31393.0,12910.0,90305.0,4496.0,"6.0.0",23.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"wechat",,"{}",1089.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,805306368.0,0.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"2023-11-15","start_game",1162375454133334016,"2023-11-15 08:02:15.567","6a951866a9724d338dcb9a76566101d0","124719674","9380690657-1699648917583","2023-11-12 08:02:20.672",5720434786,"d158ddb5-d0a3-42b5-9591-5240bab3536b","2023-11-12 08:02:21.592",,"2.2.0",8.0,"iOS","222.211.172.29",,"Mini_Game",852.0,,"unknown<iPhone15,4>","wifi","MG",,"成都",,,"CN",,"9380690657-1699648917583","四川",,393.0,,,"中国",,"iPhone",,"17.0.3",8.0,0.697,"成功","WX","8.代码加载中","","",,,204.0,122888192.0,122888192.0,,,"次绑定","high",1.0,0.0,40.0,"DevilZero",31393.0,12910.0,90305.0,4496.0,"6.0.0",23.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"wechat",,"{}",1089.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,805306368.0,0.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"2023-11-15","start_game",1162375454133334016,"2023-11-15 08:02:16.113","6a951866a9724d338dcb9a76566101d0","124719674","9380690657-1699648917583","2023-11-12 08:02:21.212",5720434869,"5628499c-23d9-4f1b-86ad-a8595239a861","2023-11-12 08:02:21.592",,"2.2.0",8.0,"iOS","222.211.172.29",,"Mini_Game",852.0,,"unknown<iPhone15,4>","wifi","MG",,"成都",,,"CN",,"9380690657-1699648917583","四川",,393.0,,,"中国",,"iPhone",,"17.0.3",9.0,0.546,"成功","WX","9.代码加载完成","","",,,204.0,122888192.0,122888192.0,,,"次绑定","high",1.0,0.0,40.0,"DevilZero",31393.0,12910.0,90305.0,4496.0,"6.0.0",23.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"wechat",,"{}",1089.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,805306368.0,0.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"2023-11-15","start_game",1162375454133334016,"2023-11-15 08:02:16.115","6a951866a9724d338dcb9a76566101d0","124719674","9380690657-1699648917583","2023-11-12 08:02:21.308",5720434889,"1a55ee52-b21b-44c1-8ac9-f944ab669b87","2023-11-12 08:02:21.592",,"2.2.0",8.0,"iOS","222.211.172.29",,"Mini_Game",852.0,,"unknown<iPhone15,4>","wifi","MG",,"成都",,,"CN",,"9380690657-1699648917583","四川",,393.0,,,"中国",,"iPhone",,"17.0.3",10.0,0.001999974,"成功","WX","10.游戏入口加载中","","",,,204.0,122888192.0,122888192.0,,,"次绑定","high",1.0,0.0,40.0,"DevilZero",31393.0,12910.0,90305.0,4496.0,"6.0.0",23.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"wechat",,"{}",1089.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,805306368.0,0.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"2023-11-15","start_game",1162375454133334016,"2023-11-15 08:02:16.119","6a951866a9724d338dcb9a76566101d0","124719674","9380690657-1699648917583","2023-11-12 08:02:21.308",5720434889,"014bde07-f5f3-45ea-a1e2-c18aaf5129fe","2023-11-12 08:02:21.592",,"2.2.0",8.0,"iOS","222.211.172.29",,"Mini_Game",852.0,,"unknown<iPhone15,4>","wifi","MG",,"成都",,,"CN",,"9380690657-1699648917583","四川",,393.0,,,"中国",,"iPhone",,"17.0.3",10.1,0.002000093,"成功","WX","10.1 开始游戏入口","","",,,204.0,122888192.0,122888192.0,,,"次绑定","high",1.0,0.0,40.0,"DevilZero",31393.0,12910.0,90305.0,4496.0,"6.0.0",23.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"wechat",,"{}",1089.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,805306368.0,0.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"2023-11-15","start_game",1162375454133334016,"2023-11-15 08:02:16.481","6a951866a9724d338dcb9a76566101d0","124719674","9380690657-1699648917583","2023-11-12 08:02:21.606",5720434964,"c898ee22-4c51-4458-9f23-7be235593767","2023-11-12 08:02:22.614",,"2.2.0",8.0,"iOS","222.211.172.29",,"Mini_Game",852.0,,"unknown<iPhone15,4>","wifi","MG",,"成都",,,"CN",,"9380690657-1699648917583","四川",,393.0,,,"中国",,"iPhone",,"17.0.3",10.2,0.3399999,"成功","WX","10.2 预加载配置",,"",,,204.0,122888192.0,122888192.0,,,"次绑定","high",1.0,0.0,40.0,"DevilZero",31393.0,12910.0,90305.0,4496.0,"6.0.0",23.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"wechat",,"{}",1089.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,805306368.0,0.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"2023-11-15","start_game",1162375454133334016,"2023-11-15 08:02:16.782","6a951866a9724d338dcb9a76566101d0","124719674","9380690657-1699648917583","2023-11-12 08:02:21.884",5720435032,"97bc6f0c-d482-4523-b2b9-78f606d8651e","2023-11-12 08:02:22.614",,"2.2.0",8.0,"iOS","222.211.172.29",,"Mini_Game",852.0,,"unknown<iPhone15,4>","wifi","MG",,"成都",,,"CN",,"9380690657-1699648917583","四川",,393.0,,,"中国",,"iPhone",,"17.0.3",10.3,0.3000002,"成功","WX","10.3 加载LoadingWindow",,"",,,204.0,122888192.0,122888192.0,,,"次绑定","high",1.0,0.0,40.0,"DevilZero",31393.0,12910.0,90305.0,4496.0,"6.0.0",23.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"wechat",,"{}",1089.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,805306368.0,0.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"2023-11-15","start_game",1162375454133334016,"2023-11-15 08:02:16.872","6a951866a9724d338dcb9a76566101d0","124719674","9380690657-1699648917583","2023-11-12 08:02:21.988",5720435056,"1672df42-5d23-464e-aa3a-54f5699fd7ec","2023-11-12 08:02:22.614",,"2.2.0",8.0,"iOS","222.211.172.29",,"Mini_Game",852.0,,"unknown<iPhone15,4>","wifi","MG",,"成都",,,"CN",,"9380690657-1699648917583","四川",,393.0,,,"中国",,"iPhone",,"17.0.3",10.4,0.09099984,"成功","WX","10.4 登录之前",,"",,,0.0,106110976.0,106110976.0,,,"次绑定","high",1.0,0.0,40.0,"DevilZero",31393.0,12910.0,90305.0,4496.0,"6.0.0",23.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"wechat",,"{}",1089.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,805306368.0,0.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
"2023-11-15","login_result",1162375454133334016,"2023-11-15 08:02:16.950","6a951866a9724d338dcb9a76566101d0","124719674","9380690657-1699648917583","2023-11-12 08:02:22.048",5720435064,"4c8b8df5-454e-48ec-af56-d2c7cd2f3b14","2023-11-12 08:02:22.614",,"2.2.0",8.0,"iOS","222.211.172.29",,"Mini_Game",852.0,,"unknown<iPhone15,4>","wifi","MG",,"成都",,,"CN",,"9380690657-1699648917583","四川",,393.0,,,"中国",,"iPhone",,"17.0.3",,,"true","WX",,,,,,0.0,106110976.0,106110976.0,,"124719674","次绑定","high",1.0,0.0,40.0,"DevilZero",31393.0,12910.0,90305.0,4496.0,"6.0.0",23.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"wechat",,"{}",1089.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,805306368.0,0.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

# import.sh
```bash
curl --location-trusted -u root: -H "label:ta_import" \
    -H "Expect:100-continue" \
    -H "column_separator:," \
    -T dump.csv -XPUT \
    http://172.16.0.169:8030/api/ta/ta_event_119/_stream_load

Expected behavior (Required)

Real behavior (Required)

Error: Value count does not match column count. Expect 445, but got 0.Column delimiter: 44,Row delimiter: 10.. Row: "2023-11-15","ta_mg_show",1162375454133334016,"2023-11-15 08:02:14.685","6a951866a9724d338dcb9a76566101d0","124719674","9380690657-1699648917583","2023-11-12 08:02:19.936",5720434626,"718cc30d-1d24-427c-b869-f300f48abbe7","2023-11-12 08:02:20.585",,"2.2.0",8.0,"iOS","222.211.172.29",,"Mini_Game",852.0,,"unknown<iPhone15,4>","wifi","MG",,"成都",,,"CN",,"9380690657-1699648917583","四川",,393.0,,,"中国",,"iPhone",,"17.0.3",,,,"WX",,,,,,204.0,122888192.0,122888192.0,,,"次绑定","high",1.0,0.0,40.0,"DevilZero",31393.0,12910.0,90305.0,4496.0,"6.0.0",23.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"wechat",,"{}",1089.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,805306368.0,0.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Error: Value count does not match column count. Expect 445, but got 0.Column delimiter: 44,Row delimiter: 10.. Row: "2023-11-15","start_game",1162375454133334016,"2023-11-15 08:02:14.871","6a951866a9724d338dcb9a76566101d0","124719674","9380690657-1699648917583","2023-11-12 08:02:20.024",5720434650,"44b8807f-3df0-4165-9d59-5db4f83c3fc6","2023-11-12 08:02:20.585",,"2.2.0",8.0,"iOS","222.211.172.29",,"Mini_Game",852.0,,"unknown<iPhone15,4>","wifi","MG",,"成都",,,"CN",,"9380690657-1699648917583","四川",,393.0,,,"中国",,"iPhone",,"17.0.3",1.0,0.0,"成功","WX","1.进入游戏","","",,,204.0,122888192.0,122888192.0,,,"次绑定","high",1.0,0.0,40.0,"DevilZero",31393.0,12910.0,90305.0,4496.0,"6.0.0",23.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"wechat",,"{}",1089.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,805306368.0,0.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Error: Value count does not match column count. Expect 445, but got 0.Column delimiter: 44,Row delimiter: 10.. Row: "2023-11-15","start_game",1162375454133334016,"2023-11-15 08:02:15.567","6a951866a9724d338dcb9a76566101d0","124719674","9380690657-1699648917583","2023-11-12 08:02:20.672",5720434786,"d158ddb5-d0a3-42b5-9591-5240bab3536b","2023-11-12 08:02:21.592",,"2.2.0",8.0,"iOS","222.211.172.29",,"Mini_Game",852.0,,"unknown<iPhone15,4>","wifi","MG",,"成都",,,"CN",,"9380690657-1699648917583","四川",,393.0,,,"中国",,"iPhone",,"17.0.3",8.0,0.697,"成功","WX","8.代码加载中","","",,,204.0,122888192.0,122888192.0,,,"次绑定","high",1.0,0.0,40.0,"DevilZero",31393.0,12910.0,90305.0,4496.0,"6.0.0",23.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"wechat",,"{}",1089.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,805306368.0,0.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Error: Value count does not match column count. Expect 445, but got 0.Column delimiter: 44,Row delimiter: 10.. Row: "2023-11-15","start_game",1162375454133334016,"2023-11-15 08:02:16.113","6a951866a9724d338dcb9a76566101d0","124719674","9380690657-1699648917583","2023-11-12 08:02:21.212",5720434869,"5628499c-23d9-4f1b-86ad-a8595239a861","2023-11-12 08:02:21.592",,"2.2.0",8.0,"iOS","222.211.172.29",,"Mini_Game",852.0,,"unknown<iPhone15,4>","wifi","MG",,"成都",,,"CN",,"9380690657-1699648917583","四川",,393.0,,,"中国",,"iPhone",,"17.0.3",9.0,0.546,"成功","WX","9.代码加载完成","","",,,204.0,122888192.0,122888192.0,,,"次绑定","high",1.0,0.0,40.0,"DevilZero",31393.0,12910.0,90305.0,4496.0,"6.0.0",23.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"wechat",,"{}",1089.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,805306368.0,0.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Error: Value count does not match column count. Expect 445, but got 0.Column delimiter: 44,Row delimiter: 10.. Row: "2023-11-15","start_game",1162375454133334016,"2023-11-15 08:02:16.115","6a951866a9724d338dcb9a76566101d0","124719674","9380690657-1699648917583","2023-11-12 08:02:21.308",5720434889,"1a55ee52-b21b-44c1-8ac9-f944ab669b87","2023-11-12 08:02:21.592",,"2.2.0",8.0,"iOS","222.211.172.29",,"Mini_Game",852.0,,"unknown<iPhone15,4>","wifi","MG",,"成都",,,"CN",,"9380690657-1699648917583","四川",,393.0,,,"中国",,"iPhone",,"17.0.3",10.0,0.001999974,"成功","WX","10.游戏入口加载中","","",,,204.0,122888192.0,122888192.0,,,"次绑定","high",1.0,0.0,40.0,"DevilZero",31393.0,12910.0,90305.0,4496.0,"6.0.0",23.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"wechat",,"{}",1089.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,805306368.0,0.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Error: Value count does not match column count. Expect 445, but got 0.Column delimiter: 44,Row delimiter: 10.. Row: "2023-11-15","start_game",1162375454133334016,"2023-11-15 08:02:16.119","6a951866a9724d338dcb9a76566101d0","124719674","9380690657-1699648917583","2023-11-12 08:02:21.308",5720434889,"014bde07-f5f3-45ea-a1e2-c18aaf5129fe","2023-11-12 08:02:21.592",,"2.2.0",8.0,"iOS","222.211.172.29",,"Mini_Game",852.0,,"unknown<iPhone15,4>","wifi","MG",,"成都",,,"CN",,"9380690657-1699648917583","四川",,393.0,,,"中国",,"iPhone",,"17.0.3",10.1,0.002000093,"成功","WX","10.1 开始游戏入口","","",,,204.0,122888192.0,122888192.0,,,"次绑定","high",1.0,0.0,40.0,"DevilZero",31393.0,12910.0,90305.0,4496.0,"6.0.0",23.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"wechat",,"{}",1089.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,805306368.0,0.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Error: Value count does not match column count. Expect 445, but got 0.Column delimiter: 44,Row delimiter: 10.. Row: "2023-11-15","start_game",1162375454133334016,"2023-11-15 08:02:16.481","6a951866a9724d338dcb9a76566101d0","124719674","9380690657-1699648917583","2023-11-12 08:02:21.606",5720434964,"c898ee22-4c51-4458-9f23-7be235593767","2023-11-12 08:02:22.614",,"2.2.0",8.0,"iOS","222.211.172.29",,"Mini_Game",852.0,,"unknown<iPhone15,4>","wifi","MG",,"成都",,,"CN",,"9380690657-1699648917583","四川",,393.0,,,"中国",,"iPhone",,"17.0.3",10.2,0.3399999,"成功","WX","10.2 预加载配置",,"",,,204.0,122888192.0,122888192.0,,,"次绑定","high",1.0,0.0,40.0,"DevilZero",31393.0,12910.0,90305.0,4496.0,"6.0.0",23.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"wechat",,"{}",1089.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,805306368.0,0.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Error: Value count does not match column count. Expect 445, but got 0.Column delimiter: 44,Row delimiter: 10.. Row: "2023-11-15","start_game",1162375454133334016,"2023-11-15 08:02:16.782","6a951866a9724d338dcb9a76566101d0","124719674","9380690657-1699648917583","2023-11-12 08:02:21.884",5720435032,"97bc6f0c-d482-4523-b2b9-78f606d8651e","2023-11-12 08:02:22.614",,"2.2.0",8.0,"iOS","222.211.172.29",,"Mini_Game",852.0,,"unknown<iPhone15,4>","wifi","MG",,"成都",,,"CN",,"9380690657-1699648917583","四川",,393.0,,,"中国",,"iPhone",,"17.0.3",10.3,0.3000002,"成功","WX","10.3 加载LoadingWindow",,"",,,204.0,122888192.0,122888192.0,,,"次绑定","high",1.0,0.0,40.0,"DevilZero",31393.0,12910.0,90305.0,4496.0,"6.0.0",23.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"wechat",,"{}",1089.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,805306368.0,0.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Error: Value count does not match column count. Expect 445, but got 0.Column delimiter: 44,Row delimiter: 10.. Row: "2023-11-15","start_game",1162375454133334016,"2023-11-15 08:02:16.872","6a951866a9724d338dcb9a76566101d0","124719674","9380690657-1699648917583","2023-11-12 08:02:21.988",5720435056,"1672df42-5d23-464e-aa3a-54f5699fd7ec","2023-11-12 08:02:22.614",,"2.2.0",8.0,"iOS","222.211.172.29",,"Mini_Game",852.0,,"unknown<iPhone15,4>","wifi","MG",,"成都",,,"CN",,"9380690657-1699648917583","四川",,393.0,,,"中国",,"iPhone",,"17.0.3",10.4,0.09099984,"成功","WX","10.4 登录之前",,"",,,0.0,106110976.0,106110976.0,,,"次绑定","high",1.0,0.0,40.0,"DevilZero",31393.0,12910.0,90305.0,4496.0,"6.0.0",23.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"wechat",,"{}",1089.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,805306368.0,0.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Error: Value count does not match column count. Expect 445, but got 0.Column delimiter: 44,Row delimiter: 10.. Row: "2023-11-15","login_result",1162375454133334016,"2023-11-15 08:02:16.950","6a951866a9724d338dcb9a76566101d0","124719674","9380690657-1699648917583","2023-11-12 08:02:22.048",5720435064,"4c8b8df5-454e-48ec-af56-d2c7cd2f3b14","2023-11-12 08:02:22.614",,"2.2.0",8.0,"iOS","222.211.172.29",,"Mini_Game",852.0,,"unknown<iPhone15,4>","wifi","MG",,"成都",,,"CN",,"9380690657-1699648917583","四川",,393.0,,,"中国",,"iPhone",,"17.0.3",,,"true","WX",,,,,,0.0,106110976.0,106110976.0,,"124719674","次绑定","high",1.0,0.0,40.0,"DevilZero",31393.0,12910.0,90305.0,4496.0,"6.0.0",23.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,"wechat",,"{}",1089.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,805306368.0,0.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

StarRocks version (Required)

3.1.4-0c4b2a3

xyan3880 commented 11 months ago

I got the same problem loading some tsv format. It worked after I removed the "auto" column from input file. The error message could be more helpful.

github-actions[bot] commented 5 months ago

We have marked this issue as stale because it has been inactive for 6 months. If this issue is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 10 days to keep the issue queue tidy. Thank you for your contribution to StarRocks!