[HIVE-2884] When "distinct" is used in from of STDDEV, the statement fails with a Java exception error

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: 0.7.1
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Mauro Cazzari
• Created: 20/Mar/12 18:06
• Updated: 26/May/12 01:44
• Resolved: 26/May/12 01:44

Description

Given the following statement:

select distinct STDDEV_SAMP(TXT_1.`age`) as AgeAlias,
STDDEV_SAMP(TXT_1.`weight`) as WeightAlias
from `CLASS` TXT_1;

Hive generates a Java SQL exception error upon execution. If the "distinct" is removed, the statement runs fine.