Mailing-List: contact hive-dev-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
Reply-To: hive-dev@hadoop.apache.org
Message-ID: <2004158053.26551267420026895.JavaMail.jira@brutus.apache.org>
Date: Mon, 1 Mar 2010 05:07:06 +0000 (UTC)
From: "He Yongqiang (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Subject: [jira] Commented: (HIVE-1202) "Unknown exception : null" while join
In-Reply-To: <361022625.548951267170387906.JavaMail.jira@brutus.apache.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/HIVE-1202?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12839551#action_12839551 ] 

He Yongqiang commented on HIVE-1202:
------------------------------------

I tried this query with the trunk code. it works fine.
hive> select a.name, b.* from (select name from classes) a join classes b on a.name = b.number where a.name>b.number;           
Total MapReduce jobs = 1


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