You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Ashish Thusoo (JIRA)" <ji...@apache.org> on 2008/12/01 18:19:44 UTC

[jira] Updated: (HIVE-57) [hive] bad error reporting if a FROM is missing in the nested query in case of JOIN

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

Ashish Thusoo updated HIVE-57:
------------------------------

    Component/s: Query Processor

> [hive] bad error reporting if a FROM is missing in the nested query in case of JOIN
> -----------------------------------------------------------------------------------
>
>                 Key: HIVE-57
>                 URL: https://issues.apache.org/jira/browse/HIVE-57
>             Project: Hadoop Hive
>          Issue Type: Bug
>          Components: Query Processor
>            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.