[ https://issues.apache.org/jira/browse/HIVE-1202?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12839606#action_12839606 ]
Mafish commented on HIVE-1202: ------------------------------ @Yongqiang We have a internal hive originate from hive-0.4.2rc2. So we are not able to using the latest hive release. This bug afftects 0.4.x only since hive-0.5.x uses a different pruning strategy. I'm wondering if hive-0.4.x still need bug fixing since hive-0.5.x has been released? > "Unknown exception : null" while join > ------------------------------------- > > Key: HIVE-1202 > URL: https://issues.apache.org/jira/browse/HIVE-1202 > Project: Hadoop Hive > Issue Type: Bug > Components: Query Processor > Affects Versions: 0.4.1 > Environment: hive-0.4.1 > hadoop 0.19.1 > Reporter: Mafish > Fix For: 0.4.1 > > Attachments: HIVE-1202.branch-0.4.1.patch > > > Hive throws "Unknown exception : null" with query: > select * from > ( > select name from classes > ) a > join classes b > where a.name > b.number > After tracing the code, I found this bug will occur with following > conditions: > 1. It is join operation. > 2. At least one of the source of join is physical table (right side in > above case). > 3. With where condition and condition(s) of where clause must include > columns from both side of join (a.name and b.number in case) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.