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] Created: (HADOOP-4518) [hive] bad error reporting if a FROM
is missing in the nested query in case of JOIN
[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
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.
[jira] Assigned: (HADOOP-4518) [hive] bad error reporting if a FROM
is missing in the nested query in case of JOIN
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ 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.