[Bug] Doesn't trim the trailing spaces while querying hive external table  #9257

Search before asking

• I had searched in the issues 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?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct