Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 89650200C41 for ; Fri, 10 Mar 2017 00:23:45 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 88015160B75; Thu, 9 Mar 2017 23:23:45 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 85A12160B8A for ; Fri, 10 Mar 2017 00:23:44 +0100 (CET) Received: (qmail 83021 invoked by uid 500); 9 Mar 2017 23:23:43 -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 83012 invoked by uid 99); 9 Mar 2017 23:23:43 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 09 Mar 2017 23:23:43 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id 52A2EC5B84 for ; Thu, 9 Mar 2017 23:23:43 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.653 X-Spam-Level: ** X-Spam-Status: No, score=2.653 tagged_above=-999 required=6.31 tests=[KAM_BADIPHTTP=2, NORMAL_HTTP_TO_IP=0.001, RP_MATCHES_RCVD=-0.001, SPF_NEUTRAL=0.652, URIBL_BLOCKED=0.001] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id Wnchd2tsUZNd for ; Thu, 9 Mar 2017 23:23:40 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTP id 0B08761E2B for ; Thu, 9 Mar 2017 23:23:40 +0000 (UTC) Received: from jira-lw-us.apache.org (unknown [207.244.88.139]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id D510CE095F for ; Thu, 9 Mar 2017 23:23:38 +0000 (UTC) Received: from jira-lw-us.apache.org (localhost [127.0.0.1]) by jira-lw-us.apache.org (ASF Mail Server at jira-lw-us.apache.org) with ESMTP id 2BB9A243AE for ; Thu, 9 Mar 2017 23:23:38 +0000 (UTC) Date: Thu, 9 Mar 2017 23:23:38 +0000 (UTC) From: "Hive QA (JIRA)" To: issues@hive.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (HIVE-15160) Can't order by an unselected column MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Thu, 09 Mar 2017 23:23:45 -0000 [ https://issues.apache.org/jira/browse/HIVE-15160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15904054#comment-15904054 ] Hive QA commented on HIVE-15160: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12857103/HIVE-15160.09.patch {color:green}SUCCESS:{color} +1 due to 2 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 141 failed/errored test(s), 10338 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestAccumuloCliDriver.testCliDriver[accumulo_queries] (batchId=221) org.apache.hadoop.hive.cli.TestBlobstoreCliDriver.testCliDriver[write_final_output_blobstore] (batchId=233) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[auto_join_without_localtask] (batchId=1) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[cbo_SortUnionTransposeRule] (batchId=15) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[constant_prop_3] (batchId=40) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[cp_sel] (batchId=57) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[decimal_udf] (batchId=9) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[druid_basic2] (batchId=10) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[dynamic_rdd_cache] (batchId=50) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby2_limit] (batchId=9) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby_grouping_sets_grouping] (batchId=3) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[limit_pushdown2] (batchId=15) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[nested_column_pruning] (batchId=31) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[order3] (batchId=59) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[parquet_types_non_dictionary_encoding_vectorization] (batchId=78) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[parquet_types_vectorization] (batchId=13) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[pcr] (batchId=55) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[pointlookup2] (batchId=75) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[pointlookup3] (batchId=6) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[ppd_udf_case] (batchId=40) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[ppd_vc] (batchId=77) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[regex_col] (batchId=15) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_cast_constant] (batchId=8) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_char_2] (batchId=64) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_coalesce] (batchId=10) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_date_1] (batchId=20) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_decimal_round] (batchId=33) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_groupby_reduce] (batchId=52) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_interval_1] (batchId=15) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_interval_arithmetic] (batchId=4) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_mr_diff_schema_alias] (batchId=59) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_orderby_5] (batchId=39) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_reduce_groupby_decimal] (batchId=30) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vectorization_13] (batchId=46) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vectorization_14] (batchId=14) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vectorization_15] (batchId=60) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vectorization_limit] (batchId=34) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vectorized_parquet_types] (batchId=61) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[view_alias] (batchId=76) org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[view_cbo] (batchId=63) org.apache.hadoop.hive.cli.TestHBaseCliDriver.testCliDriver[hbase_queries] (batchId=91) org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[dynamic_partition_pruning_2] (batchId=137) org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[explainuser_2] (batchId=138) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[bucket_groupby] (batchId=156) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[cbo_gby] (batchId=148) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[cbo_limit] (batchId=156) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[cbo_rp_gby] (batchId=152) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[cbo_rp_limit] (batchId=149) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[cbo_rp_semijoin] (batchId=141) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[cbo_semijoin] (batchId=147) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[explainuser_1] (batchId=146) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[limit_join_transpose] (batchId=143) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[limit_pushdown3] (batchId=145) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[limit_pushdown] (batchId=152) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[mrr] (batchId=142) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[offset_limit] (batchId=147) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[offset_limit_ppd_optimizer] (batchId=152) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[selectDistinctStar] (batchId=153) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[special_character_in_tabnames_1] (batchId=148) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_between_in] (batchId=150) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_cast_constant] (batchId=141) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_char_2] (batchId=152) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_coalesce] (batchId=141) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_date_1] (batchId=143) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_decimal_2] (batchId=146) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_decimal_round] (batchId=146) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_decimal_udf] (batchId=156) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_groupby_reduce] (batchId=150) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_interval_1] (batchId=142) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_interval_arithmetic] (batchId=140) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_mr_diff_schema_alias] (batchId=152) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_orderby_5] (batchId=147) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_reduce_groupby_decimal] (batchId=146) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vectorization_0] (batchId=155) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vectorization_13] (batchId=149) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vectorization_14] (batchId=142) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vectorization_15] (batchId=152) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vectorization_short_regress] (batchId=149) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vectorized_parquet_types] (batchId=152) org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[vectorization_limit] (batchId=94) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query14] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query15] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query17] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query18] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query19] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query20] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query22] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query25] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query26] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query27] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query29] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query31] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query36] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query37] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query39] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query3] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query40] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query42] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query43] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query50] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query52] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query54] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query55] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query58] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query5] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query60] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query64] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query66] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query69] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query70] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query71] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query72] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query75] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query76] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query7] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query80] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query81] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query82] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query85] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query86] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query89] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query8] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query91] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query93] (batchId=225) org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query98] (batchId=225) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[auto_join_without_localtask] (batchId=96) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[cbo_gby] (batchId=115) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[cbo_limit] (batchId=134) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[cbo_semijoin] (batchId=112) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[dynamic_rdd_cache] (batchId=119) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[limit_pushdown2] (batchId=103) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[limit_pushdown] (batchId=125) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[pcr] (batchId=121) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[vector_between_in] (batchId=120) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[vector_cast_constant] (batchId=100) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[vector_orderby_5] (batchId=113) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[vectorization_0] (batchId=131) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[vectorization_13] (batchId=117) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[vectorization_14] (batchId=102) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[vectorization_15] (batchId=123) org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[vectorization_short_regress] (batchId=116) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/4055/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/4055/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-4055/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 141 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12857103 - PreCommit-HIVE-Build > Can't order by an unselected column > ----------------------------------- > > Key: HIVE-15160 > URL: https://issues.apache.org/jira/browse/HIVE-15160 > Project: Hive > Issue Type: Bug > Reporter: Pengcheng Xiong > Assignee: Pengcheng Xiong > Attachments: HIVE-15160.01.patch, HIVE-15160.02.patch, HIVE-15160.04.patch, HIVE-15160.05.patch, HIVE-15160.06.patch, HIVE-15160.07.patch, HIVE-15160.08.patch, HIVE-15160.09.patch > > > If a grouping key hasn't been selected, Hive complains. For comparison, Postgres does not. > Example. Notice i_item_id is not selected: > {code} > select i_item_desc > ,i_category > ,i_class > ,i_current_price > ,sum(cs_ext_sales_price) as itemrevenue > ,sum(cs_ext_sales_price)*100/sum(sum(cs_ext_sales_price)) over > (partition by i_class) as revenueratio > from catalog_sales > ,item > ,date_dim > where cs_item_sk = i_item_sk > and i_category in ('Jewelry', 'Sports', 'Books') > and cs_sold_date_sk = d_date_sk > and d_date between cast('2001-01-12' as date) > and (cast('2001-01-12' as date) + 30 days) > group by i_item_id > ,i_item_desc > ,i_category > ,i_class > ,i_current_price > order by i_category > ,i_class > ,i_item_id > ,i_item_desc > ,revenueratio > limit 100; > {code} -- This message was sent by Atlassian JIRA (v6.3.15#6346)