Return-Path: X-Original-To: apmail-hive-issues-archive@minotaur.apache.org Delivered-To: apmail-hive-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id D116D17CF4 for ; Tue, 7 Apr 2015 23:42:14 +0000 (UTC) Received: (qmail 92141 invoked by uid 500); 7 Apr 2015 23:42:14 -0000 Delivered-To: apmail-hive-issues-archive@hive.apache.org Received: (qmail 91983 invoked by uid 500); 7 Apr 2015 23:42:14 -0000 Mailing-List: contact issues-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hive.apache.org Delivered-To: mailing list issues@hive.apache.org Received: (qmail 91972 invoked by uid 99); 7 Apr 2015 23:42:14 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 07 Apr 2015 23:42:14 +0000 Date: Tue, 7 Apr 2015 23:42:14 +0000 (UTC) From: "Yongzhi Chen (JIRA)" To: issues@hive.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (HIVE-10160) Give a warning when grouping or ordering by a constant column MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/HIVE-10160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14484356#comment-14484356 ] Yongzhi Chen commented on HIVE-10160: ------------------------------------- The new patch doing following: 1. Only report warning to session console if hive.session.silent is false for in some case clients do not want to see warnings. 2. Always record the warning in hive log. 3. Use more relevant warning messages. 4. Removing new tests for the Minimr tests build errors. > Give a warning when grouping or ordering by a constant column > ------------------------------------------------------------- > > Key: HIVE-10160 > URL: https://issues.apache.org/jira/browse/HIVE-10160 > Project: Hive > Issue Type: Improvement > Components: Query Processor > Reporter: Lefty Leverenz > Assignee: Yongzhi Chen > Priority: Minor > Attachments: HIVE-10160.1.patch, HIVE-10160.3.patch, HIVE-10160.4.patch, HIVE-10160.5.patch > > > To avoid confusion, a warning should be issued when users specify column positions instead of names in a GROUP BY or ORDER BY clause (unless hive.groupby.orderby.position.alias is set to true in Hive 0.11.0 or later). -- This message was sent by Atlassian JIRA (v6.3.4#6332)