Jibing-Li opened a new issue, #9257: URL: https://github.com/apache/incubator-doris/issues/9257
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues. ### Version 1.0.0 ### What's Wrong? When search hive external table, doris doesn't trim the trailing spaces, but hive does. This leads to different query result of doris and hive. For example, we have a table with 2 columns: id, varchar(10); name, varchar(10); And the data file in HDFS for hive is： ``` id1 |name1 id2 |name2 ``` Notice that id1 and id2 are followed by a space. In hive, we can get id1, name1 after running: `select * from *** where id='id1',` But get empty result set in doris. In doris, we need to run: ( a space after 'id1') `select * from *** where id='id1 '` ### What You Expected? Get the same query result with hive while querying Hive external table. ### 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: 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
