Return-Path: X-Original-To: apmail-hive-commits-archive@www.apache.org Delivered-To: apmail-hive-commits-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id DCDD210FA4 for ; Fri, 30 May 2014 17:39:03 +0000 (UTC) Received: (qmail 15679 invoked by uid 500); 30 May 2014 17:39:01 -0000 Delivered-To: apmail-hive-commits-archive@hive.apache.org Received: (qmail 15548 invoked by uid 500); 30 May 2014 17:39:01 -0000 Mailing-List: contact commits-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: hive-dev@hive.apache.org Delivered-To: mailing list commits@hive.apache.org Received: (qmail 15457 invoked by uid 99); 30 May 2014 17:39:01 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 30 May 2014 17:39:01 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO eris.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 30 May 2014 17:38:59 +0000 Received: from eris.apache.org (localhost [127.0.0.1]) by eris.apache.org (Postfix) with ESMTP id EADAA2388C7C; Fri, 30 May 2014 17:37:38 +0000 (UTC) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r1598678 [26/31] - in /hive/trunk: cli/src/java/org/apache/hadoop/hive/cli/ common/src/java/org/apache/hadoop/hive/common/io/ itests/util/src/main/java/org/apache/hadoop/hive/ql/ ql/src/java/org/apache/hadoop/hive/ql/ ql/src/java/org/apache... Date: Fri, 30 May 2014 17:37:15 -0000 To: commits@hive.apache.org From: hashutosh@apache.org X-Mailer: svnmailer-1.0.9 Message-Id: <20140530173738.EADAA2388C7C@eris.apache.org> X-Virus-Checked: Checked by ClamAV on apache.org Modified: hive/trunk/ql/src/test/results/clientpositive/orc_split_elimination.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/orc_split_elimination.q.out?rev=1598678&r1=1598677&r2=1598678&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/orc_split_elimination.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/orc_split_elimination.q.out Fri May 30 17:37:05 2014 @@ -1,7 +1,11 @@ -PREHOOK: query: create table orc_split_elim (userid bigint, string1 string, subtype double, decimal1 decimal, ts timestamp) stored as orc +PREHOOK: query: -- SORT_QUERY_RESULTS + +create table orc_split_elim (userid bigint, string1 string, subtype double, decimal1 decimal, ts timestamp) stored as orc PREHOOK: type: CREATETABLE PREHOOK: Output: database:default -POSTHOOK: query: create table orc_split_elim (userid bigint, string1 string, subtype double, decimal1 decimal, ts timestamp) stored as orc +POSTHOOK: query: -- SORT_QUERY_RESULTS + +create table orc_split_elim (userid bigint, string1 string, subtype double, decimal1 decimal, ts timestamp) stored as orc POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@orc_split_elim @@ -130,134 +134,134 @@ POSTHOOK: Input: default@orc_split_elim #### A masked pattern was here #### 0 PREHOOK: query: -- 5 mappers -select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=2 order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=2 PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim #### A masked pattern was here #### POSTHOOK: query: -- 5 mappers -select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=2 order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=2 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim #### A masked pattern was here #### 2 foo 0.8 1 1969-12-31 16:00:00 PREHOOK: query: -- 1 mapper -select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=2 order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=2 PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim #### A masked pattern was here #### POSTHOOK: query: -- 1 mapper -select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=2 order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=2 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim #### A masked pattern was here #### 2 foo 0.8 1 1969-12-31 16:00:00 PREHOOK: query: -- 5 mappers -select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=5 order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=5 PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim #### A masked pattern was here #### POSTHOOK: query: -- 5 mappers -select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=5 order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=5 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim #### A masked pattern was here #### 2 foo 0.8 1 1969-12-31 16:00:00 5 eat 0.8 6 1969-12-31 16:00:20 PREHOOK: query: -- 2 mappers -select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=5 order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=5 PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim #### A masked pattern was here #### POSTHOOK: query: -- 2 mappers -select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=5 order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=5 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim #### A masked pattern was here #### 2 foo 0.8 1 1969-12-31 16:00:00 5 eat 0.8 6 1969-12-31 16:00:20 PREHOOK: query: -- 5 mappers -select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=13 order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=13 PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim #### A masked pattern was here #### POSTHOOK: query: -- 5 mappers -select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=13 order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=13 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim #### A masked pattern was here #### +13 bar 80.0 2 1969-12-31 16:00:05 2 foo 0.8 1 1969-12-31 16:00:00 5 eat 0.8 6 1969-12-31 16:00:20 -13 bar 80.0 2 1969-12-31 16:00:05 PREHOOK: query: -- 3 mappers -select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=13 order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=13 PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim #### A masked pattern was here #### POSTHOOK: query: -- 3 mappers -select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=13 order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=13 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim #### A masked pattern was here #### +13 bar 80.0 2 1969-12-31 16:00:05 2 foo 0.8 1 1969-12-31 16:00:00 5 eat 0.8 6 1969-12-31 16:00:20 -13 bar 80.0 2 1969-12-31 16:00:05 PREHOOK: query: -- 5 mappers -select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=29 order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=29 PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim #### A masked pattern was here #### POSTHOOK: query: -- 5 mappers -select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=29 order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=29 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim #### A masked pattern was here #### -2 foo 0.8 1 1969-12-31 16:00:00 -5 eat 0.8 6 1969-12-31 16:00:20 13 bar 80.0 2 1969-12-31 16:00:05 +2 foo 0.8 1 1969-12-31 16:00:00 29 cat 8.0 3 1969-12-31 16:00:10 +5 eat 0.8 6 1969-12-31 16:00:20 PREHOOK: query: -- 4 mappers -select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=29 order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=29 PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim #### A masked pattern was here #### POSTHOOK: query: -- 4 mappers -select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=29 order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=29 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim #### A masked pattern was here #### -2 foo 0.8 1 1969-12-31 16:00:00 -5 eat 0.8 6 1969-12-31 16:00:20 13 bar 80.0 2 1969-12-31 16:00:05 +2 foo 0.8 1 1969-12-31 16:00:00 29 cat 8.0 3 1969-12-31 16:00:10 +5 eat 0.8 6 1969-12-31 16:00:20 PREHOOK: query: -- 5 mappers -select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=70 order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=70 PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim #### A masked pattern was here #### POSTHOOK: query: -- 5 mappers -select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=70 order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=70 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim #### A masked pattern was here #### -2 foo 0.8 1 1969-12-31 16:00:00 -5 eat 0.8 6 1969-12-31 16:00:20 13 bar 80.0 2 1969-12-31 16:00:05 +2 foo 0.8 1 1969-12-31 16:00:00 29 cat 8.0 3 1969-12-31 16:00:10 +5 eat 0.8 6 1969-12-31 16:00:20 70 dog 1.8 4 1969-12-31 16:00:15 PREHOOK: query: -- 5 mappers -select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=70 order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=70 PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim #### A masked pattern was here #### POSTHOOK: query: -- 5 mappers -select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=70 order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=70 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim #### A masked pattern was here #### -2 foo 0.8 1 1969-12-31 16:00:00 -5 eat 0.8 6 1969-12-31 16:00:20 13 bar 80.0 2 1969-12-31 16:00:05 +2 foo 0.8 1 1969-12-31 16:00:00 29 cat 8.0 3 1969-12-31 16:00:10 +5 eat 0.8 6 1969-12-31 16:00:20 70 dog 1.8 4 1969-12-31 16:00:15 PREHOOK: query: -- partitioned table create table orc_split_elim_part (userid bigint, string1 string, subtype double, decimal1 decimal, ts timestamp) partitioned by (country string, year int) stored as orc @@ -299,14 +303,14 @@ POSTHOOK: type: LOAD #### A masked pattern was here #### POSTHOOK: Output: default@orc_split_elim_part@country=us/year=2001 PREHOOK: query: -- 10 mapper - no split elimination -select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and country='us'order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and country='us' PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim_part PREHOOK: Input: default@orc_split_elim_part@country=us/year=2000 PREHOOK: Input: default@orc_split_elim_part@country=us/year=2001 #### A masked pattern was here #### POSTHOOK: query: -- 10 mapper - no split elimination -select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and country='us'order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and country='us' POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim_part POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2000 @@ -315,14 +319,14 @@ POSTHOOK: Input: default@orc_split_elim_ 2 foo 0.8 1 1969-12-31 16:00:00 2 foo 0.8 1 1969-12-31 16:00:00 PREHOOK: query: -- 2 mapper - split elimination -select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and country='us' order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and country='us' PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim_part PREHOOK: Input: default@orc_split_elim_part@country=us/year=2000 PREHOOK: Input: default@orc_split_elim_part@country=us/year=2001 #### A masked pattern was here #### POSTHOOK: query: -- 2 mapper - split elimination -select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and country='us' order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and country='us' POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim_part POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2000 @@ -331,14 +335,14 @@ POSTHOOK: Input: default@orc_split_elim_ 2 foo 0.8 1 1969-12-31 16:00:00 2 foo 0.8 1 1969-12-31 16:00:00 PREHOOK: query: -- 10 mapper - no split elimination -select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and country='us' and (year=2000 or year=2001) order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and country='us' and (year=2000 or year=2001) PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim_part PREHOOK: Input: default@orc_split_elim_part@country=us/year=2000 PREHOOK: Input: default@orc_split_elim_part@country=us/year=2001 #### A masked pattern was here #### POSTHOOK: query: -- 10 mapper - no split elimination -select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and country='us' and (year=2000 or year=2001) order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and country='us' and (year=2000 or year=2001) POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim_part POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2000 @@ -347,14 +351,14 @@ POSTHOOK: Input: default@orc_split_elim_ 2 foo 0.8 1 1969-12-31 16:00:00 2 foo 0.8 1 1969-12-31 16:00:00 PREHOOK: query: -- 2 mapper - split elimination -select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and country='us' and (year=2000 or year=2001) order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and country='us' and (year=2000 or year=2001) PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim_part PREHOOK: Input: default@orc_split_elim_part@country=us/year=2000 PREHOOK: Input: default@orc_split_elim_part@country=us/year=2001 #### A masked pattern was here #### POSTHOOK: query: -- 2 mapper - split elimination -select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and country='us' and (year=2000 or year=2001) order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and country='us' and (year=2000 or year=2001) POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim_part POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2000 @@ -363,40 +367,40 @@ POSTHOOK: Input: default@orc_split_elim_ 2 foo 0.8 1 1969-12-31 16:00:00 2 foo 0.8 1 1969-12-31 16:00:00 PREHOOK: query: -- 10 mapper - no split elimination -select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and country='us' and year=2000 order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and country='us' and year=2000 PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim_part PREHOOK: Input: default@orc_split_elim_part@country=us/year=2000 #### A masked pattern was here #### POSTHOOK: query: -- 10 mapper - no split elimination -select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and country='us' and year=2000 order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and country='us' and year=2000 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim_part POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2000 #### A masked pattern was here #### 2 foo 0.8 1 1969-12-31 16:00:00 PREHOOK: query: -- 1 mapper - split elimination -select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and country='us' and year=2000 order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and country='us' and year=2000 PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim_part PREHOOK: Input: default@orc_split_elim_part@country=us/year=2000 #### A masked pattern was here #### POSTHOOK: query: -- 1 mapper - split elimination -select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and country='us' and year=2000 order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and country='us' and year=2000 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim_part POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2000 #### A masked pattern was here #### 2 foo 0.8 1 1969-12-31 16:00:00 PREHOOK: query: -- 10 mapper - no split elimination -select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and country='us' order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and country='us' PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim_part PREHOOK: Input: default@orc_split_elim_part@country=us/year=2000 PREHOOK: Input: default@orc_split_elim_part@country=us/year=2001 #### A masked pattern was here #### POSTHOOK: query: -- 10 mapper - no split elimination -select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and country='us' order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and country='us' POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim_part POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2000 @@ -407,14 +411,14 @@ POSTHOOK: Input: default@orc_split_elim_ 5 eat 0.8 6 1969-12-31 16:00:20 5 eat 0.8 6 1969-12-31 16:00:20 PREHOOK: query: -- 4 mapper - split elimination -select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and country='us' order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and country='us' PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim_part PREHOOK: Input: default@orc_split_elim_part@country=us/year=2000 PREHOOK: Input: default@orc_split_elim_part@country=us/year=2001 #### A masked pattern was here #### POSTHOOK: query: -- 4 mapper - split elimination -select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and country='us' order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and country='us' POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim_part POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2000 @@ -425,14 +429,14 @@ POSTHOOK: Input: default@orc_split_elim_ 5 eat 0.8 6 1969-12-31 16:00:20 5 eat 0.8 6 1969-12-31 16:00:20 PREHOOK: query: -- 10 mapper - no split elimination -select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and country='us' and (year=2000 or year=2001) order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and country='us' and (year=2000 or year=2001) PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim_part PREHOOK: Input: default@orc_split_elim_part@country=us/year=2000 PREHOOK: Input: default@orc_split_elim_part@country=us/year=2001 #### A masked pattern was here #### POSTHOOK: query: -- 10 mapper - no split elimination -select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and country='us' and (year=2000 or year=2001) order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and country='us' and (year=2000 or year=2001) POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim_part POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2000 @@ -443,14 +447,14 @@ POSTHOOK: Input: default@orc_split_elim_ 5 eat 0.8 6 1969-12-31 16:00:20 5 eat 0.8 6 1969-12-31 16:00:20 PREHOOK: query: -- 4 mapper - split elimination -select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and country='us' and (year=2000 or year=2001) order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and country='us' and (year=2000 or year=2001) PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim_part PREHOOK: Input: default@orc_split_elim_part@country=us/year=2000 PREHOOK: Input: default@orc_split_elim_part@country=us/year=2001 #### A masked pattern was here #### POSTHOOK: query: -- 4 mapper - split elimination -select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and country='us' and (year=2000 or year=2001) order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and country='us' and (year=2000 or year=2001) POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim_part POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2000 @@ -461,13 +465,13 @@ POSTHOOK: Input: default@orc_split_elim_ 5 eat 0.8 6 1969-12-31 16:00:20 5 eat 0.8 6 1969-12-31 16:00:20 PREHOOK: query: -- 10 mapper - no split elimination -select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and country='us' and year=2000 order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and country='us' and year=2000 PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim_part PREHOOK: Input: default@orc_split_elim_part@country=us/year=2000 #### A masked pattern was here #### POSTHOOK: query: -- 10 mapper - no split elimination -select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and country='us' and year=2000 order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and country='us' and year=2000 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim_part POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2000 @@ -475,13 +479,13 @@ POSTHOOK: Input: default@orc_split_elim_ 2 foo 0.8 1 1969-12-31 16:00:00 5 eat 0.8 6 1969-12-31 16:00:20 PREHOOK: query: -- 2 mapper - split elimination -select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and country='us' and year=2000 order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and country='us' and year=2000 PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim_part PREHOOK: Input: default@orc_split_elim_part@country=us/year=2000 #### A masked pattern was here #### POSTHOOK: query: -- 2 mapper - split elimination -select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and country='us' and year=2000 order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and country='us' and year=2000 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim_part POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2000 @@ -489,38 +493,38 @@ POSTHOOK: Input: default@orc_split_elim_ 2 foo 0.8 1 1969-12-31 16:00:00 5 eat 0.8 6 1969-12-31 16:00:20 PREHOOK: query: -- 0 mapper - no split elimination -select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=70 and country='in' order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=70 and country='in' PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim_part #### A masked pattern was here #### POSTHOOK: query: -- 0 mapper - no split elimination -select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=70 and country='in' order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=70 and country='in' POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim_part #### A masked pattern was here #### -PREHOOK: query: select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=70 and country='us' and year=2002 order by userid +PREHOOK: query: select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=70 and country='us' and year=2002 PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim_part #### A masked pattern was here #### -POSTHOOK: query: select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=70 and country='us' and year=2002 order by userid +POSTHOOK: query: select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=70 and country='us' and year=2002 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim_part #### A masked pattern was here #### PREHOOK: query: -- 0 mapper - split elimination -select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=70 and country='in' order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=70 and country='in' PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim_part #### A masked pattern was here #### POSTHOOK: query: -- 0 mapper - split elimination -select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=70 and country='in' order by userid +select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=70 and country='in' POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim_part #### A masked pattern was here #### -PREHOOK: query: select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=70 and country='us' and year=2002 order by userid +PREHOOK: query: select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=70 and country='us' and year=2002 PREHOOK: type: QUERY PREHOOK: Input: default@orc_split_elim_part #### A masked pattern was here #### -POSTHOOK: query: select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=70 and country='us' and year=2002 order by userid +POSTHOOK: query: select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=70 and country='us' and year=2002 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_split_elim_part #### A masked pattern was here #### Modified: hive/trunk/ql/src/test/results/clientpositive/parallel.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/parallel.q.out?rev=1598678&r1=1598677&r2=1598678&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/parallel.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/parallel.q.out Fri May 30 17:37:05 2014 @@ -1,7 +1,11 @@ -PREHOOK: query: create table if not exists src_a like src +PREHOOK: query: -- SORT_QUERY_RESULTS + +create table if not exists src_a like src PREHOOK: type: CREATETABLE PREHOOK: Output: database:default -POSTHOOK: query: create table if not exists src_a like src +POSTHOOK: query: -- SORT_QUERY_RESULTS + +create table if not exists src_a like src POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@src_a @@ -159,11 +163,11 @@ POSTHOOK: Lineage: src_a.key SIMPLE [(sr POSTHOOK: Lineage: src_a.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: src_b.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: src_b.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: select * from src_a order by key, value +PREHOOK: query: select * from src_a PREHOOK: type: QUERY PREHOOK: Input: default@src_a #### A masked pattern was here #### -POSTHOOK: query: select * from src_a order by key, value +POSTHOOK: query: select * from src_a POSTHOOK: type: QUERY POSTHOOK: Input: default@src_a #### A masked pattern was here #### @@ -476,11 +480,11 @@ POSTHOOK: Input: default@src_a 96 val_96 97 val_97 98 val_98 -PREHOOK: query: select * from src_b order by key, value +PREHOOK: query: select * from src_b PREHOOK: type: QUERY PREHOOK: Input: default@src_b #### A masked pattern was here #### -POSTHOOK: query: select * from src_b order by key, value +POSTHOOK: query: select * from src_b POSTHOOK: type: QUERY POSTHOOK: Input: default@src_b #### A masked pattern was here #### @@ -811,11 +815,11 @@ POSTHOOK: Lineage: src_a.key SIMPLE [(sr POSTHOOK: Lineage: src_a.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: src_b.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: src_b.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: select * from src_a order by key, value +PREHOOK: query: select * from src_a PREHOOK: type: QUERY PREHOOK: Input: default@src_a #### A masked pattern was here #### -POSTHOOK: query: select * from src_a order by key, value +POSTHOOK: query: select * from src_a POSTHOOK: type: QUERY POSTHOOK: Input: default@src_a #### A masked pattern was here #### @@ -1128,11 +1132,11 @@ POSTHOOK: Input: default@src_a 96 val_96 97 val_97 98 val_98 -PREHOOK: query: select * from src_b order by key, value +PREHOOK: query: select * from src_b PREHOOK: type: QUERY PREHOOK: Input: default@src_b #### A masked pattern was here #### -POSTHOOK: query: select * from src_b order by key, value +POSTHOOK: query: select * from src_b POSTHOOK: type: QUERY POSTHOOK: Input: default@src_b #### A masked pattern was here #### Modified: hive/trunk/ql/src/test/results/clientpositive/parquet_partitioned.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/parquet_partitioned.q.out?rev=1598678&r1=1598677&r2=1598678&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/parquet_partitioned.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/parquet_partitioned.q.out Fri May 30 17:37:05 2014 @@ -1,6 +1,10 @@ -PREHOOK: query: DROP TABLE parquet_partitioned_staging +PREHOOK: query: -- SORT_QUERY_RESULTS + +DROP TABLE parquet_partitioned_staging PREHOOK: type: DROPTABLE -POSTHOOK: query: DROP TABLE parquet_partitioned_staging +POSTHOOK: query: -- SORT_QUERY_RESULTS + +DROP TABLE parquet_partitioned_staging POSTHOOK: type: DROPTABLE PREHOOK: query: DROP TABLE parquet_partitioned PREHOOK: type: DROPTABLE @@ -106,13 +110,13 @@ POSTHOOK: Lineage: parquet_partitioned P POSTHOOK: Lineage: parquet_partitioned PARTITION(part=part1).str SIMPLE [(parquet_partitioned_staging)parquet_partitioned_staging.FieldSchema(name:str, type:string, comment:null), ] POSTHOOK: Lineage: parquet_partitioned PARTITION(part=part2).id SIMPLE [(parquet_partitioned_staging)parquet_partitioned_staging.FieldSchema(name:id, type:int, comment:null), ] POSTHOOK: Lineage: parquet_partitioned PARTITION(part=part2).str SIMPLE [(parquet_partitioned_staging)parquet_partitioned_staging.FieldSchema(name:str, type:string, comment:null), ] -PREHOOK: query: SELECT * FROM parquet_partitioned ORDER BY id, str +PREHOOK: query: SELECT * FROM parquet_partitioned PREHOOK: type: QUERY PREHOOK: Input: default@parquet_partitioned PREHOOK: Input: default@parquet_partitioned@part=part1 PREHOOK: Input: default@parquet_partitioned@part=part2 #### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM parquet_partitioned ORDER BY id, str +POSTHOOK: query: SELECT * FROM parquet_partitioned POSTHOOK: type: QUERY POSTHOOK: Input: default@parquet_partitioned POSTHOOK: Input: default@parquet_partitioned@part=part1 @@ -135,13 +139,13 @@ POSTHOOK: Input: default@parquet_partiti #### A masked pattern was here #### part1 1 part2 2 -PREHOOK: query: SELECT * FROM parquet_partitioned ORDER BY id, str +PREHOOK: query: SELECT * FROM parquet_partitioned PREHOOK: type: QUERY PREHOOK: Input: default@parquet_partitioned PREHOOK: Input: default@parquet_partitioned@part=part1 PREHOOK: Input: default@parquet_partitioned@part=part2 #### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM parquet_partitioned ORDER BY id, str +POSTHOOK: query: SELECT * FROM parquet_partitioned POSTHOOK: type: QUERY POSTHOOK: Input: default@parquet_partitioned POSTHOOK: Input: default@parquet_partitioned@part=part1