[
https://issues.apache.org/jira/browse/HIVE-1202?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12838946#action_12838946
]
He Yongqiang commented on HIVE-1202:
------------------------------------
Actually hive does not support this kind of join. It only support equal join.
please try sth like this:
select a.name, b.* from classes a join classes b on a.name = b.number where
a.name > b.number
> "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.
