[
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)
