Jack-Qin-King opened a new issue, #60568: URL: https://github.com/apache/doris/issues/60568
### 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 4.0.1 ### What's Wrong? Data was lost during the data parsing process: Error msg: During Doris's analysis, the specified fields should normally have NULL values if they do not exist. However, the log shows otherwise - the fields are missing instead. <img width="1886" height="594" alt="Image" src="https://github.com/user-attachments/assets/b8ab07ca-fffd-40e6-b529-11d89ab0159a"; /> Flink SQL code : `CREATE TABLE Kafka_Table ( `id` BIGINT NOT NULL COMMENT '自增id', `_app_user_id` STRING COMMENT '应用中用户ID', `analysis_date` DATE COMMENT '日期', `_event_name` STRING COMMENT '预', `_app_id` STRING COMMENT '', `_package_name` STRING COMMENT 'An', `_app_channel_id` STRING COMMENT '包)', `_app_version` STRING COMMENT 'A）', `_app_game_version` STRING COMMENT '应 ', `_app_res_version` STRING COMMENT '应', `_app_install_id` STRING COMMENT '应', `_app_activate_id` STRING COMMENT '应', `_device_id` STRING COMMENT '应', `_ad_id` STRING COMMENT 'a', `_androidid` STRING COMMENT 'D', `_idfv` STRING COMMENT 'fv', `_os_type` STRING COMMENT '操', `_os_version` STRING COMMENT '', `_app_lang` STRING COMMENT '言', `_os_timezone_offset` String COMMENT '区', `_os_timestamp` BIGINT COMMENT '）', `_device_network_type` INT COMMENT '事', `stime` TIMESTAMP COMMENT '间', `_user_ip` STRING COMMENT '址', `_country_code` STRING COMMENT 'd', `analysis_hour` STRING COMMENT '', `_sub_event_name` STRING COMMENT '', `properties` STRING ) WITH ( 'connector' = 'kafka', 'topic' = 'rs_m_custom_event', 'properties.bootstrap.servers' = 'alikafka-pre-public-intl-sg-x1e48g70301-1-vpc.alikafka.aliyuncs.com:9092,alikafka-pre-public-intl-sg-x1e48g70301-2-vpc.alikafka.aliyuncs.com:9092,alikafka-pre-public-intl-sg-x1e48g70301-3-vpc.alikafka.aliyuncs.com:9092', 'properties.group.id' = 'flinkcdccustom', 'scan.startup.mode' = 'earliest-offset', 'format' = 'json' ); CREATE TABLE doris_to ( `id` BIGINT NOT NULL COMMENT '自增id', `app_user_id` STRING COMMENT '应用中用户ID', `analysis_date` DATE COMMENT '日期', `event_name` STRING COMMENT '预称', `app_id` STRING COMMENT 'Ap ', `package_name` STRING COMMENT 'AleID', `app_channel_id` STRING COMMENT ')', `app_version` STRING COMMENT '）', `app_game_version` STRING COMMENT '号 ', `app_res_version` STRING COMMENT '号', `app_install_id` STRING COMMENT '', `app_activate_id` STRING COMMENT '', `device_id` STRING COMMENT '一ID', `ad_id` STRING COMMENT 'a', `androidid` STRING COMMENT '', `idfv` STRING COMMENT '', `os_type` STRING COMMENT '', `os_version` STRING COMMENT '', `app_lang` STRING COMMENT '', `os_timezone_offset` String COMMENT '', `os_timestamp` BIGINT COMMENT '', `device_network_type` INT COMMENT '', `stime` TIMESTAMP COMMENT '', `user_ip` STRING COMMENT '', `country_id` STRING COMMENT , `analysis_hour` STRING COMMENT , `sub_event_name` STRING COMMENT , `properties` STRING, PRIMARY KEY (`id`, `app_user_id`, `analysis_date`) NOT ENFORCED ) WITH ( 'connector' = 'doris', 'table.identifier' = '*****', ${flinkdoris} 'sink.label-prefix' = 'kafka2doris_label' ); -- 3. 写入 INSERT INTO doris_to ( `id`, `app_user_id`, `analysis_date`, `event_name`, `app_id`, `package_name`, `app_channel_id`, `app_version`, `app_game_version`, `app_res_version`, `app_install_id`, `app_activate_id`, `device_id`, `ad_id`, `androidid`, `idfv`, `os_type`, `os_version`, `app_lang`, `os_timezone_offset`, `os_timestamp`, `device_network_type`, `stime`, `user_ip`, `country_id`, `analysis_hour`, `sub_event_name`, `properties` ) SELECT id, _app_user_id, analysis_date, _event_name, _app_id, _package_name, _app_channel_id, _app_version, _app_game_version, _app_res_version, _app_install_id, _app_activate_id, _device_id, _ad_id, _androidid, _idfv, _os_type, _os_version, _app_lang, _os_timezone_offset, _os_timestamp, _device_network_type, stime, _user_ip, _country_code, analysis_hour, _sub_event_name, properties FROM Kafka_Table where _event_name = '****';` ### What You Expected? fix the bug thx ### 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: [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]
