Toms1999 opened a new issue, #57650: URL: https://github.com/apache/doris/issues/57650
### 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.1.10 ### What's Wrong? MySQL [(none)]> select * from hivedgs.ods_plm_record_dxm.mg_rim_record_1_dd -> WHERE ods_day = '20251011' -> AND event_type IN ('post_loan','post_loan_external_query') -> AND product_code IN('JXJ001','JXJZZD') -> and cast(json_extract(json_extract(variables,'$.result'), '$.ExpType') AS varchar) ='1' -> AND cast(json_extract(json_extract(variables,'$.result'), '$.championStrategyId') AS varchar) ='dnlkxf_pl_cutprice_anchor_2502' -> AND cast(json_extract(json_extract(variables,'$.result'), '$.ChampionBeat') AS varchar) in ('1','2') -> AND cast(json_extract(json_extract(variables,'$.result'), '$.lifeCycleCustomerOwnership') AS varchar) IN ('6')-- 消费 -> and cast(json_extract(json_extract(variables,'$.result'), '$.batchDate') AS varchar) ='2025-10-11' -> and cast(json_extract(json_extract(variables,'$.result'), '$.softAdimitType') AS varchar) in ('冠军策略_泛在贷_命中V3模型','冠军策略_流失_命中V3模型','冠军策略_贷12_命中V3模型','冠军策略_贷3_命中V3模型','无软准入' ) --为了保证同质性 -> and cast(json_extract(json_extract(variables,'$.result'), '$.softAdimitType2') AS varchar) in ('挑战策略_泛在贷_命中V3模型','挑战策略_流失_命中V3模型','挑战策略_贷12_命中V3模型','挑战策略_贷3_命中V3模型','无软准入') --为了保证同质性 -> limit 10 -> ; ERROR 1105 (HY000): errCode = 2, detailMessage = (10.73.96.162)[CANCELLED]Orc row reader nextBatch failed. reason = Buffer error in ZlibDecompressionStream::NextDecompress. cur path: dgs://baihua/user/fsg_rcc_loan_riskmgt_plm/offlineMigrateCloud/hive/ods_plm_record_dxm/mg_rim_record_1_dd/ods_day=20251011/000409_0 ### What You Expected? return result ### How to Reproduce? _No response_ ### Anything Else? _No response_ ### Are you willing to submit PR? - [x] 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]
