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 D72FB10B9D for ; Mon, 18 Nov 2013 19:30:42 +0000 (UTC) Received: (qmail 59504 invoked by uid 500); 18 Nov 2013 19:30:42 -0000 Delivered-To: apmail-hive-commits-archive@hive.apache.org Received: (qmail 59417 invoked by uid 500); 18 Nov 2013 19:30:42 -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 59343 invoked by uid 99); 18 Nov 2013 19:30:42 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 18 Nov 2013 19:30:42 +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; Mon, 18 Nov 2013 19:30:22 +0000 Received: from eris.apache.org (localhost [127.0.0.1]) by eris.apache.org (Postfix) with ESMTP id 112F12388C2D; Mon, 18 Nov 2013 19:29:36 +0000 (UTC) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r1543120 [12/16] - in /hive/trunk: common/src/java/org/apache/hadoop/hive/conf/ data/files/ ql/src/java/org/apache/hadoop/hive/ql/ ql/src/java/org/apache/hadoop/hive/ql/exec/ ql/src/java/org/apache/hadoop/hive/ql/optimizer/ ql/src/java/org/... Date: Mon, 18 Nov 2013 19:29:27 -0000 To: commits@hive.apache.org From: rhbutani@apache.org X-Mailer: svnmailer-1.0.9 Message-Id: <20131118192936.112F12388C2D@eris.apache.org> X-Virus-Checked: Checked by ClamAV on apache.org Modified: hive/trunk/ql/src/test/results/clientpositive/groupby_sort_skew_1.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby_sort_skew_1.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/groupby_sort_skew_1.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/groupby_sort_skew_1.q.out Mon Nov 18 19:29:24 2013 @@ -66,12 +66,16 @@ STAGE PLANS: t1 TableScan alias: t1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE GatherStats: false Select Operator expressions: expr: key type: string outputColumnNames: key + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Group By Operator aggregations: expr: count(1) @@ -81,6 +85,8 @@ STAGE PLANS: type: string mode: final outputColumnNames: _col0, _col1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Select Operator expressions: expr: UDFToInteger(_col0) @@ -88,11 +94,15 @@ STAGE PLANS: expr: UDFToInteger(_col1) type: int outputColumnNames: _col0, _col1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 1 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat @@ -410,6 +420,8 @@ STAGE PLANS: t1 TableScan alias: t1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE GatherStats: false Select Operator expressions: @@ -418,6 +430,8 @@ STAGE PLANS: expr: val type: string outputColumnNames: key, val + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Group By Operator aggregations: expr: count(1) @@ -429,6 +443,8 @@ STAGE PLANS: type: string mode: hash outputColumnNames: _col0, _col1, _col2 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Reduce Output Operator key expressions: expr: _col0 @@ -439,6 +455,8 @@ STAGE PLANS: Map-reduce partition columns: expr: rand() type: double + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE tag: -1 value expressions: expr: _col2 @@ -507,6 +525,8 @@ STAGE PLANS: type: string mode: partials outputColumnNames: _col0, _col1, _col2 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 0 @@ -543,6 +563,8 @@ STAGE PLANS: type: string expr: _col1 type: string + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE tag: -1 value expressions: expr: _col2 @@ -585,6 +607,8 @@ STAGE PLANS: type: string mode: final outputColumnNames: _col0, _col1, _col2 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Select Operator expressions: expr: UDFToInteger(_col0) @@ -594,11 +618,15 @@ STAGE PLANS: expr: UDFToInteger(_col2) type: int outputColumnNames: _col0, _col1, _col2 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 1 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat @@ -721,12 +749,16 @@ STAGE PLANS: subq1:t1 TableScan alias: t1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE GatherStats: false Select Operator expressions: expr: key type: string outputColumnNames: _col0 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Group By Operator aggregations: expr: count(1) @@ -736,6 +768,8 @@ STAGE PLANS: type: string mode: final outputColumnNames: _col0, _col1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Select Operator expressions: expr: UDFToInteger(_col0) @@ -743,11 +777,15 @@ STAGE PLANS: expr: UDFToInteger(_col1) type: int outputColumnNames: _col0, _col1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 1 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat @@ -1115,12 +1153,16 @@ STAGE PLANS: subq1:t1 TableScan alias: t1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE GatherStats: false Select Operator expressions: expr: key type: string outputColumnNames: _col0 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Group By Operator aggregations: expr: count(1) @@ -1130,6 +1172,8 @@ STAGE PLANS: type: string mode: final outputColumnNames: _col0, _col1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Select Operator expressions: expr: UDFToInteger(_col0) @@ -1137,11 +1181,15 @@ STAGE PLANS: expr: UDFToInteger(_col1) type: int outputColumnNames: _col0, _col1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 1 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat @@ -1533,12 +1581,16 @@ STAGE PLANS: t1 TableScan alias: t1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE GatherStats: false Select Operator expressions: expr: key type: string outputColumnNames: key + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Group By Operator aggregations: expr: count(1) @@ -1550,6 +1602,8 @@ STAGE PLANS: type: string mode: final outputColumnNames: _col0, _col1, _col2 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Select Operator expressions: expr: _col0 @@ -1559,11 +1613,15 @@ STAGE PLANS: expr: UDFToInteger(_col2) type: int outputColumnNames: _col0, _col1, _col2 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 1 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat @@ -1921,6 +1979,8 @@ STAGE PLANS: t1 TableScan alias: t1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE GatherStats: false Select Operator expressions: @@ -1929,6 +1989,8 @@ STAGE PLANS: expr: val type: string outputColumnNames: key, val + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Group By Operator aggregations: expr: count(1) @@ -1942,6 +2004,8 @@ STAGE PLANS: type: string mode: hash outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Reduce Output Operator key expressions: expr: _col0 @@ -1954,6 +2018,8 @@ STAGE PLANS: Map-reduce partition columns: expr: rand() type: double + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE tag: -1 value expressions: expr: _col3 @@ -2024,6 +2090,8 @@ STAGE PLANS: type: string mode: partials outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 0 @@ -2064,6 +2132,8 @@ STAGE PLANS: type: int expr: _col2 type: string + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE tag: -1 value expressions: expr: _col3 @@ -2108,6 +2178,8 @@ STAGE PLANS: type: string mode: final outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Select Operator expressions: expr: UDFToInteger(_col0) @@ -2119,11 +2191,15 @@ STAGE PLANS: expr: UDFToInteger(_col3) type: int outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 1 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat @@ -2275,12 +2351,16 @@ STAGE PLANS: t1 TableScan alias: t1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE GatherStats: false Select Operator expressions: expr: key type: string outputColumnNames: key + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Group By Operator aggregations: expr: count(1) @@ -2292,6 +2372,8 @@ STAGE PLANS: type: double mode: hash outputColumnNames: _col0, _col1, _col2 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Reduce Output Operator key expressions: expr: _col0 @@ -2302,6 +2384,8 @@ STAGE PLANS: Map-reduce partition columns: expr: rand() type: double + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE tag: -1 value expressions: expr: _col2 @@ -2370,6 +2454,8 @@ STAGE PLANS: type: double mode: partials outputColumnNames: _col0, _col1, _col2 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 0 @@ -2406,6 +2492,8 @@ STAGE PLANS: type: string expr: _col1 type: double + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE tag: -1 value expressions: expr: _col2 @@ -2448,6 +2536,8 @@ STAGE PLANS: type: double mode: final outputColumnNames: _col0, _col1, _col2 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Select Operator expressions: expr: UDFToInteger(_col0) @@ -2457,11 +2547,15 @@ STAGE PLANS: expr: UDFToInteger(_col2) type: int outputColumnNames: _col0, _col1, _col2 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 1 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat @@ -2641,12 +2735,16 @@ STAGE PLANS: subq1:t1 TableScan alias: t1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE GatherStats: false Select Operator expressions: expr: key type: string outputColumnNames: key + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Group By Operator aggregations: expr: count(1) @@ -2656,6 +2754,8 @@ STAGE PLANS: type: string mode: final outputColumnNames: _col0, _col1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Select Operator expressions: expr: _col0 @@ -2663,6 +2763,8 @@ STAGE PLANS: expr: _col1 type: bigint outputColumnNames: _col0, _col1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Group By Operator aggregations: expr: sum(_col1) @@ -2672,6 +2774,8 @@ STAGE PLANS: type: double mode: hash outputColumnNames: _col0, _col1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Reduce Output Operator key expressions: expr: _col0 @@ -2680,6 +2784,8 @@ STAGE PLANS: Map-reduce partition columns: expr: rand() type: double + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE tag: -1 value expressions: expr: _col1 @@ -2746,6 +2852,8 @@ STAGE PLANS: type: double mode: partials outputColumnNames: _col0, _col1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 0 @@ -2778,6 +2886,8 @@ STAGE PLANS: Map-reduce partition columns: expr: _col0 type: double + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE tag: -1 value expressions: expr: _col1 @@ -2818,6 +2928,8 @@ STAGE PLANS: type: double mode: final outputColumnNames: _col0, _col1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Select Operator expressions: expr: UDFToInteger(_col0) @@ -2825,11 +2937,15 @@ STAGE PLANS: expr: UDFToInteger(_col1) type: int outputColumnNames: _col0, _col1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 1 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat @@ -3021,12 +3137,16 @@ STAGE PLANS: null-subquery1:subq1-subquery1:t1 TableScan alias: t1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE GatherStats: false Select Operator expressions: expr: key type: string outputColumnNames: key + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Group By Operator aggregations: expr: count(1) @@ -3036,6 +3156,8 @@ STAGE PLANS: type: string mode: final outputColumnNames: _col0, _col1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Select Operator expressions: expr: _col0 @@ -3043,7 +3165,11 @@ STAGE PLANS: expr: _col1 type: bigint outputColumnNames: _col0, _col1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Union + Statistics: + numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE Select Operator expressions: expr: UDFToInteger(_col0) @@ -3051,11 +3177,15 @@ STAGE PLANS: expr: UDFToInteger(_col1) type: int outputColumnNames: _col0, _col1 + Statistics: + numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 1 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat @@ -3083,12 +3213,16 @@ STAGE PLANS: null-subquery2:subq1-subquery2:t1 TableScan alias: t1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE GatherStats: false Select Operator expressions: expr: key type: string outputColumnNames: key + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Group By Operator aggregations: expr: count(1) @@ -3098,6 +3232,8 @@ STAGE PLANS: type: string mode: final outputColumnNames: _col0, _col1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Select Operator expressions: expr: _col0 @@ -3105,7 +3241,11 @@ STAGE PLANS: expr: _col1 type: bigint outputColumnNames: _col0, _col1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Union + Statistics: + numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE Select Operator expressions: expr: UDFToInteger(_col0) @@ -3113,11 +3253,15 @@ STAGE PLANS: expr: UDFToInteger(_col1) type: int outputColumnNames: _col0, _col1 + Statistics: + numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 1 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat @@ -3556,12 +3700,16 @@ STAGE PLANS: null-subquery2:subq1-subquery2:t1 TableScan alias: t1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE GatherStats: false Select Operator expressions: expr: key type: string outputColumnNames: key + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Group By Operator aggregations: expr: count(1) @@ -3571,6 +3719,8 @@ STAGE PLANS: type: double mode: hash outputColumnNames: _col0, _col1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Reduce Output Operator key expressions: expr: _col0 @@ -3579,6 +3729,8 @@ STAGE PLANS: Map-reduce partition columns: expr: rand() type: double + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE tag: -1 value expressions: expr: _col1 @@ -3645,6 +3797,8 @@ STAGE PLANS: type: double mode: partials outputColumnNames: _col0, _col1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 0 @@ -3677,6 +3831,8 @@ STAGE PLANS: Map-reduce partition columns: expr: _col0 type: double + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE tag: -1 value expressions: expr: _col1 @@ -3717,6 +3873,8 @@ STAGE PLANS: type: double mode: final outputColumnNames: _col0, _col1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Select Operator expressions: expr: _col0 @@ -3724,6 +3882,8 @@ STAGE PLANS: expr: _col1 type: bigint outputColumnNames: _col0, _col1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 0 @@ -3749,6 +3909,8 @@ STAGE PLANS: TableScan GatherStats: false Union + Statistics: + numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE Select Operator expressions: expr: UDFToInteger(_col0) @@ -3756,11 +3918,15 @@ STAGE PLANS: expr: UDFToInteger(_col1) type: int outputColumnNames: _col0, _col1 + Statistics: + numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 1 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat @@ -3788,12 +3954,16 @@ STAGE PLANS: null-subquery1:subq1-subquery1:t1 TableScan alias: t1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE GatherStats: false Select Operator expressions: expr: key type: string outputColumnNames: key + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Group By Operator aggregations: expr: count(1) @@ -3803,6 +3973,8 @@ STAGE PLANS: type: string mode: final outputColumnNames: _col0, _col1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Select Operator expressions: expr: UDFToDouble(_col0) @@ -3810,7 +3982,11 @@ STAGE PLANS: expr: _col1 type: bigint outputColumnNames: _col0, _col1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Union + Statistics: + numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE Select Operator expressions: expr: UDFToInteger(_col0) @@ -3818,11 +3994,15 @@ STAGE PLANS: expr: UDFToInteger(_col1) type: int outputColumnNames: _col0, _col1 + Statistics: + numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 1 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 12 dataSize: 48 basicStatsState: COMPLETE colStatsState: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat @@ -4281,12 +4461,16 @@ STAGE PLANS: subq1:t1 TableScan alias: t1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE GatherStats: false Select Operator expressions: expr: key type: string outputColumnNames: key + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Group By Operator aggregations: expr: count(1) @@ -4296,6 +4480,8 @@ STAGE PLANS: type: string mode: final outputColumnNames: _col0, _col1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Select Operator expressions: expr: _col0 @@ -4303,6 +4489,8 @@ STAGE PLANS: expr: _col1 type: bigint outputColumnNames: _col0, _col1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Reduce Output Operator key expressions: expr: _col0 @@ -4311,6 +4499,8 @@ STAGE PLANS: Map-reduce partition columns: expr: _col0 type: string + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE tag: 0 value expressions: expr: _col0 @@ -4320,12 +4510,16 @@ STAGE PLANS: subq2:t1 TableScan alias: t1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE GatherStats: false Select Operator expressions: expr: key type: string outputColumnNames: key + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Group By Operator aggregations: expr: count(1) @@ -4335,6 +4529,8 @@ STAGE PLANS: type: string mode: final outputColumnNames: _col0, _col1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Select Operator expressions: expr: _col0 @@ -4342,6 +4538,8 @@ STAGE PLANS: expr: _col1 type: bigint outputColumnNames: _col0, _col1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Reduce Output Operator key expressions: expr: _col0 @@ -4350,6 +4548,8 @@ STAGE PLANS: Map-reduce partition columns: expr: _col0 type: string + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE tag: 1 value expressions: expr: _col1 @@ -4634,6 +4834,8 @@ STAGE PLANS: subq2:t1 TableScan alias: t1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE GatherStats: false Select Operator expressions: @@ -4642,6 +4844,8 @@ STAGE PLANS: expr: val type: string outputColumnNames: key, val + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Group By Operator aggregations: expr: count(1) @@ -4653,6 +4857,8 @@ STAGE PLANS: type: string mode: hash outputColumnNames: _col0, _col1, _col2 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Reduce Output Operator key expressions: expr: _col0 @@ -4663,6 +4869,8 @@ STAGE PLANS: Map-reduce partition columns: expr: rand() type: double + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE tag: -1 value expressions: expr: _col2 @@ -4731,6 +4939,8 @@ STAGE PLANS: type: string mode: partials outputColumnNames: _col0, _col1, _col2 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 0 @@ -4767,6 +4977,8 @@ STAGE PLANS: type: string expr: _col1 type: string + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE tag: -1 value expressions: expr: _col2 @@ -4809,6 +5021,8 @@ STAGE PLANS: type: string mode: final outputColumnNames: _col0, _col1, _col2 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Select Operator expressions: expr: _col0 @@ -4818,6 +5032,8 @@ STAGE PLANS: expr: _col2 type: bigint outputColumnNames: _col0, _col1, _col2 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 0 @@ -4850,6 +5066,8 @@ STAGE PLANS: Map-reduce partition columns: expr: _col0 type: string + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE tag: 1 value expressions: expr: _col0 @@ -4861,12 +5079,16 @@ STAGE PLANS: subq1:t1 TableScan alias: t1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE GatherStats: false Select Operator expressions: expr: key type: string outputColumnNames: key + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Group By Operator aggregations: expr: count(1) @@ -4876,6 +5098,8 @@ STAGE PLANS: type: string mode: final outputColumnNames: _col0, _col1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Select Operator expressions: expr: _col0 @@ -4883,6 +5107,8 @@ STAGE PLANS: expr: _col1 type: bigint outputColumnNames: _col0, _col1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Reduce Output Operator key expressions: expr: _col0 @@ -4891,6 +5117,8 @@ STAGE PLANS: Map-reduce partition columns: expr: _col0 type: string + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE tag: 0 value expressions: expr: _col0 @@ -5152,12 +5380,16 @@ STAGE PLANS: t2 TableScan alias: t2 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE GatherStats: false Select Operator expressions: expr: key type: string outputColumnNames: key + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Group By Operator aggregations: expr: count(1) @@ -5167,6 +5399,8 @@ STAGE PLANS: type: string mode: hash outputColumnNames: _col0, _col1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Reduce Output Operator key expressions: expr: _col0 @@ -5175,6 +5409,8 @@ STAGE PLANS: Map-reduce partition columns: expr: rand() type: double + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE tag: -1 value expressions: expr: _col1 @@ -5241,6 +5477,8 @@ STAGE PLANS: type: string mode: partials outputColumnNames: _col0, _col1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 0 @@ -5273,6 +5511,8 @@ STAGE PLANS: Map-reduce partition columns: expr: _col0 type: string + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE tag: -1 value expressions: expr: _col1 @@ -5313,6 +5553,8 @@ STAGE PLANS: type: string mode: final outputColumnNames: _col0, _col1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Select Operator expressions: expr: UDFToInteger(_col0) @@ -5320,11 +5562,15 @@ STAGE PLANS: expr: UDFToInteger(_col1) type: int outputColumnNames: _col0, _col1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 1 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat @@ -5536,6 +5782,8 @@ STAGE PLANS: t2 TableScan alias: t2 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE GatherStats: false Select Operator expressions: @@ -5544,6 +5792,8 @@ STAGE PLANS: expr: val type: string outputColumnNames: key, val + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Group By Operator aggregations: expr: count(1) @@ -5557,6 +5807,8 @@ STAGE PLANS: type: string mode: final outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Select Operator expressions: expr: UDFToInteger(_col0) @@ -5568,11 +5820,15 @@ STAGE PLANS: expr: UDFToInteger(_col3) type: int outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 1 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat @@ -6069,6 +6325,8 @@ STAGE PLANS: t2 TableScan alias: t2 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE GatherStats: false Select Operator expressions: @@ -6077,6 +6335,8 @@ STAGE PLANS: expr: val type: string outputColumnNames: key, val + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Group By Operator aggregations: expr: count(1) @@ -6092,6 +6352,8 @@ STAGE PLANS: type: int mode: final outputColumnNames: _col0, _col1, _col2, _col3, _col4 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Select Operator expressions: expr: UDFToInteger(_col0) @@ -6105,11 +6367,15 @@ STAGE PLANS: expr: UDFToInteger(_col4) type: int outputColumnNames: _col0, _col1, _col2, _col3, _col4 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 1 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat @@ -6543,6 +6809,8 @@ STAGE PLANS: subq:t2 TableScan alias: t2 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE GatherStats: false Select Operator expressions: @@ -6553,6 +6821,8 @@ STAGE PLANS: expr: val type: string outputColumnNames: _col0, _col1, _col2 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Group By Operator aggregations: expr: count(1) @@ -6566,6 +6836,8 @@ STAGE PLANS: type: string mode: final outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Select Operator expressions: expr: UDFToInteger(_col0) @@ -6577,11 +6849,15 @@ STAGE PLANS: expr: UDFToInteger(_col3) type: int outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 1 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat @@ -7075,6 +7351,8 @@ STAGE PLANS: subq2:subq:t2 TableScan alias: t2 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE GatherStats: false Select Operator expressions: @@ -7085,6 +7363,8 @@ STAGE PLANS: expr: val type: string outputColumnNames: _col0, _col3, _col2 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Group By Operator aggregations: expr: count(1) @@ -7098,6 +7378,8 @@ STAGE PLANS: type: string mode: final outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE Select Operator expressions: expr: UDFToInteger(_col0) @@ -7109,11 +7391,15 @@ STAGE PLANS: expr: UDFToInteger(_col3) type: int outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE File Output Operator compressed: false GlobalTableId: 1 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 6 dataSize: 24 basicStatsState: COMPLETE colStatsState: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat Modified: hive/trunk/ql/src/test/results/clientpositive/input23.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input23.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/input23.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/input23.q.out Mon Nov 18 19:29:24 2013 @@ -18,9 +18,13 @@ STAGE PLANS: a TableScan alias: a + Statistics: + numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE GatherStats: false Reduce Output Operator sort order: + Statistics: + numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE tag: 0 value expressions: expr: key @@ -34,14 +38,20 @@ STAGE PLANS: b TableScan alias: b + Statistics: + numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE GatherStats: false Filter Operator isSamplingPred: false predicate: expr: ((ds = '2008-04-08') and (hr = '14')) type: boolean + Statistics: + numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE Reduce Output Operator sort order: + Statistics: + numRows: 0 dataSize: 0 basicStatsState: NONE colStatsState: NONE tag: 1 value expressions: expr: key Modified: hive/trunk/ql/src/test/results/clientpositive/input42.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input42.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/input42.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/input42.q.out Mon Nov 18 19:29:24 2013 @@ -18,6 +18,8 @@ STAGE PLANS: a TableScan alias: a + Statistics: + numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE GatherStats: false Select Operator expressions: @@ -30,6 +32,8 @@ STAGE PLANS: expr: hr type: string outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: + numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE Reduce Output Operator key expressions: expr: _col0 @@ -37,6 +41,8 @@ STAGE PLANS: expr: _col3 type: string sort order: ++ + Statistics: + numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE tag: -1 value expressions: expr: _col0 @@ -140,11 +146,15 @@ STAGE PLANS: Needs Tagging: false Reduce Operator Tree: Extract + Statistics: + numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE File Output Operator compressed: false GlobalTableId: 0 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat @@ -1198,12 +1208,16 @@ STAGE PLANS: a TableScan alias: a + Statistics: + numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE GatherStats: false Filter Operator isSamplingPred: false predicate: expr: (key < 200) type: boolean + Statistics: + numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE Select Operator expressions: expr: key @@ -1215,6 +1229,8 @@ STAGE PLANS: expr: hr type: string outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: + numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE Reduce Output Operator key expressions: expr: _col0 @@ -1222,6 +1238,8 @@ STAGE PLANS: expr: _col3 type: string sort order: ++ + Statistics: + numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE tag: -1 value expressions: expr: _col0 @@ -1325,11 +1343,15 @@ STAGE PLANS: Needs Tagging: false Reduce Operator Tree: Extract + Statistics: + numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE File Output Operator compressed: false GlobalTableId: 0 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat @@ -1761,12 +1783,16 @@ STAGE PLANS: a TableScan alias: a + Statistics: + numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE GatherStats: false Filter Operator isSamplingPred: false predicate: expr: (rand(100) < 0.1) type: boolean + Statistics: + numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE Select Operator expressions: expr: key @@ -1778,6 +1804,8 @@ STAGE PLANS: expr: hr type: string outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: + numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE Reduce Output Operator key expressions: expr: _col0 @@ -1785,6 +1813,8 @@ STAGE PLANS: expr: _col3 type: string sort order: ++ + Statistics: + numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE tag: -1 value expressions: expr: _col0 @@ -1888,11 +1918,15 @@ STAGE PLANS: Needs Tagging: false Reduce Operator Tree: Extract + Statistics: + numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE File Output Operator compressed: false GlobalTableId: 0 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat Modified: hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out Mon Nov 18 19:29:24 2013 @@ -31,12 +31,16 @@ STAGE PLANS: srcpart TableScan alias: srcpart + Statistics: + numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE GatherStats: false Filter Operator isSamplingPred: false predicate: expr: (key < 100) type: boolean + Statistics: + numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE Select Operator expressions: expr: UDFToInteger(key) @@ -48,11 +52,15 @@ STAGE PLANS: expr: ds type: string outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: + numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE File Output Operator compressed: false GlobalTableId: 1 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat Modified: hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out Mon Nov 18 19:29:24 2013 @@ -45,12 +45,16 @@ STAGE PLANS: srcpart TableScan alias: srcpart + Statistics: + numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE GatherStats: false Filter Operator isSamplingPred: false predicate: expr: ((key < 100) and (ds = '2008-04-08')) type: boolean + Statistics: + numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE Select Operator expressions: expr: UDFToInteger(key) @@ -62,11 +66,15 @@ STAGE PLANS: expr: ds type: string outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: + numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE File Output Operator compressed: false GlobalTableId: 1 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat @@ -91,6 +99,8 @@ STAGE PLANS: predicate: expr: ((key < 100) and (ds = '2008-04-09')) type: boolean + Statistics: + numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE Select Operator expressions: expr: UDFToInteger(key) @@ -102,11 +112,15 @@ STAGE PLANS: expr: ds type: string outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: + numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE File Output Operator compressed: false GlobalTableId: 2 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat Modified: hive/trunk/ql/src/test/results/clientpositive/input_part7.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input_part7.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/input_part7.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/input_part7.q.out Mon Nov 18 19:29:24 2013 @@ -28,12 +28,16 @@ STAGE PLANS: null-subquery1:a-subquery1:x TableScan alias: x + Statistics: + numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE GatherStats: false Filter Operator isSamplingPred: false predicate: expr: (key < 100) type: boolean + Statistics: + numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE Select Operator expressions: expr: key @@ -45,7 +49,11 @@ STAGE PLANS: expr: hr type: string outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: + numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE Union + Statistics: + numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE Select Operator expressions: expr: _col0 @@ -57,6 +65,8 @@ STAGE PLANS: expr: _col3 type: string outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: + numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE Reduce Output Operator key expressions: expr: _col0 @@ -68,6 +78,8 @@ STAGE PLANS: expr: _col3 type: string sort order: ++++ + Statistics: + numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE tag: -1 value expressions: expr: _col0 @@ -81,12 +93,16 @@ STAGE PLANS: null-subquery2:a-subquery2:y TableScan alias: y + Statistics: + numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE GatherStats: false Filter Operator isSamplingPred: false predicate: expr: (key < 100) type: boolean + Statistics: + numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE Select Operator expressions: expr: key @@ -98,7 +114,11 @@ STAGE PLANS: expr: hr type: string outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: + numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE Union + Statistics: + numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE Select Operator expressions: expr: _col0 @@ -110,6 +130,8 @@ STAGE PLANS: expr: _col3 type: string outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: + numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE Reduce Output Operator key expressions: expr: _col0 @@ -121,6 +143,8 @@ STAGE PLANS: expr: _col3 type: string sort order: ++++ + Statistics: + numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE tag: -1 value expressions: expr: _col0 @@ -224,11 +248,15 @@ STAGE PLANS: Needs Tagging: false Reduce Operator Tree: Extract + Statistics: + numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE File Output Operator compressed: false GlobalTableId: 0 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 0 dataSize: 23248 basicStatsState: PARTIAL colStatsState: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat Modified: hive/trunk/ql/src/test/results/clientpositive/input_part9.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input_part9.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/input_part9.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/input_part9.q.out Mon Nov 18 19:29:24 2013 @@ -18,12 +18,16 @@ STAGE PLANS: x TableScan alias: x + Statistics: + numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE GatherStats: false Filter Operator isSamplingPred: false predicate: expr: key is not null type: boolean + Statistics: + numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE Select Operator expressions: expr: key @@ -35,6 +39,8 @@ STAGE PLANS: expr: hr type: string outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: + numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE Reduce Output Operator key expressions: expr: _col0 @@ -42,6 +48,8 @@ STAGE PLANS: expr: _col3 type: string sort order: ++ + Statistics: + numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE tag: -1 value expressions: expr: _col0 @@ -145,11 +153,15 @@ STAGE PLANS: Needs Tagging: false Reduce Operator Tree: Extract + Statistics: + numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE File Output Operator compressed: false GlobalTableId: 0 #### A masked pattern was here #### NumFilesPerFileSink: 1 + Statistics: + numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat Modified: hive/trunk/ql/src/test/results/clientpositive/join17.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join17.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/join17.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/join17.q.out Mon Nov 18 19:29:24 2013 @@ -26,6 +26,8 @@ STAGE PLANS: src1 TableScan alias: src1 + Statistics: + numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE GatherStats: false Reduce Output Operator key expressions: @@ -35,6 +37,8 @@ STAGE PLANS: Map-reduce partition columns: expr: key type: string + Statistics: + numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE tag: 0 value expressions: expr: key @@ -44,6 +48,8 @@ STAGE PLANS: src2 TableScan alias: src2 + Statistics: + numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE GatherStats: false Reduce Output Operator key expressions: @@ -53,6 +59,8 @@ STAGE PLANS: Map-reduce partition columns: expr: key type: string + Statistics: + numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE tag: 1 value expressions: expr: key Modified: hive/trunk/ql/src/test/results/clientpositive/join26.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join26.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/join26.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/join26.q.out Mon Nov 18 19:29:24 2013 @@ -43,6 +43,8 @@ STAGE PLANS: x TableScan alias: x + Statistics: + numRows: 0 dataSize: 216 basicStatsState: PARTIAL colStatsState: NONE GatherStats: false HashTable Sink Operator condition expressions: @@ -58,6 +60,8 @@ STAGE PLANS: y TableScan alias: y + Statistics: + numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE GatherStats: false HashTable Sink Operator condition expressions: @@ -77,6 +81,8 @@ STAGE PLANS: z TableScan alias: z + Statistics: + numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE GatherStats: false Map Join Operator condition map: Modified: hive/trunk/ql/src/test/results/clientpositive/join32.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join32.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/join32.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/join32.q.out Mon Nov 18 19:29:24 2013 @@ -84,6 +84,8 @@ STAGE PLANS: x TableScan alias: x + Statistics: + numRows: 0 dataSize: 216 basicStatsState: PARTIAL colStatsState: NONE GatherStats: false HashTable Sink Operator condition expressions: @@ -97,6 +99,8 @@ STAGE PLANS: z TableScan alias: z + Statistics: + numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE GatherStats: false HashTable Sink Operator condition expressions: @@ -114,6 +118,8 @@ STAGE PLANS: y TableScan alias: y + Statistics: + numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE GatherStats: false Map Join Operator condition map: Modified: hive/trunk/ql/src/test/results/clientpositive/join32_lessSize.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join32_lessSize.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/join32_lessSize.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/join32_lessSize.q.out Mon Nov 18 19:29:24 2013 @@ -46,6 +46,8 @@ STAGE PLANS: x TableScan alias: x + Statistics: + numRows: 0 dataSize: 216 basicStatsState: PARTIAL colStatsState: NONE GatherStats: false HashTable Sink Operator condition expressions: @@ -63,6 +65,8 @@ STAGE PLANS: y TableScan alias: y + Statistics: + numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE GatherStats: false Map Join Operator condition map: @@ -237,6 +241,8 @@ STAGE PLANS: z TableScan alias: z + Statistics: + numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE GatherStats: false HashTable Sink Operator condition expressions: @@ -560,6 +566,8 @@ STAGE PLANS: x TableScan alias: x + Statistics: + numRows: 0 dataSize: 216 basicStatsState: PARTIAL colStatsState: NONE GatherStats: false HashTable Sink Operator condition expressions: @@ -577,6 +585,8 @@ STAGE PLANS: w TableScan alias: w + Statistics: + numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE GatherStats: false Map Join Operator condition map: @@ -1390,6 +1400,8 @@ STAGE PLANS: y TableScan alias: y + Statistics: + numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE GatherStats: false Reduce Output Operator key expressions: @@ -1399,6 +1411,8 @@ STAGE PLANS: Map-reduce partition columns: expr: key type: string + Statistics: + numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE tag: 1 value expressions: expr: value @@ -1406,6 +1420,8 @@ STAGE PLANS: z TableScan alias: z + Statistics: + numRows: 0 dataSize: 216 basicStatsState: PARTIAL colStatsState: NONE GatherStats: false Reduce Output Operator key expressions: @@ -1415,6 +1431,8 @@ STAGE PLANS: Map-reduce partition columns: expr: key type: string + Statistics: + numRows: 0 dataSize: 216 basicStatsState: PARTIAL colStatsState: NONE tag: 2 value expressions: expr: value @@ -1745,6 +1763,8 @@ STAGE PLANS: res:x TableScan alias: x + Statistics: + numRows: 0 dataSize: 216 basicStatsState: PARTIAL colStatsState: NONE GatherStats: false HashTable Sink Operator condition expressions: @@ -1762,6 +1782,8 @@ STAGE PLANS: res:y TableScan alias: y + Statistics: + numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE GatherStats: false Map Join Operator condition map: @@ -1943,6 +1965,8 @@ STAGE PLANS: z TableScan alias: z + Statistics: + numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE GatherStats: false HashTable Sink Operator condition expressions: @@ -2276,6 +2300,8 @@ STAGE PLANS: res:y TableScan alias: y + Statistics: + numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE GatherStats: false HashTable Sink Operator condition expressions: @@ -2293,6 +2319,8 @@ STAGE PLANS: res:x TableScan alias: x + Statistics: + numRows: 0 dataSize: 216 basicStatsState: PARTIAL colStatsState: NONE GatherStats: false Map Join Operator condition map: @@ -2474,6 +2502,8 @@ STAGE PLANS: z TableScan alias: z + Statistics: + numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE GatherStats: false HashTable Sink Operator condition expressions: Modified: hive/trunk/ql/src/test/results/clientpositive/join33.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join33.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/join33.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/join33.q.out Mon Nov 18 19:29:24 2013 @@ -84,6 +84,8 @@ STAGE PLANS: x TableScan alias: x + Statistics: + numRows: 0 dataSize: 216 basicStatsState: PARTIAL colStatsState: NONE GatherStats: false HashTable Sink Operator condition expressions: @@ -97,6 +99,8 @@ STAGE PLANS: z TableScan alias: z + Statistics: + numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE GatherStats: false HashTable Sink Operator condition expressions: @@ -114,6 +118,8 @@ STAGE PLANS: y TableScan alias: y + Statistics: + numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE GatherStats: false Map Join Operator condition map: Modified: hive/trunk/ql/src/test/results/clientpositive/join34.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join34.q.out?rev=1543120&r1=1543119&r2=1543120&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/join34.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/join34.q.out Mon Nov 18 19:29:24 2013 @@ -47,6 +47,8 @@ STAGE PLANS: x TableScan alias: x + Statistics: + numRows: 0 dataSize: 216 basicStatsState: PARTIAL colStatsState: NONE GatherStats: false HashTable Sink Operator condition expressions: @@ -64,12 +66,16 @@ STAGE PLANS: null-subquery1:subq1-subquery1:x TableScan alias: x + Statistics: + numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE GatherStats: false Filter Operator isSamplingPred: false predicate: expr: (key < 20) type: boolean + Statistics: + numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE Select Operator expressions: expr: key @@ -77,7 +83,11 @@ STAGE PLANS: expr: value type: string outputColumnNames: _col0, _col1 + Statistics: + numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE Union + Statistics: + numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE Map Join Operator condition map: Inner Join 0 to 1 @@ -126,12 +136,16 @@ STAGE PLANS: null-subquery2:subq1-subquery2:x1 TableScan alias: x1 + Statistics: + numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE GatherStats: false Filter Operator isSamplingPred: false predicate: expr: (key > 100) type: boolean + Statistics: + numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE Select Operator expressions: expr: key @@ -139,7 +153,11 @@ STAGE PLANS: expr: value type: string outputColumnNames: _col0, _col1 + Statistics: + numRows: 0 dataSize: 5812 basicStatsState: PARTIAL colStatsState: NONE Union + Statistics: + numRows: 0 dataSize: 11624 basicStatsState: PARTIAL colStatsState: NONE Map Join Operator condition map: Inner Join 0 to 1