[
https://issues.apache.org/jira/browse/HIVE-26011?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
wang da wei updated HIVE-26011:
-------------------------------
Attachment: image-2022-03-07-22-34-45-143.png
image-2022-03-07-22-26-46-207.png
Description:
{color:#0747a6}If the partition name is inconsistent with the directory name,
the results of Hive and Presto are inconsistent{color}
!image-2022-03-07-22-15-53-801.png|width=1207,height=350!
{color:#0747a6}The result of hive:{color}
!image-2022-03-07-22-14-18-658.png|width=1207,height=179!
{color:#0747a6}The result of presto:{color}
!image-2022-03-07-22-34-45-143.png|width=1207,height=179!
When I view the log, I find that hive has predicate push down, resulting in
null result.
!image-2022-03-07-22-26-46-207.png|width=1207,height=60!
{color:#57d9a3}Which result is correct? Thank you all!{color}
was:
If the partition name is inconsistent with the directory name, the results of
Hive and Presto are inconsistent,hive filter
!image-2022-03-07-22-15-53-801.png!
!image-2022-03-07-22-14-18-658.png!
!image-2022-03-07-22-14-51-933.png!
When I view the log, I find that hive has predicate push down, resulting in
null result. Which result is correct? Thank you for your answers!
!image-2022-03-07-22-16-30-435.png!
> Inconsistent with presto results
> --------------------------------
>
> Key: HIVE-26011
> URL: https://issues.apache.org/jira/browse/HIVE-26011
> Project: Hive
> Issue Type: Bug
> Components: Hive
> Affects Versions: 2.3.7
> Reporter: wang da wei
> Priority: Major
> Attachments: image-2022-03-07-22-14-18-658.png,
> image-2022-03-07-22-14-51-933.png, image-2022-03-07-22-15-53-801.png,
> image-2022-03-07-22-26-46-207.png, image-2022-03-07-22-34-45-143.png
>
>
> {color:#0747a6}If the partition name is inconsistent with the directory name,
> the results of Hive and Presto are inconsistent{color}
> !image-2022-03-07-22-15-53-801.png|width=1207,height=350!
> {color:#0747a6}The result of hive:{color}
> !image-2022-03-07-22-14-18-658.png|width=1207,height=179!
> {color:#0747a6}The result of presto:{color}
> !image-2022-03-07-22-34-45-143.png|width=1207,height=179!
> When I view the log, I find that hive has predicate push down, resulting in
> null result.
> !image-2022-03-07-22-26-46-207.png|width=1207,height=60!
> {color:#57d9a3}Which result is correct? Thank you all!{color}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
