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/03/17 21:17:27 UTC
[jira] Created: (HIVE-1252) Task breaking bug when breaking after a
filter operator
Task breaking bug when breaking after a filter operator
-------------------------------------------------------
Key: HIVE-1252
URL: https://issues.apache.org/jira/browse/HIVE-1252
Project: Hadoop Hive
Issue Type: Bug
Reporter: He Yongqiang
Assignee: He Yongqiang
Fix For: 0.6.0
The plan for this query has a bug,
SELECT f.key, g.value FROM srcpart f JOIN srcpart m ON( f.key = m.key AND f.ds='2008-04-08' AND m.ds='2008-04-08' ) JOIN srcpart g ON(g.value = m.value AND g.ds='2008-04-08' AND m.ds='2008-04-08');
The first file sink operator's table desc contains all columns.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-1252) Task breaking bug when breaking after a
filter operator
Posted by "He Yongqiang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1252?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
He Yongqiang updated HIVE-1252:
-------------------------------
Attachment: hive-1252.2.patch
A new patch integrated Namit's comments. Thanks Namit!
> Task breaking bug when breaking after a filter operator
> -------------------------------------------------------
>
> Key: HIVE-1252
> URL: https://issues.apache.org/jira/browse/HIVE-1252
> Project: Hadoop Hive
> Issue Type: Bug
> Reporter: He Yongqiang
> Assignee: He Yongqiang
> Fix For: 0.6.0
>
> Attachments: hive-1252.1.patch, hive-1252.2.patch
>
>
> The plan for this query has a bug,
> SELECT f.key, g.value FROM srcpart f JOIN srcpart m ON( f.key = m.key AND f.ds='2008-04-08' AND m.ds='2008-04-08' ) JOIN srcpart g ON(g.value = m.value AND g.ds='2008-04-08' AND m.ds='2008-04-08');
> The first file sink operator's table desc contains all columns.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-1252) Task breaking bug when breaking after a
filter operator
Posted by "He Yongqiang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1252?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
He Yongqiang updated HIVE-1252:
-------------------------------
Attachment: hive-1252.3.patch
a new patch added m.value is not null and m.value!=''
> Task breaking bug when breaking after a filter operator
> -------------------------------------------------------
>
> Key: HIVE-1252
> URL: https://issues.apache.org/jira/browse/HIVE-1252
> Project: Hadoop Hive
> Issue Type: Bug
> Reporter: He Yongqiang
> Assignee: He Yongqiang
> Fix For: 0.6.0
>
> Attachments: hive-1252.1.patch, hive-1252.2.patch, hive-1252.3.patch
>
>
> The plan for this query has a bug,
> SELECT f.key, g.value FROM srcpart f JOIN srcpart m ON( f.key = m.key AND f.ds='2008-04-08' AND m.ds='2008-04-08' ) JOIN srcpart g ON(g.value = m.value AND g.ds='2008-04-08' AND m.ds='2008-04-08');
> The first file sink operator's table desc contains all columns.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-1252) Task breaking bug when breaking after
a filter operator
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1252?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12846748#action_12846748 ]
Namit Jain commented on HIVE-1252:
----------------------------------
Can you reduce the test data size - I mean create a new table with fewer rows - or you can use src1 to show the same problem
> Task breaking bug when breaking after a filter operator
> -------------------------------------------------------
>
> Key: HIVE-1252
> URL: https://issues.apache.org/jira/browse/HIVE-1252
> Project: Hadoop Hive
> Issue Type: Bug
> Reporter: He Yongqiang
> Assignee: He Yongqiang
> Fix For: 0.6.0
>
> Attachments: hive-1252.1.patch
>
>
> The plan for this query has a bug,
> SELECT f.key, g.value FROM srcpart f JOIN srcpart m ON( f.key = m.key AND f.ds='2008-04-08' AND m.ds='2008-04-08' ) JOIN srcpart g ON(g.value = m.value AND g.ds='2008-04-08' AND m.ds='2008-04-08');
> The first file sink operator's table desc contains all columns.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-1252) Task breaking bug when breaking after
a filter operator
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1252?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12846988#action_12846988 ]
Namit Jain commented on HIVE-1252:
----------------------------------
Can you change the test to add:
m.value is not null in the second join - it is painful to verify the results.
> Task breaking bug when breaking after a filter operator
> -------------------------------------------------------
>
> Key: HIVE-1252
> URL: https://issues.apache.org/jira/browse/HIVE-1252
> Project: Hadoop Hive
> Issue Type: Bug
> Reporter: He Yongqiang
> Assignee: He Yongqiang
> Fix For: 0.6.0
>
> Attachments: hive-1252.1.patch, hive-1252.2.patch
>
>
> The plan for this query has a bug,
> SELECT f.key, g.value FROM srcpart f JOIN srcpart m ON( f.key = m.key AND f.ds='2008-04-08' AND m.ds='2008-04-08' ) JOIN srcpart g ON(g.value = m.value AND g.ds='2008-04-08' AND m.ds='2008-04-08');
> The first file sink operator's table desc contains all columns.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (HIVE-1252) Task breaking bug when breaking after
a filter operator
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1252?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain resolved HIVE-1252.
------------------------------
Resolution: Fixed
Hadoop Flags: [Reviewed]
Committed. Thanks Yongqiang
> Task breaking bug when breaking after a filter operator
> -------------------------------------------------------
>
> Key: HIVE-1252
> URL: https://issues.apache.org/jira/browse/HIVE-1252
> Project: Hadoop Hive
> Issue Type: Bug
> Reporter: He Yongqiang
> Assignee: He Yongqiang
> Fix For: 0.6.0
>
> Attachments: hive-1252.1.patch, hive-1252.2.patch, hive-1252.3.patch
>
>
> The plan for this query has a bug,
> SELECT f.key, g.value FROM srcpart f JOIN srcpart m ON( f.key = m.key AND f.ds='2008-04-08' AND m.ds='2008-04-08' ) JOIN srcpart g ON(g.value = m.value AND g.ds='2008-04-08' AND m.ds='2008-04-08');
> The first file sink operator's table desc contains all columns.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-1252) Task breaking bug when breaking after a
filter operator
Posted by "He Yongqiang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1252?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
He Yongqiang updated HIVE-1252:
-------------------------------
Attachment: hive-1252.1.patch
> Task breaking bug when breaking after a filter operator
> -------------------------------------------------------
>
> Key: HIVE-1252
> URL: https://issues.apache.org/jira/browse/HIVE-1252
> Project: Hadoop Hive
> Issue Type: Bug
> Reporter: He Yongqiang
> Assignee: He Yongqiang
> Fix For: 0.6.0
>
> Attachments: hive-1252.1.patch
>
>
> The plan for this query has a bug,
> SELECT f.key, g.value FROM srcpart f JOIN srcpart m ON( f.key = m.key AND f.ds='2008-04-08' AND m.ds='2008-04-08' ) JOIN srcpart g ON(g.value = m.value AND g.ds='2008-04-08' AND m.ds='2008-04-08');
> The first file sink operator's table desc contains all columns.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.