You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by gu...@apache.org on 2014/08/22 23:37:21 UTC
svn commit: r1619936 [35/49] - in /hive/branches/cbo: ./ accumulo-handler/
ant/src/org/apache/hadoop/hive/ant/ bin/
common/src/java/org/apache/hadoop/hive/ant/
common/src/java/org/apache/hadoop/hive/common/type/
common/src/java/org/apache/hadoop/hive/c...
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/multiMapJoin1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/multiMapJoin1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/multiMapJoin1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/multiMapJoin1.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: create table smallTbl1(key string, value string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@smallTbl1
POSTHOOK: query: create table smallTbl1(key string, value string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -24,6 +25,7 @@ RUN: Stage-2:STATS
PREHOOK: query: create table smallTbl2(key string, value string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@smallTbl2
POSTHOOK: query: create table smallTbl2(key string, value string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -47,6 +49,7 @@ RUN: Stage-2:STATS
PREHOOK: query: create table smallTbl3(key string, value string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@smallTbl3
POSTHOOK: query: create table smallTbl3(key string, value string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -70,6 +73,7 @@ RUN: Stage-2:STATS
PREHOOK: query: create table smallTbl4(key string, value string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@smallTbl4
POSTHOOK: query: create table smallTbl4(key string, value string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -93,6 +97,7 @@ RUN: Stage-2:STATS
PREHOOK: query: create table bigTbl(key string, value string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@bigTbl
POSTHOOK: query: create table bigTbl(key string, value string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -678,6 +683,7 @@ RUN: Stage-0:DDL
PREHOOK: query: create table bigTbl(key1 string, key2 string, value string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@bigTbl
POSTHOOK: query: create table bigTbl(key1 string, key2 string, value string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -879,9 +885,9 @@ STAGE PLANS:
keys:
0 key1 (type: string)
1 key (type: string)
- outputColumnNames: _col0, _col1, _col2, _col5
+ outputColumnNames: _col0, _col1, _col2, _col6
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col6 (type: string), _col2 (type: string), _col2 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
File Output Operator
compressed: false
@@ -1376,9 +1382,9 @@ STAGE PLANS:
keys:
0 key1 (type: string)
1 key (type: string)
- outputColumnNames: _col0, _col1, _col2, _col5
+ outputColumnNames: _col0, _col1, _col2, _col6
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col6 (type: string), _col2 (type: string), _col2 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
File Output Operator
compressed: false
@@ -1422,10 +1428,10 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1}
1 {KEY.reducesinkkey0}
- outputColumnNames: _col0, _col1, _col2, _col5
+ outputColumnNames: _col0, _col1, _col2, _col6
Statistics: Num rows: 687 Data size: 9924 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col6 (type: string), _col2 (type: string), _col2 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
Statistics: Num rows: 687 Data size: 9924 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -1700,10 +1706,10 @@ STAGE PLANS:
keys:
0 key1 (type: string)
1 key (type: string)
- outputColumnNames: _col0, _col1, _col2, _col5
+ outputColumnNames: _col0, _col1, _col2, _col6
Statistics: Num rows: 687 Data size: 9924 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col6 (type: string), _col2 (type: string), _col2 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
Statistics: Num rows: 687 Data size: 9924 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
@@ -2004,10 +2010,10 @@ STAGE PLANS:
keys:
0 key1 (type: string)
1 key (type: string)
- outputColumnNames: _col0, _col1, _col2, _col5
+ outputColumnNames: _col0, _col1, _col2, _col6
Statistics: Num rows: 687 Data size: 9924 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col6 (type: string), _col2 (type: string), _col2 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
Statistics: Num rows: 687 Data size: 9924 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
@@ -2361,9 +2367,9 @@ STAGE PLANS:
keys:
0 key1 (type: string)
1 key (type: string)
- outputColumnNames: _col0, _col1, _col2, _col5
+ outputColumnNames: _col0, _col1, _col2, _col6
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col6 (type: string), _col2 (type: string), _col2 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
File Output Operator
compressed: false
@@ -2858,9 +2864,9 @@ STAGE PLANS:
keys:
0 key1 (type: string)
1 key (type: string)
- outputColumnNames: _col0, _col1, _col2, _col5
+ outputColumnNames: _col0, _col1, _col2, _col6
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col6 (type: string), _col2 (type: string), _col2 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
File Output Operator
compressed: false
@@ -2904,10 +2910,10 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1}
1 {KEY.reducesinkkey0}
- outputColumnNames: _col0, _col1, _col2, _col5
+ outputColumnNames: _col0, _col1, _col2, _col6
Statistics: Num rows: 687 Data size: 9924 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col6 (type: string), _col2 (type: string), _col2 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
Statistics: Num rows: 687 Data size: 9924 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/multiMapJoin2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/multiMapJoin2.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/multiMapJoin2.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/multiMapJoin2.q.out Fri Aug 22 21:36:47 2014
@@ -2191,6 +2191,7 @@ PREHOOK: query: -- Check if we can corre
CREATE TABLE part_table(key string, value string) PARTITIONED BY (partitionId int)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@part_table
POSTHOOK: query: -- Check if we can correctly handle partitioned table.
CREATE TABLE part_table(key string, value string) PARTITIONED BY (partitionId int)
POSTHOOK: type: CREATETABLE
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert.q.out Fri Aug 22 21:36:47 2014
@@ -3,6 +3,7 @@ PREHOOK: query: -- SORT_QUERY_RESULTS
create table src_multi1 like src
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@src_multi1
POSTHOOK: query: -- SORT_QUERY_RESULTS
create table src_multi1 like src
@@ -12,6 +13,7 @@ POSTHOOK: Output: default@src_multi1
PREHOOK: query: create table src_multi2 like src
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@src_multi2
POSTHOOK: query: create table src_multi2 like src
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_gby.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_gby.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_gby.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_gby.q.out Fri Aug 22 21:36:47 2014
@@ -4,6 +4,7 @@ PREHOOK: query: -- SORT_QUERY_RESULTS
create table e1 (key string, count int)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@e1
POSTHOOK: query: -- SORT_QUERY_RESULTS
--HIVE-3699 Multiple insert overwrite into multiple tables query stores same results in all tables
@@ -14,6 +15,7 @@ POSTHOOK: Output: default@e1
PREHOOK: query: create table e2 (key string, count int)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@e2
POSTHOOK: query: create table e2 (key string, count int)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_gby2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_gby2.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_gby2.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_gby2.q.out Fri Aug 22 21:36:47 2014
@@ -2,6 +2,7 @@ PREHOOK: query: --HIVE-3699 Multiple ins
create table e1 (count int)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@e1
POSTHOOK: query: --HIVE-3699 Multiple insert overwrite into multiple tables query stores same results in all tables
create table e1 (count int)
POSTHOOK: type: CREATETABLE
@@ -10,6 +11,7 @@ POSTHOOK: Output: default@e1
PREHOOK: query: create table e2 (percentile double)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@e2
POSTHOOK: query: create table e2 (percentile double)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_gby3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_gby3.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_gby3.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_gby3.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: create table e1 (key string, keyD double)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@e1
POSTHOOK: query: create table e1 (key string, keyD double)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -8,6 +9,7 @@ POSTHOOK: Output: default@e1
PREHOOK: query: create table e2 (key string, keyD double, value string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@e2
POSTHOOK: query: create table e2 (key string, keyD double, value string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -15,6 +17,7 @@ POSTHOOK: Output: default@e2
PREHOOK: query: create table e3 (key string, keyD double)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@e3
POSTHOOK: query: create table e3 (key string, keyD double)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_lateral_view.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_lateral_view.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_lateral_view.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_lateral_view.q.out Fri Aug 22 21:36:47 2014
@@ -12,6 +12,7 @@ POSTHOOK: Output: default@src_10
PREHOOK: query: create table src_lv1 (key string, value string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@src_lv1
POSTHOOK: query: create table src_lv1 (key string, value string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -19,6 +20,7 @@ POSTHOOK: Output: default@src_lv1
PREHOOK: query: create table src_lv2 (key string, value string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@src_lv2
POSTHOOK: query: create table src_lv2 (key string, value string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -26,6 +28,7 @@ POSTHOOK: Output: default@src_lv2
PREHOOK: query: create table src_lv3 (key string, value string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@src_lv3
POSTHOOK: query: create table src_lv3 (key string, value string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -81,10 +84,10 @@ STAGE PLANS:
outputColumnNames: key
Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
Lateral View Join Operator
- outputColumnNames: _col0, _col4
+ outputColumnNames: _col0, _col5
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col4 (type: double)
+ expressions: _col0 (type: string), _col5 (type: double)
outputColumnNames: _col0, _col1
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -103,10 +106,10 @@ STAGE PLANS:
Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
function name: explode
Lateral View Join Operator
- outputColumnNames: _col0, _col4
+ outputColumnNames: _col0, _col5
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col4 (type: double)
+ expressions: _col0 (type: string), _col5 (type: double)
outputColumnNames: _col0, _col1
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -124,10 +127,10 @@ STAGE PLANS:
outputColumnNames: key
Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
Lateral View Join Operator
- outputColumnNames: _col0, _col4
+ outputColumnNames: _col0, _col5
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col4 (type: double)
+ expressions: _col0 (type: string), _col5 (type: double)
outputColumnNames: _col0, _col1
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -146,10 +149,10 @@ STAGE PLANS:
Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
function name: explode
Lateral View Join Operator
- outputColumnNames: _col0, _col4
+ outputColumnNames: _col0, _col5
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col4 (type: double)
+ expressions: _col0 (type: string), _col5 (type: double)
outputColumnNames: _col0, _col1
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -280,9 +283,9 @@ POSTHOOK: Input: default@src_10
POSTHOOK: Output: default@src_lv1
POSTHOOK: Output: default@src_lv2
POSTHOOK: Lineage: src_lv1.key SCRIPT [(src_10)src_10.FieldSchema(name:key, type:string, comment:null), ]
-POSTHOOK: Lineage: src_lv1.value SIMPLE [(src_10)src_10.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
+POSTHOOK: Lineage: src_lv1.value SIMPLE [(src_10)src_10.FieldSchema(name:ROW__ID, type:struct<transactionId:bigint,bucketId:int,rowId:bigint>, comment:), ]
POSTHOOK: Lineage: src_lv2.key SCRIPT [(src_10)src_10.FieldSchema(name:key, type:string, comment:null), ]
-POSTHOOK: Lineage: src_lv2.value SIMPLE [(src_10)src_10.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
+POSTHOOK: Lineage: src_lv2.value SIMPLE [(src_10)src_10.FieldSchema(name:ROW__ID, type:struct<transactionId:bigint,bucketId:int,rowId:bigint>, comment:), ]
PREHOOK: query: select * from src_lv1
PREHOOK: type: QUERY
PREHOOK: Input: default@src_lv1
@@ -381,14 +384,14 @@ STAGE PLANS:
outputColumnNames: key
Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
Lateral View Join Operator
- outputColumnNames: _col0, _col4
+ outputColumnNames: _col0, _col5
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col4 (type: double)
- outputColumnNames: _col0, _col4
+ expressions: _col0 (type: string), _col5 (type: double)
+ outputColumnNames: _col0, _col5
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Group By Operator
- aggregations: sum(_col4)
+ aggregations: sum(_col5)
keys: _col0 (type: string)
mode: hash
outputColumnNames: _col0, _col1
@@ -407,14 +410,14 @@ STAGE PLANS:
Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
function name: explode
Lateral View Join Operator
- outputColumnNames: _col0, _col4
+ outputColumnNames: _col0, _col5
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col4 (type: double)
- outputColumnNames: _col0, _col4
+ expressions: _col0 (type: string), _col5 (type: double)
+ outputColumnNames: _col0, _col5
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Group By Operator
- aggregations: sum(_col4)
+ aggregations: sum(_col5)
keys: _col0 (type: string)
mode: hash
outputColumnNames: _col0, _col1
@@ -432,14 +435,14 @@ STAGE PLANS:
outputColumnNames: key
Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
Lateral View Join Operator
- outputColumnNames: _col0, _col4
+ outputColumnNames: _col0, _col5
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col4 (type: double)
- outputColumnNames: _col0, _col4
+ expressions: _col0 (type: string), _col5 (type: double)
+ outputColumnNames: _col0, _col5
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Group By Operator
- aggregations: sum(_col4)
+ aggregations: sum(_col5)
keys: _col0 (type: string)
mode: hash
outputColumnNames: _col0, _col1
@@ -458,14 +461,14 @@ STAGE PLANS:
Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
function name: explode
Lateral View Join Operator
- outputColumnNames: _col0, _col4
+ outputColumnNames: _col0, _col5
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col4 (type: double)
- outputColumnNames: _col0, _col4
+ expressions: _col0 (type: string), _col5 (type: double)
+ outputColumnNames: _col0, _col5
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Group By Operator
- aggregations: sum(_col4)
+ aggregations: sum(_col5)
keys: _col0 (type: string)
mode: hash
outputColumnNames: _col0, _col1
@@ -567,9 +570,9 @@ POSTHOOK: Input: default@src_10
POSTHOOK: Output: default@src_lv1
POSTHOOK: Output: default@src_lv2
POSTHOOK: Lineage: src_lv1.key SCRIPT [(src_10)src_10.FieldSchema(name:key, type:string, comment:null), ]
-POSTHOOK: Lineage: src_lv1.value EXPRESSION [(src_10)src_10.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
+POSTHOOK: Lineage: src_lv1.value EXPRESSION [(src_10)src_10.FieldSchema(name:ROW__ID, type:struct<transactionId:bigint,bucketId:int,rowId:bigint>, comment:), ]
POSTHOOK: Lineage: src_lv2.key SCRIPT [(src_10)src_10.FieldSchema(name:key, type:string, comment:null), ]
-POSTHOOK: Lineage: src_lv2.value EXPRESSION [(src_10)src_10.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
+POSTHOOK: Lineage: src_lv2.value EXPRESSION [(src_10)src_10.FieldSchema(name:ROW__ID, type:struct<transactionId:bigint,bucketId:int,rowId:bigint>, comment:), ]
PREHOOK: query: select * from src_lv1
PREHOOK: type: QUERY
PREHOOK: Input: default@src_lv1
@@ -652,14 +655,14 @@ STAGE PLANS:
outputColumnNames: key
Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
Lateral View Join Operator
- outputColumnNames: _col0, _col4
+ outputColumnNames: _col0, _col5
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col4 (type: double)
- outputColumnNames: _col0, _col4
+ expressions: _col0 (type: string), _col5 (type: double)
+ outputColumnNames: _col0, _col5
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Group By Operator
- aggregations: sum(_col4)
+ aggregations: sum(_col5)
keys: _col0 (type: string)
mode: hash
outputColumnNames: _col0, _col1
@@ -678,14 +681,14 @@ STAGE PLANS:
Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
function name: explode
Lateral View Join Operator
- outputColumnNames: _col0, _col4
+ outputColumnNames: _col0, _col5
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col4 (type: double)
- outputColumnNames: _col0, _col4
+ expressions: _col0 (type: string), _col5 (type: double)
+ outputColumnNames: _col0, _col5
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Group By Operator
- aggregations: sum(_col4)
+ aggregations: sum(_col5)
keys: _col0 (type: string)
mode: hash
outputColumnNames: _col0, _col1
@@ -843,7 +846,7 @@ POSTHOOK: Output: default@src_lv1
POSTHOOK: Output: default@src_lv2
POSTHOOK: Output: default@src_lv3
POSTHOOK: Lineage: src_lv1.key SCRIPT [(src_10)src_10.FieldSchema(name:key, type:string, comment:null), ]
-POSTHOOK: Lineage: src_lv1.value EXPRESSION [(src_10)src_10.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
+POSTHOOK: Lineage: src_lv1.value EXPRESSION [(src_10)src_10.FieldSchema(name:ROW__ID, type:struct<transactionId:bigint,bucketId:int,rowId:bigint>, comment:), ]
POSTHOOK: Lineage: src_lv2.key SIMPLE [(src_10)src_10.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: src_lv2.value EXPRESSION [(src_10)src_10.FieldSchema(name:value, type:string, comment:null), ]
POSTHOOK: Lineage: src_lv3.key SIMPLE [(src_10)src_10.FieldSchema(name:key, type:string, comment:null), ]
@@ -943,15 +946,15 @@ STAGE PLANS:
outputColumnNames: key
Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
Lateral View Join Operator
- outputColumnNames: _col0, _col4
+ outputColumnNames: _col0, _col5
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col4 (type: double), _col0 (type: string)
- outputColumnNames: _col4, _col0
+ expressions: _col5 (type: double), _col0 (type: string)
+ outputColumnNames: _col5, _col0
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: sum(DISTINCT _col0)
- keys: _col4 (type: double), _col0 (type: string)
+ keys: _col5 (type: double), _col0 (type: string)
mode: hash
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
@@ -968,15 +971,15 @@ STAGE PLANS:
Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
function name: explode
Lateral View Join Operator
- outputColumnNames: _col0, _col4
+ outputColumnNames: _col0, _col5
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col4 (type: double), _col0 (type: string)
- outputColumnNames: _col4, _col0
+ expressions: _col5 (type: double), _col0 (type: string)
+ outputColumnNames: _col5, _col0
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: sum(DISTINCT _col0)
- keys: _col4 (type: double), _col0 (type: string)
+ keys: _col5 (type: double), _col0 (type: string)
mode: hash
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
@@ -992,15 +995,15 @@ STAGE PLANS:
outputColumnNames: key
Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
Lateral View Join Operator
- outputColumnNames: _col0, _col4
+ outputColumnNames: _col0, _col5
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col4 (type: double), _col0 (type: string)
- outputColumnNames: _col4, _col0
+ expressions: _col5 (type: double), _col0 (type: string)
+ outputColumnNames: _col5, _col0
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: sum(DISTINCT _col0)
- keys: _col4 (type: double), _col0 (type: string)
+ keys: _col5 (type: double), _col0 (type: string)
mode: hash
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
@@ -1018,15 +1021,15 @@ STAGE PLANS:
Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
function name: explode
Lateral View Join Operator
- outputColumnNames: _col0, _col4
+ outputColumnNames: _col0, _col5
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col4 (type: double), _col0 (type: string)
- outputColumnNames: _col4, _col0
+ expressions: _col5 (type: double), _col0 (type: string)
+ outputColumnNames: _col5, _col0
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: sum(DISTINCT _col0)
- keys: _col4 (type: double), _col0 (type: string)
+ keys: _col5 (type: double), _col0 (type: string)
mode: hash
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
@@ -1187,9 +1190,9 @@ POSTHOOK: Input: default@src_10
POSTHOOK: Output: default@src_lv1
POSTHOOK: Output: default@src_lv2
POSTHOOK: Output: default@src_lv3
-POSTHOOK: Lineage: src_lv1.key SIMPLE [(src_10)src_10.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
+POSTHOOK: Lineage: src_lv1.key SIMPLE [(src_10)src_10.FieldSchema(name:ROW__ID, type:struct<transactionId:bigint,bucketId:int,rowId:bigint>, comment:), ]
POSTHOOK: Lineage: src_lv1.value SCRIPT [(src_10)src_10.FieldSchema(name:key, type:string, comment:null), ]
-POSTHOOK: Lineage: src_lv2.key SIMPLE [(src_10)src_10.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
+POSTHOOK: Lineage: src_lv2.key SIMPLE [(src_10)src_10.FieldSchema(name:ROW__ID, type:struct<transactionId:bigint,bucketId:int,rowId:bigint>, comment:), ]
POSTHOOK: Lineage: src_lv2.value SCRIPT [(src_10)src_10.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: src_lv3.key SIMPLE [(src_10)src_10.FieldSchema(name:value, type:string, comment:null), ]
POSTHOOK: Lineage: src_lv3.value EXPRESSION [(src_10)src_10.FieldSchema(name:key, type:string, comment:null), ]
@@ -1270,6 +1273,7 @@ val_98 98.0
PREHOOK: query: create table src_lv4 (key string, value string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@src_lv4
POSTHOOK: query: create table src_lv4 (key string, value string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -1317,15 +1321,15 @@ STAGE PLANS:
outputColumnNames: key
Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
Lateral View Join Operator
- outputColumnNames: _col0, _col4
+ outputColumnNames: _col0, _col5
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col4 (type: double)
- outputColumnNames: _col0, _col4
+ expressions: _col0 (type: string), _col5 (type: double)
+ outputColumnNames: _col0, _col5
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Group By Operator
- aggregations: sum(DISTINCT _col4)
- keys: _col0 (type: string), _col4 (type: double)
+ aggregations: sum(DISTINCT _col5)
+ keys: _col0 (type: string), _col5 (type: double)
mode: hash
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
@@ -1342,15 +1346,15 @@ STAGE PLANS:
Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
function name: explode
Lateral View Join Operator
- outputColumnNames: _col0, _col4
+ outputColumnNames: _col0, _col5
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col4 (type: double)
- outputColumnNames: _col0, _col4
+ expressions: _col0 (type: string), _col5 (type: double)
+ outputColumnNames: _col0, _col5
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Group By Operator
- aggregations: sum(DISTINCT _col4)
- keys: _col0 (type: string), _col4 (type: double)
+ aggregations: sum(DISTINCT _col5)
+ keys: _col0 (type: string), _col5 (type: double)
mode: hash
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
@@ -1366,15 +1370,15 @@ STAGE PLANS:
outputColumnNames: key
Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
Lateral View Join Operator
- outputColumnNames: _col0, _col4
+ outputColumnNames: _col0, _col5
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col4 (type: double)
- outputColumnNames: _col0, _col4
+ expressions: _col0 (type: string), _col5 (type: double)
+ outputColumnNames: _col0, _col5
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Group By Operator
- aggregations: sum(DISTINCT _col4)
- keys: _col0 (type: string), _col4 (type: double)
+ aggregations: sum(DISTINCT _col5)
+ keys: _col0 (type: string), _col5 (type: double)
mode: hash
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
@@ -1392,15 +1396,15 @@ STAGE PLANS:
Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE
function name: explode
Lateral View Join Operator
- outputColumnNames: _col0, _col4
+ outputColumnNames: _col0, _col5
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col4 (type: double)
- outputColumnNames: _col0, _col4
+ expressions: _col0 (type: string), _col5 (type: double)
+ outputColumnNames: _col0, _col5
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
Group By Operator
- aggregations: sum(DISTINCT _col4)
- keys: _col0 (type: string), _col4 (type: double)
+ aggregations: sum(DISTINCT _col5)
+ keys: _col0 (type: string), _col5 (type: double)
mode: hash
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE
@@ -1602,9 +1606,9 @@ POSTHOOK: Output: default@src_lv2
POSTHOOK: Output: default@src_lv3
POSTHOOK: Output: default@src_lv4
POSTHOOK: Lineage: src_lv1.key SCRIPT [(src_10)src_10.FieldSchema(name:key, type:string, comment:null), ]
-POSTHOOK: Lineage: src_lv1.value EXPRESSION [(src_10)src_10.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
+POSTHOOK: Lineage: src_lv1.value EXPRESSION [(src_10)src_10.FieldSchema(name:ROW__ID, type:struct<transactionId:bigint,bucketId:int,rowId:bigint>, comment:), ]
POSTHOOK: Lineage: src_lv2.key SCRIPT [(src_10)src_10.FieldSchema(name:key, type:string, comment:null), ]
-POSTHOOK: Lineage: src_lv2.value EXPRESSION [(src_10)src_10.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
+POSTHOOK: Lineage: src_lv2.value EXPRESSION [(src_10)src_10.FieldSchema(name:ROW__ID, type:struct<transactionId:bigint,bucketId:int,rowId:bigint>, comment:), ]
POSTHOOK: Lineage: src_lv3.key SIMPLE [(src_10)src_10.FieldSchema(name:value, type:string, comment:null), ]
POSTHOOK: Lineage: src_lv3.value EXPRESSION [(src_10)src_10.null, ]
POSTHOOK: Lineage: src_lv4.key SIMPLE [(src_10)src_10.FieldSchema(name:value, type:string, comment:null), ]
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_move_tasks_share_dependencies.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_move_tasks_share_dependencies.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_move_tasks_share_dependencies.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_move_tasks_share_dependencies.q.out Fri Aug 22 21:36:47 2014
@@ -3,6 +3,7 @@ PREHOOK: query: -- SORT_QUERY_RESULTS
create table src_multi1 like src
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@src_multi1
POSTHOOK: query: -- SORT_QUERY_RESULTS
create table src_multi1 like src
@@ -12,6 +13,7 @@ POSTHOOK: Output: default@src_multi1
PREHOOK: query: create table src_multi2 like src
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@src_multi2
POSTHOOK: query: create table src_multi2 like src
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/multi_join_union.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/multi_join_union.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/multi_join_union.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/multi_join_union.q.out Fri Aug 22 21:36:47 2014
@@ -88,10 +88,10 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
condition expressions:
- 0 {_col0} {_col1} {_col4} {_col5}
+ 0 {_col0} {_col1} {_col5} {_col6}
1 {_col0}
keys:
- 0 _col5 (type: string)
+ 0 _col6 (type: string)
1 _col1 (type: string)
c-subquery2:a-subquery2:src14
TableScan
@@ -112,10 +112,10 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
condition expressions:
- 0 {_col0} {_col1} {_col4} {_col5}
+ 0 {_col0} {_col1} {_col5} {_col6}
1 {_col0}
keys:
- 0 _col5 (type: string)
+ 0 _col6 (type: string)
1 _col1 (type: string)
Stage: Stage-6
@@ -136,21 +136,21 @@ STAGE PLANS:
keys:
0 key (type: string)
1 key (type: string)
- outputColumnNames: _col0, _col1, _col4, _col5
+ outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {_col0} {_col1} {_col4} {_col5}
+ 0 {_col0} {_col1} {_col5} {_col6}
1 {_col0} {_col1}
keys:
- 0 _col5 (type: string)
+ 0 _col6 (type: string)
1 _col1 (type: string)
- outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
+ outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/multi_sahooks.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/multi_sahooks.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/multi_sahooks.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/multi_sahooks.q.out Fri Aug 22 21:36:47 2014
@@ -7,6 +7,7 @@ DummySemanticAnalyzerHook1 Post: Hive ro
PREHOOK: query: create table tbl_sahook (c string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@tbl_sahook
POSTHOOK: query: create table tbl_sahook (c string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -37,6 +38,7 @@ DummySemanticAnalyzerHook1 Post: Hive ro
PREHOOK: query: create table tbl_sahooks (c string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@tbl_sahooks
POSTHOOK: query: create table tbl_sahooks (c string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -67,6 +69,7 @@ DummySemanticAnalyzerHook1 Post: Hive ro
PREHOOK: query: create table tbl_sahooks (c string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@tbl_sahooks
POSTHOOK: query: create table tbl_sahooks (c string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -99,6 +102,7 @@ DummySemanticAnalyzerHook1 Post: Hive ro
PREHOOK: query: create table tbl_sahooks (c string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@tbl_sahooks
POSTHOOK: query: create table tbl_sahooks (c string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/multigroupby_singlemr.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/multigroupby_singlemr.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/multigroupby_singlemr.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/multigroupby_singlemr.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: CREATE TABLE TBL(C1 INT, C2 INT, C3 INT, C4 INT)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@TBL
POSTHOOK: query: CREATE TABLE TBL(C1 INT, C2 INT, C3 INT, C4 INT)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -8,6 +9,7 @@ POSTHOOK: Output: default@TBL
PREHOOK: query: CREATE TABLE DEST1(d1 INT, d2 INT) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@DEST1
POSTHOOK: query: CREATE TABLE DEST1(d1 INT, d2 INT) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -15,6 +17,7 @@ POSTHOOK: Output: default@DEST1
PREHOOK: query: CREATE TABLE DEST2(d1 INT, d2 INT, d3 INT) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@DEST2
POSTHOOK: query: CREATE TABLE DEST2(d1 INT, d2 INT, d3 INT) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -22,6 +25,7 @@ POSTHOOK: Output: default@DEST2
PREHOOK: query: CREATE TABLE DEST3(d1 INT, d2 INT, d3 INT, d4 INT) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@DEST3
POSTHOOK: query: CREATE TABLE DEST3(d1 INT, d2 INT, d3 INT, d4 INT) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -29,6 +33,7 @@ POSTHOOK: Output: default@DEST3
PREHOOK: query: CREATE TABLE DEST4(d1 INT, d2 INT, d3 INT, d4 INT) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@DEST4
POSTHOOK: query: CREATE TABLE DEST4(d1 INT, d2 INT, d3 INT, d4 INT) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/nested_complex.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/nested_complex.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/nested_complex.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/nested_complex.q.out Fri Aug 22 21:36:47 2014
@@ -12,6 +12,7 @@ WITH SERDEPROPERTIES (
)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@nestedcomplex
POSTHOOK: query: create table nestedcomplex (
simple_int int,
max_nested_array array<array<array<array<array<array<array<array<array<array<array<array<array<array<array<array<array<array<array<array<array<array<array<int>>>>>>>>>>>>>>>>>>>>>>>,
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/nestedvirtual.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/nestedvirtual.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/nestedvirtual.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/nestedvirtual.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: CREATE TABLE pokes (foo INT, bar STRING)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@pokes
POSTHOOK: query: CREATE TABLE pokes (foo INT, bar STRING)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -8,6 +9,7 @@ POSTHOOK: Output: default@pokes
PREHOOK: query: create table pokes2(foo INT, bar STRING)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@pokes2
POSTHOOK: query: create table pokes2(foo INT, bar STRING)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -48,6 +50,7 @@ POSTHOOK: Output: default@pokes2
PREHOOK: query: CREATE TABLE pokes (foo INT, bar STRING)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@pokes
POSTHOOK: query: CREATE TABLE pokes (foo INT, bar STRING)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -55,6 +58,7 @@ POSTHOOK: Output: default@pokes
PREHOOK: query: create table pokes2(foo INT, bar STRING)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@pokes2
POSTHOOK: query: create table pokes2(foo INT, bar STRING)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -95,6 +99,7 @@ POSTHOOK: Output: default@pokes2
PREHOOK: query: CREATE TABLE pokes (foo INT, bar STRING)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@pokes
POSTHOOK: query: CREATE TABLE pokes (foo INT, bar STRING)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -102,6 +107,7 @@ POSTHOOK: Output: default@pokes
PREHOOK: query: create table pokes2(foo INT, bar STRING)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@pokes2
POSTHOOK: query: create table pokes2(foo INT, bar STRING)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/newline.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/newline.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/newline.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/newline.q.out Fri Aug 22 21:36:47 2014
@@ -3,6 +3,7 @@ PREHOOK: query: -- SORT_QUERY_RESULTS
create table tmp_tmp(key string, value string) stored as rcfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@tmp_tmp
POSTHOOK: query: -- SORT_QUERY_RESULTS
create table tmp_tmp(key string, value string) stored as rcfile
@@ -52,6 +53,7 @@ POSTHOOK: Output: default@tmp_tmp
PREHOOK: query: create table tmp_tmp(key string, value string) stored as rcfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@tmp_tmp
POSTHOOK: query: create table tmp_tmp(key string, value string) stored as rcfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/no_hooks.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/no_hooks.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/no_hooks.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/no_hooks.q.out Fri Aug 22 21:36:47 2014
@@ -38,10 +38,10 @@ STAGE PLANS:
condition expressions:
0 {VALUE._col0} {VALUE._col1}
1 {VALUE._col0} {VALUE._col1}
- outputColumnNames: _col0, _col1, _col4, _col5
+ outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 9 Data size: 1983 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 9 Data size: 1983 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/nomore_ambiguous_table_col.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/nomore_ambiguous_table_col.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/nomore_ambiguous_table_col.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/nomore_ambiguous_table_col.q.out Fri Aug 22 21:36:47 2014
@@ -9,6 +9,7 @@ POSTHOOK: type: DROPTABLE
PREHOOK: query: create table ambiguous (key string, value string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@ambiguous
POSTHOOK: query: create table ambiguous (key string, value string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/nonmr_fetch.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/nonmr_fetch.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/nonmr_fetch.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/nonmr_fetch.q.out Fri Aug 22 21:36:47 2014
@@ -1121,10 +1121,10 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0} {VALUE._col0}
1 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4, _col5
+ outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 16 Data size: 3306 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 16 Data size: 3306 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/nonreserved_keywords_input37.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/nonreserved_keywords_input37.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/nonreserved_keywords_input37.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/nonreserved_keywords_input37.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: CREATE TABLE table(string string) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@table
POSTHOOK: query: CREATE TABLE table(string string) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/nonreserved_keywords_insert_into1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/nonreserved_keywords_insert_into1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/nonreserved_keywords_insert_into1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/nonreserved_keywords_insert_into1.q.out Fri Aug 22 21:36:47 2014
@@ -5,6 +5,7 @@ POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE insert (key INT, as STRING)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@insert
POSTHOOK: query: CREATE TABLE insert (key INT, as STRING)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/notable_alias1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/notable_alias1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/notable_alias1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/notable_alias1.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: CREATE TABLE dest1(dummy STRING, key INT, value DOUBLE) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@dest1
POSTHOOK: query: CREATE TABLE dest1(dummy STRING, key INT, value DOUBLE) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/notable_alias2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/notable_alias2.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/notable_alias2.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/notable_alias2.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: CREATE TABLE dest1(dummy STRING, key INT, value DOUBLE) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@dest1
POSTHOOK: query: CREATE TABLE dest1(dummy STRING, key INT, value DOUBLE) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/notable_alias3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/notable_alias3.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/notable_alias3.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/notable_alias3.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: CREATE TABLE dest1(c string, key INT, value DOUBLE) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@dest1
POSTHOOK: query: CREATE TABLE dest1(c string, key INT, value DOUBLE) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/null_column.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/null_column.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/null_column.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/null_column.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: create table temp_null(a int) stored as textfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@temp_null
POSTHOOK: query: create table temp_null(a int) stored as textfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -30,6 +31,7 @@ NULL NULL
PREHOOK: query: create table tt(a int, b string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@tt
POSTHOOK: query: create table tt(a int, b string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -61,6 +63,7 @@ NULL NULL
PREHOOK: query: create table tt_b(a int, b string) row format serde "org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe"
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@tt_b
POSTHOOK: query: create table tt_b(a int, b string) row format serde "org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe"
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -106,6 +109,7 @@ POSTHOOK: Output: target/warehouse/null_
PREHOOK: query: create table temp_null2 (key string, value string) partitioned by (ds string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@temp_null2
POSTHOOK: query: create table temp_null2 (key string, value string) partitioned by (ds string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/nullformat.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/nullformat.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/nullformat.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/nullformat.q.out Fri Aug 22 21:36:47 2014
@@ -7,6 +7,7 @@ POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE base_tab(a STRING, b STRING, c STRING, d STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@base_tab
POSTHOOK: query: CREATE TABLE base_tab(a STRING, b STRING, c STRING, d STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -57,6 +58,7 @@ STAGE PLANS:
PREHOOK: query: CREATE TABLE null_tab1(a STRING, b STRING) ROW FORMAT DELIMITED NULL DEFINED AS 'fooNull'
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@null_tab1
POSTHOOK: query: CREATE TABLE null_tab1(a STRING, b STRING) ROW FORMAT DELIMITED NULL DEFINED AS 'fooNull'
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/nullformatCTAS.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/nullformatCTAS.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/nullformatCTAS.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/nullformatCTAS.q.out Fri Aug 22 21:36:47 2014
@@ -7,6 +7,7 @@ POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE base_tab(a STRING, b STRING, c STRING, d STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@base_tab
POSTHOOK: query: CREATE TABLE base_tab(a STRING, b STRING, c STRING, d STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/nullformatdir.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/nullformatdir.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/nullformatdir.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/nullformatdir.q.out Fri Aug 22 21:36:47 2014
@@ -7,6 +7,7 @@ POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE base_tab(a STRING, b STRING, c STRING, d STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@base_tab
POSTHOOK: query: CREATE TABLE base_tab(a STRING, b STRING, c STRING, d STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -58,6 +59,7 @@ POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE null_tab2(a STRING, b STRING) ROW FORMAT DELIMITED NULL DEFINED AS 'fooNull'
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@null_tab2
POSTHOOK: query: CREATE TABLE null_tab2(a STRING, b STRING) ROW FORMAT DELIMITED NULL DEFINED AS 'fooNull'
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/nullgroup3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/nullgroup3.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/nullgroup3.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/nullgroup3.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: CREATE TABLE tstparttbl(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@tstparttbl
POSTHOOK: query: CREATE TABLE tstparttbl(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -91,6 +92,7 @@ POSTHOOK: Input: default@tstparttbl@ds=2
PREHOOK: query: CREATE TABLE tstparttbl2(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@tstparttbl2
POSTHOOK: query: CREATE TABLE tstparttbl2(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -189,6 +191,7 @@ POSTHOOK: Output: default@tstparttbl
PREHOOK: query: CREATE TABLE tstparttbl(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@tstparttbl
POSTHOOK: query: CREATE TABLE tstparttbl(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -287,6 +290,7 @@ POSTHOOK: Output: default@tstparttbl2
PREHOOK: query: CREATE TABLE tstparttbl2(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@tstparttbl2
POSTHOOK: query: CREATE TABLE tstparttbl2(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/nullgroup5.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/nullgroup5.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/nullgroup5.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/nullgroup5.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: CREATE TABLE tstparttbl(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@tstparttbl
POSTHOOK: query: CREATE TABLE tstparttbl(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -17,6 +18,7 @@ POSTHOOK: Output: default@tstparttbl@ds=
PREHOOK: query: CREATE TABLE tstparttbl2(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@tstparttbl2
POSTHOOK: query: CREATE TABLE tstparttbl2(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/nullinput.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/nullinput.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/nullinput.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/nullinput.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: create table tstnullinut(a string, b string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@tstnullinut
POSTHOOK: query: create table tstnullinut(a string, b string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/nullinput2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/nullinput2.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/nullinput2.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/nullinput2.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: create table nulltbl(key int) partitioned by (ds string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@nulltbl
POSTHOOK: query: create table nulltbl(key int) partitioned by (ds string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/nullscript.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/nullscript.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/nullscript.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/nullscript.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: CREATE TABLE nullscript(KEY STRING, VALUE STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@nullscript
POSTHOOK: query: CREATE TABLE nullscript(KEY STRING, VALUE STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/optional_outer.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/optional_outer.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/optional_outer.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/optional_outer.q.out Fri Aug 22 21:36:47 2014
@@ -35,10 +35,10 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0} {VALUE._col0}
1 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4, _col5
+ outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -92,10 +92,10 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0} {VALUE._col0}
1 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4, _col5
+ outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -149,10 +149,10 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0} {VALUE._col0}
1 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4, _col5
+ outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -206,10 +206,10 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0} {VALUE._col0}
1 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4, _col5
+ outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -263,10 +263,10 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0} {VALUE._col0}
1 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4, _col5
+ outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -320,10 +320,10 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0} {VALUE._col0}
1 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4, _col5
+ outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/orc_analyze.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/orc_analyze.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/orc_analyze.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/orc_analyze.q.out Fri Aug 22 21:36:47 2014
@@ -8,6 +8,7 @@ PREHOOK: query: CREATE TABLE orc_create_
state string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@orc_create_people_staging
POSTHOOK: query: CREATE TABLE orc_create_people_staging (
id int,
first_name string,
@@ -40,6 +41,7 @@ CREATE TABLE orc_create_people (
STORED AS orc
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@orc_create_people
POSTHOOK: query: -- non-partitioned table
-- partial scan gather
CREATE TABLE orc_create_people (
@@ -136,6 +138,7 @@ CREATE TABLE orc_create_people (
STORED AS orc
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@orc_create_people
POSTHOOK: query: -- auto stats gather
CREATE TABLE orc_create_people (
id int,
@@ -226,6 +229,7 @@ PARTITIONED BY (state string)
STORED AS orc
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@orc_create_people
POSTHOOK: query: -- partitioned table
-- partial scan gather
CREATE TABLE orc_create_people (
@@ -383,6 +387,7 @@ PARTITIONED BY (state string)
STORED AS orc
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@orc_create_people
POSTHOOK: query: -- auto stats gather
CREATE TABLE orc_create_people (
id int,
@@ -533,6 +538,7 @@ into 4 buckets
STORED AS orc
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@orc_create_people
POSTHOOK: query: -- partitioned and bucketed table
-- partial scan gather
CREATE TABLE orc_create_people (
@@ -696,6 +702,7 @@ into 4 buckets
STORED AS orc
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@orc_create_people
POSTHOOK: query: -- auto stats gather
CREATE TABLE orc_create_people (
id int,
@@ -847,6 +854,7 @@ PARTITIONED BY (state string)
STORED AS orc
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@orc_create_people
POSTHOOK: query: -- create table with partitions containing text and ORC files.
-- ORC files implements StatsProvidingRecordReader but text files does not.
-- So the partition containing text file should not have statistics.
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/orc_create.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/orc_create.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/orc_create.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/orc_create.q.out Fri Aug 22 21:36:47 2014
@@ -33,6 +33,7 @@ PREHOOK: query: CREATE TABLE orc_create_
MAP KEYS TERMINATED BY ':'
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@orc_create_staging
POSTHOOK: query: CREATE TABLE orc_create_staging (
str STRING,
mp MAP<STRING,STRING>,
@@ -86,6 +87,7 @@ PREHOOK: query: CREATE TABLE orc_create
STORED AS ORC
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@orc_create
POSTHOOK: query: CREATE TABLE orc_create (key INT, value STRING)
PARTITIONED BY (ds string)
STORED AS ORC
@@ -140,6 +142,7 @@ PREHOOK: query: CREATE TABLE orc_create
PARTITIONED BY (ds string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@orc_create
POSTHOOK: query: CREATE TABLE orc_create (key INT, value STRING)
PARTITIONED BY (ds string)
POSTHOOK: type: CREATETABLE
@@ -237,6 +240,7 @@ PREHOOK: query: CREATE TABLE orc_create
PARTITIONED BY (ds string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@orc_create
POSTHOOK: query: CREATE TABLE orc_create (key INT, value STRING)
PARTITIONED BY (ds string)
POSTHOOK: type: CREATETABLE
@@ -286,6 +290,7 @@ PREHOOK: query: CREATE TABLE orc_create_
) STORED AS ORC
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@orc_create_complex
POSTHOOK: query: CREATE TABLE orc_create_complex (
str STRING,
mp MAP<STRING,STRING>,
@@ -424,6 +429,7 @@ PREHOOK: query: CREATE TABLE orc_create_
state string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@orc_create_people_staging
POSTHOOK: query: CREATE TABLE orc_create_people_staging (
id int,
first_name string,
@@ -456,6 +462,7 @@ PARTITIONED BY (state string)
STORED AS orc
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@orc_create_people
POSTHOOK: query: CREATE TABLE orc_create_people (
id int,
first_name string,
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/orc_createas1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/orc_createas1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/orc_createas1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/orc_createas1.q.out Fri Aug 22 21:36:47 2014
@@ -14,6 +14,7 @@ PREHOOK: query: CREATE TABLE orc_createa
PARTITIONED BY (ds string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@orc_createas1a
POSTHOOK: query: CREATE TABLE orc_createas1a (key INT, value STRING)
PARTITIONED BY (ds string)
POSTHOOK: type: CREATETABLE
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/orc_dictionary_threshold.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/orc_dictionary_threshold.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/orc_dictionary_threshold.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/orc_dictionary_threshold.q.out Fri Aug 22 21:36:47 2014
@@ -8,6 +8,7 @@ STORED AS INPUTFORMAT 'org.apache.hadoop
OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat'
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@test_orc
POSTHOOK: query: -- Set the threshold to -1 to guarantee dictionary encoding is turned off
-- Tests that the data can be read back correctly when a string column is stored
-- without dictionary encoding
@@ -63,6 +64,7 @@ POSTHOOK: Output: default@test_orc
PREHOOK: query: CREATE TABLE src_thousand(key STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@src_thousand
POSTHOOK: query: CREATE TABLE src_thousand(key STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/orc_diff_part_cols.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/orc_diff_part_cols.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/orc_diff_part_cols.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/orc_diff_part_cols.q.out Fri Aug 22 21:36:47 2014
@@ -7,6 +7,7 @@ STORED AS INPUTFORMAT 'org.apache.hadoop
OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat'
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@test_orc
POSTHOOK: query: -- SORT_QUERY_RESULTS
CREATE TABLE test_orc (key STRING)
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/orc_diff_part_cols2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/orc_diff_part_cols2.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/orc_diff_part_cols2.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/orc_diff_part_cols2.q.out Fri Aug 22 21:36:47 2014
@@ -7,6 +7,7 @@ CREATE TABLE test_orc (key STRING)
STORED AS ORC
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@test_orc
POSTHOOK: query: -- Create a table with one column, write to it, then add an additional column
-- This can break reads