[HIVE-16851] Scalar subquery with group by missing sq_count_check UDF

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.0.0
• Assignee: Vineet Garg
• Reporter: Vineet Garg
• Created: 07/Jun/17 23:02
• Updated: 22/May/18 23:57
• Resolved: 11/Jun/17 18:53

Description

Query such as

explain  select * from part where p_size > (select max(p_size) from part group by p_type);

is missing sq_count_check UDF which ensures there is at most one row coming from subquery.

This problem was originally reported as part of HIVE-16793

Issue Links

• relates to: HIVE-16793 Scalar sub-query: sq_count_check not required if gby keys are constant