[HIVE-9833] udaf_percentile_approx_23.q fails intermittently

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Component/s: UDF
• Assignee: Unassigned
• Reporter: Wei Zheng
• Created: 03/Mar/15 00:51
• Updated: 18/May/15 20:29
• Resolved: 18/May/15 20:25

Description

For the query below:

select percentile_approx(case when key < 100 then cast('NaN' as double) else key end, 0.5) from bucket

the base test result is 341.5.

But sometimes it returns 342 during QA testing.

It happens randomly.

Issue Links

• is duplicated by: HIVE-4940 udaf_percentile_approx.q is not deterministic
• is duplicated by: HIVE-10059 Make udaf_percentile_approx_23.q test more stable
• is duplicated by: HIVE-10665 Continue to make udaf_percentile_approx_23.q test more stable