"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
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.