[
https://issues.apache.org/jira/browse/HIVE-28901?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17943598#comment-17943598
]
Raghav Aggarwal commented on HIVE-28901:
----------------------------------------
In working and wrong case the difference is in the number of digits for the
value in the id column. Query plans are same. I'm suspecting the typecasting to
double has some issue
> Wrong query result for join between string and bigint
> -----------------------------------------------------
>
> Key: HIVE-28901
> URL: https://issues.apache.org/jira/browse/HIVE-28901
> Project: Hive
> Issue Type: Bug
> Reporter: Raghav Aggarwal
> Assignee: Raghav Aggarwal
> Priority: Major
> Attachments: working.q, working.q.out, wrong.q, wrong.q.out
>
>
> Attaching the wrong and expected output q and q.out file to reproduce the
> issue.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
