You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "He Yongqiang (JIRA)" <ji...@apache.org> on 2010/01/12 06:08:54 UTC
[jira] Created: (HIVE-1044) Data output order is incorrect for map
join
Data output order is incorrect for map join
-------------------------------------------
Key: HIVE-1044
URL: https://issues.apache.org/jira/browse/HIVE-1044
Project: Hadoop Hive
Issue Type: Bug
Reporter: He Yongqiang
For query:
select /*+ mapjoin(a, c)*/ * from T1 a join T12 b join T1 c on a.key = b.key and b.key = c.key;
The output data order is b.*, a.*, c.*.
It should be a.* b.* c.*
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (HIVE-1044) Data output order is incorrect for map
join
Posted by "He Yongqiang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1044?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
He Yongqiang resolved HIVE-1044.
--------------------------------
Resolution: Invalid
actually this join query is wrong. close this issue.
> Data output order is incorrect for map join
> -------------------------------------------
>
> Key: HIVE-1044
> URL: https://issues.apache.org/jira/browse/HIVE-1044
> Project: Hadoop Hive
> Issue Type: Bug
> Reporter: He Yongqiang
>
> For query:
> select /* + mapjoin(a, c) * / * from T1 a join T12 b join T1 c on a.key = b.key and b.key = c.key;
> The output data order is b.* a.* c.*
> It should be a.* b.* c.*
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-1044) Data output order is incorrect for
map join
Posted by "He Yongqiang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1044?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12799079#action_12799079 ]
He Yongqiang commented on HIVE-1044:
------------------------------------
this is also true for stream table.
> Data output order is incorrect for map join
> -------------------------------------------
>
> Key: HIVE-1044
> URL: https://issues.apache.org/jira/browse/HIVE-1044
> Project: Hadoop Hive
> Issue Type: Bug
> Reporter: He Yongqiang
>
> For query:
> select /* + mapjoin(a, c) * / * from T1 a join T12 b join T1 c on a.key = b.key and b.key = c.key;
> The output data order is b.* a.* c.*
> It should be a.* b.* c.*
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-1044) Data output order is incorrect for map
join
Posted by "He Yongqiang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1044?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
He Yongqiang updated HIVE-1044:
-------------------------------
Description:
For query:
select /* + mapjoin(a, c) * / * from T1 a join T12 b join T1 c on a.key = b.key and b.key = c.key;
The output data order is b.* a.* c.*
It should be a.* b.* c.*
was:
For query:
select /*+ mapjoin(a, c)*/ * from T1 a join T12 b join T1 c on a.key = b.key and b.key = c.key;
The output data order is b.*, a.*, c.*.
It should be a.* b.* c.*
> Data output order is incorrect for map join
> -------------------------------------------
>
> Key: HIVE-1044
> URL: https://issues.apache.org/jira/browse/HIVE-1044
> Project: Hadoop Hive
> Issue Type: Bug
> Reporter: He Yongqiang
>
> For query:
> select /* + mapjoin(a, c) * / * from T1 a join T12 b join T1 c on a.key = b.key and b.key = c.key;
> The output data order is b.* a.* c.*
> It should be a.* b.* c.*
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.