[ 
https://issues.apache.org/jira/browse/HIVE-26011?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

wang da wei updated HIVE-26011:
-------------------------------
    Attachment:     (was: 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)

Reply via email to