You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Edward Capriolo (JIRA)" <ji...@apache.org> on 2012/05/26 03:44:23 UTC
[jira] [Commented] (HIVE-2884) When "distinct" is used in from of
STDDEV, the statement fails with a Java exception error
[ https://issues.apache.org/jira/browse/HIVE-2884?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13283870#comment-13283870 ]
Edward Capriolo commented on HIVE-2884:
---------------------------------------
I think this is what you need.
{noformat}
select distinct (STDDEV_SAMP(TXT_1.`age`)) as AgeAlias,
distinct (STDDEV_SAMP(TXT_1.`weight`)) as WeightAlias
from `CLASS` TXT_1;
{noformat}
re open if I am wrong.
> When "distinct" is used in from of STDDEV, the statement fails with a Java exception error
> ------------------------------------------------------------------------------------------
>
> Key: HIVE-2884
> URL: https://issues.apache.org/jira/browse/HIVE-2884
> Project: Hive
> Issue Type: Bug
> Components: SQL
> Affects Versions: 0.7.1
> Reporter: Mauro Cazzari
>
> 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.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira