You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2022/04/27 08:29:24 UTC
[GitHub] [incubator-doris] Jibing-Li opened a new issue, #9257: [Bug] Doesn't trim the trailing spaces while querying hive external table
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-unsubscribe@doris.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] morningman closed issue #9257: [Bug] Doesn't trim the trailing spaces while querying hive external table
Posted by GitBox <gi...@apache.org>.
morningman closed issue #9257: [Bug] Doesn't trim the trailing spaces while querying hive external table
URL: https://github.com/apache/incubator-doris/issues/9257
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org