You are viewing a plain text version of this content. The canonical link for it is here.

Posted to common-dev@hadoop.apache.org by "Namit Jain (JIRA)" <ji...@apache.org> on 2008/10/25 01:43:44 UTC

[jira] Assigned: (HADOOP-4518) [hive] bad error reporting if a FROM is missing in the nested query in case of JOIN

     [ https://issues.apache.org/jira/browse/HADOOP-4518?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Namit Jain reassigned HADOOP-4518:
----------------------------------

    Assignee: Namit Jain

> [hive] bad error reporting if a FROM is missing in the nested query in case of JOIN
> -----------------------------------------------------------------------------------
>
>                 Key: HADOOP-4518
>                 URL: https://issues.apache.org/jira/browse/HADOOP-4518
>             Project: Hadoop Core
>          Issue Type: Bug
>            Reporter: Namit Jain
>            Assignee: Namit Jain
>
> EXPLAIN FROM 
> (SELECT DISTINCT C_CXT.USERID FROM C_CXT) A 
> JOIN 
> (SELECT FCT_INVITES.*  WHERE FCT_INVITES.INVITER_ID <> 0 AND FCT_INVITES.DS = '2008-10-01') B 
> ON (A.USERID = B.INVITER_ID)  SELECT B.*
> The above is missing FROM in the 2nd subquery (B), but the parser returns an error in JOIN

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.