You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Namit Jain (JIRA)" <ji...@apache.org> on 2010/12/14 00:22:01 UTC
[jira] Created: (HIVE-1848) bug in MAPJOIN
bug in MAPJOIN
--------------
Key: HIVE-1848
URL: https://issues.apache.org/jira/browse/HIVE-1848
Project: Hive
Issue Type: Bug
Components: Query Processor
Reporter: Namit Jain
explain
FROM srcpart c
JOIN srcpart d
ON ( c.key=d.key AND c.ds='2008-04-08' AND d.ds='2008-04-08')
SELECT /*+ MAPJOIN(d) */ DISTINCT c.campaign_id;
The above query throws an error:
FAILED: Error in semantic analysis: line 0:-1 Invalid Function TOK_MAPJOIN
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-1848) bug in MAPJOIN
Posted by "He Yongqiang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1848?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
He Yongqiang updated HIVE-1848:
-------------------------------
Attachment: hive-1848.1.patch
> bug in MAPJOIN
> --------------
>
> Key: HIVE-1848
> URL: https://issues.apache.org/jira/browse/HIVE-1848
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: He Yongqiang
> Attachments: hive-1848.1.patch
>
>
> explain
> FROM srcpart c
> JOIN srcpart d
> ON ( c.key=d.key AND c.ds='2008-04-08' AND d.ds='2008-04-08')
> SELECT /*+ MAPJOIN(d) */ DISTINCT c.campaign_id;
> The above query throws an error:
> FAILED: Error in semantic analysis: line 0:-1 Invalid Function TOK_MAPJOIN
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Assigned: (HIVE-1848) bug in MAPJOIN
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1848?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain reassigned HIVE-1848:
--------------------------------
Assignee: He Yongqiang
> bug in MAPJOIN
> --------------
>
> Key: HIVE-1848
> URL: https://issues.apache.org/jira/browse/HIVE-1848
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: He Yongqiang
>
> explain
> FROM srcpart c
> JOIN srcpart d
> ON ( c.key=d.key AND c.ds='2008-04-08' AND d.ds='2008-04-08')
> SELECT /*+ MAPJOIN(d) */ DISTINCT c.campaign_id;
> The above query throws an error:
> FAILED: Error in semantic analysis: line 0:-1 Invalid Function TOK_MAPJOIN
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-1848) bug in MAPJOIN
Posted by "He Yongqiang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1848?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
He Yongqiang updated HIVE-1848:
-------------------------------
Status: Patch Available (was: Open)
> bug in MAPJOIN
> --------------
>
> Key: HIVE-1848
> URL: https://issues.apache.org/jira/browse/HIVE-1848
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: He Yongqiang
> Attachments: hive-1848.1.patch
>
>
> explain
> FROM srcpart c
> JOIN srcpart d
> ON ( c.key=d.key AND c.ds='2008-04-08' AND d.ds='2008-04-08')
> SELECT /*+ MAPJOIN(d) */ DISTINCT c.campaign_id;
> The above query throws an error:
> FAILED: Error in semantic analysis: line 0:-1 Invalid Function TOK_MAPJOIN
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-1848) bug in MAPJOIN
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1848?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12971175#action_12971175 ]
Namit Jain commented on HIVE-1848:
----------------------------------
+1
> bug in MAPJOIN
> --------------
>
> Key: HIVE-1848
> URL: https://issues.apache.org/jira/browse/HIVE-1848
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: He Yongqiang
> Attachments: hive-1848.1.patch
>
>
> explain
> FROM srcpart c
> JOIN srcpart d
> ON ( c.key=d.key AND c.ds='2008-04-08' AND d.ds='2008-04-08')
> SELECT /*+ MAPJOIN(d) */ DISTINCT c.campaign_id;
> The above query throws an error:
> FAILED: Error in semantic analysis: line 0:-1 Invalid Function TOK_MAPJOIN
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-1848) bug in MAPJOIN
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1848?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-1848:
-----------------------------
Resolution: Fixed
Hadoop Flags: [Reviewed]
Status: Resolved (was: Patch Available)
Committed. Thanks Yongqiang
> bug in MAPJOIN
> --------------
>
> Key: HIVE-1848
> URL: https://issues.apache.org/jira/browse/HIVE-1848
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: He Yongqiang
> Attachments: hive-1848.1.patch
>
>
> explain
> FROM srcpart c
> JOIN srcpart d
> ON ( c.key=d.key AND c.ds='2008-04-08' AND d.ds='2008-04-08')
> SELECT /*+ MAPJOIN(d) */ DISTINCT c.campaign_id;
> The above query throws an error:
> FAILED: Error in semantic analysis: line 0:-1 Invalid Function TOK_MAPJOIN
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.