Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Mon, 19 Jan 2015 18:09:34 +0000 (UTC)
From: "Pengcheng Xiong (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Message-ID: <JIRA.12595862.1340684100000.117336.1421690974863@Atlassian.JIRA>
In-Reply-To: <JIRA.12595862.1340684100000@Atlassian.JIRA>
References: <JIRA.12595862.1340684100000@Atlassian.JIRA>
 <JIRA.12595862.1340684100665@arcas>
Subject: [jira] [Commented] (HIVE-3199) support select distinct *
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/HIVE-3199?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14282786#comment-14282786 ] 

Pengcheng Xiong commented on HIVE-3199:
---------------------------------------

[~shane.huang], w.r.t. the JIRA HIVE-9194, shall we close this issue? Thanks.

> support select distinct *
> -------------------------
>
>                 Key: HIVE-3199
>                 URL: https://issues.apache.org/jira/browse/HIVE-3199
>             Project: Hive
>          Issue Type: New Feature
>          Components: Query Processor
>    Affects Versions: 0.9.0
>            Reporter: Shane Huang
>         Attachments: HIVE-3199.for0.9.0.patch
>
>
> Error is reported when running query "select distinct * from t". 
> It is a common feature that is better to be supported.
> Did some investigation about this issue. In current implementation "select distinct a,b,c from t" is translated to "select a,b,c from t group by a,b,c". So select distinct * is translated literally to "select * from group by *". But * is not handled properly when processing groupby expressions. 


--
This message was sent by Atlassian JIRA
(v6.3.4#6332)