pancodex opened a new issue, #49034: URL: https://github.com/apache/doris/issues/49034
### 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: 3.0.2 hive: 3.1.0.3.1.5.0-152 ### What's Wrong? ### Description: When executing a multi-condition query on a hive table, an error is reported and all be servers are down. If it is just a simple **select without where or select where with all partition column or table size is small **, it can be executed normally. The table has 300 million datas, and there are more than 50 fields. The following table construction simplifies the fields that are not queried. ### SQL query error: SQL error [1105] [HY000]: RpcException, msg: io.grpc.StatusRuntimeException: UNAVAILABLE: Network closed for unknown reason ### hivecatalog： CREATE CATALOG hive_1 PROPERTIES ( "type" = "hms", "ipc.client.fallback-to-simple-auth-allowed" = "true", "hive.metastore.uris" = "thrift://data2:9083" ); ### Table creation statement: create table if not exists bd.record_di ( RECORD_ID string, PERSON_ID string , CARD_PHYSICAL_ID string other columns... ) PARTITIONED BY (STAT_DAY INT, ORDER_TYPE INT ) ROW FORMAT delimited FIELDS TERMINATED BY '\t' STORED AS parquet; ### ERROR SQL statement: SELECT * FROM hive_1.bd.record_di WHERE stat_day = 20250219 AND PERSON_ID = '2222' AND RECORD_ID = '11111' AND CARD_PHYSICAL_ID = '2222' limit 100 ### CORRECT SQL statement: （where with stat_day and order_type） SELECT * FROM hive_1.bd.record_di WHERE stat_day = 20250219 **AND ORDER_TYPE = 99** AND PERSON_ID = '2222' AND RECORD_ID = '11111' AND CARD_PHYSICAL_ID = '2222' limit 100 ### be.out  ### fe.warning  ### What You Expected? execute SQL normally ### How to Reproduce? 1. create table 2. create catalog 3. generate data in table 4. select hive table in doris ### 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]
