You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Zhiyuan Yang (JIRA)" <ji...@apache.org> on 2017/10/25 22:17:00 UTC
[jira] [Comment Edited] (HIVE-17823) Fix subquery Qtest of Hive on
Spark
[ https://issues.apache.org/jira/browse/HIVE-17823?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16219646#comment-16219646 ]
Zhiyuan Yang edited comment on HIVE-17823 at 10/25/17 10:16 PM:
----------------------------------------------------------------
subquery_multi on TestSparkCliDriver seems to generate different output order on different machine. Specifically this query
{code}
select * from part_null where p_size IN (select p_size from part_null) AND p_brand IN (select p_brand from part_null)
{code}
it failed on my local machine (before HIVE-14731 was committed) like this:
{code}
237d236
< 78487 NULL Manufacturer#6 Brand#52 LARGE BRUSHED BRASS 23 MED BAG 1464.48 hely blith
238a238
> 78487 NULL Manufacturer#6 Brand#52 LARGE BRUSHED BRASS 23 MED BAG 1464.48 hely blith
{code}
After I overwrite it with my local result, it failed on Apache jenkins with a similar diff.
was (Author: aplusplus):
subquery_multi on TestSparkCliDriver seems to generate different output order on different machine. Specifically this query
{code}
select * from part_null where p_size IN (select p_size from part_null) AND p_brand IN (select p_brand from part_null)
{code}
it failed on my local machine (before HIVE-14731 was committed) like this:
{code}
237d236
< 78487 NULL Manufacturer#6 Brand#52 LARGE BRUSHED BRASS 23 MED BAG 1464.48 hely blith
238a238
> 78487 NULL Manufacturer#6 Brand#52 LARGE BRUSHED BRASS 23 MED BAG 1464.48 hely blith
{code}
After I overwrite it with my local result, it failed on Apache jenkins.
> Fix subquery Qtest of Hive on Spark
> -----------------------------------
>
> Key: HIVE-17823
> URL: https://issues.apache.org/jira/browse/HIVE-17823
> Project: Hive
> Issue Type: Bug
> Affects Versions: 3.0.0
> Reporter: Dapeng Sun
> Assignee: Dapeng Sun
> Attachments: HIVE-17823.001.patch
>
>
> The JIRA is targeted to fix the Qtest files failures of HoS due to HIVE-17726 introduced subquery fix.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)