[
https://issues.apache.org/jira/browse/HIVE-1202?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12839515#action_12839515
]
Mafish commented on HIVE-1202:
------------------------------
@Yongqaing
I ran the query:
select a.name, b.* from classes a join classes b on a.name = b.number where
a.name > b.number
It passed.
In this case, two tables are physical.
But when I changed one of them to sub-query, error occured again, as:
select a.name, b.* from (select name from classes) a join classes b on a.name
= b.number where a.name > b.number ;
Please try this case.
> "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.
