You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by pr...@apache.org on 2016/08/24 20:57:09 UTC
[15/51] [partial] hive git commit: HIVE-14553: Remove tez golden
files after HIVE-14502 (Prasanth Jayachandran reviewed by Siddharth Seth)
http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/insert_into2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/insert_into2.q.out b/ql/src/test/results/clientpositive/tez/insert_into2.q.out
deleted file mode 100644
index 54abec4..0000000
--- a/ql/src/test/results/clientpositive/tez/insert_into2.q.out
+++ /dev/null
@@ -1,516 +0,0 @@
-PREHOOK: query: DROP TABLE insert_into2
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE insert_into2
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: CREATE TABLE insert_into2 (key int, value string)
- PARTITIONED BY (ds string)
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@insert_into2
-POSTHOOK: query: CREATE TABLE insert_into2 (key int, value string)
- PARTITIONED BY (ds string)
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@insert_into2
-PREHOOK: query: EXPLAIN INSERT INTO TABLE insert_into2 PARTITION (ds='1')
- SELECT * FROM src order by key LIMIT 100
-PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN INSERT INTO TABLE insert_into2 PARTITION (ds='1')
- SELECT * FROM src order by key LIMIT 100
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-2 depends on stages: Stage-1
- Stage-0 depends on stages: Stage-2
- Stage-3 depends on stages: Stage-0
-
-STAGE PLANS:
- Stage: Stage-1
- Tez
-#### A masked pattern was here ####
- Edges:
- Reducer 2 <- Map 1 (SIMPLE_EDGE)
-#### A masked pattern was here ####
- Vertices:
- Map 1
- Map Operator Tree:
- TableScan
- alias: src
- Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
- Select Operator
- expressions: key (type: string), value (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
- Reduce Output Operator
- key expressions: _col0 (type: string)
- sort order: +
- Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
- TopN Hash Memory Usage: 0.1
- value expressions: _col1 (type: string)
- Reducer 2
- Reduce Operator Tree:
- Select Operator
- expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
- Limit
- Number of rows: 100
- Statistics: Num rows: 100 Data size: 17800 Basic stats: COMPLETE Column stats: COMPLETE
- Select Operator
- expressions: UDFToInteger(_col0) (type: int), _col1 (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 100 Data size: 9500 Basic stats: COMPLETE Column stats: COMPLETE
- File Output Operator
- compressed: false
- Statistics: Num rows: 100 Data size: 9500 Basic stats: COMPLETE Column stats: COMPLETE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.insert_into2
-
- Stage: Stage-2
- Dependency Collection
-
- Stage: Stage-0
- Move Operator
- tables:
- partition:
- ds 1
- replace: false
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.insert_into2
-
- Stage: Stage-3
- Stats-Aggr Operator
-
-PREHOOK: query: INSERT INTO TABLE insert_into2 PARTITION (ds='1') SELECT * FROM src order by key limit 100
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src
-PREHOOK: Output: default@insert_into2@ds=1
-POSTHOOK: query: INSERT INTO TABLE insert_into2 PARTITION (ds='1') SELECT * FROM src order by key limit 100
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
-POSTHOOK: Output: default@insert_into2@ds=1
-POSTHOOK: Lineage: insert_into2 PARTITION(ds=1).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: insert_into2 PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: explain
-select count (*) from insert_into2 where ds = '1'
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-select count (*) from insert_into2 where ds = '1'
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
- Stage-0 is a root stage
-
-STAGE PLANS:
- Stage: Stage-0
- Fetch Operator
- limit: 1
- Processor Tree:
- ListSink
-
-PREHOOK: query: select count (*) from insert_into2 where ds = '1'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@insert_into2
-#### A masked pattern was here ####
-POSTHOOK: query: select count (*) from insert_into2 where ds = '1'
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@insert_into2
-#### A masked pattern was here ####
-100
-PREHOOK: query: INSERT INTO TABLE insert_into2 PARTITION (ds='1') SELECT * FROM src order by key limit 100
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src
-PREHOOK: Output: default@insert_into2@ds=1
-POSTHOOK: query: INSERT INTO TABLE insert_into2 PARTITION (ds='1') SELECT * FROM src order by key limit 100
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
-POSTHOOK: Output: default@insert_into2@ds=1
-POSTHOOK: Lineage: insert_into2 PARTITION(ds=1).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: insert_into2 PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: explain
-SELECT COUNT(*) FROM insert_into2 WHERE ds='1'
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-SELECT COUNT(*) FROM insert_into2 WHERE ds='1'
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
- Stage-0 is a root stage
-
-STAGE PLANS:
- Stage: Stage-0
- Fetch Operator
- limit: 1
- Processor Tree:
- ListSink
-
-PREHOOK: query: SELECT COUNT(*) FROM insert_into2 WHERE ds='1'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@insert_into2
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT COUNT(*) FROM insert_into2 WHERE ds='1'
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@insert_into2
-#### A masked pattern was here ####
-200
-PREHOOK: query: SELECT SUM(HASH(c)) FROM (
- SELECT TRANSFORM(*) USING 'tr \t _' AS (c) FROM insert_into2
-) t
-PREHOOK: type: QUERY
-PREHOOK: Input: default@insert_into2
-PREHOOK: Input: default@insert_into2@ds=1
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT SUM(HASH(c)) FROM (
- SELECT TRANSFORM(*) USING 'tr \t _' AS (c) FROM insert_into2
-) t
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@insert_into2
-POSTHOOK: Input: default@insert_into2@ds=1
-#### A masked pattern was here ####
--39568181484
-PREHOOK: query: EXPLAIN INSERT OVERWRITE TABLE insert_into2 PARTITION (ds='2')
- SELECT * FROM src order by key LIMIT 100
-PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE insert_into2 PARTITION (ds='2')
- SELECT * FROM src order by key LIMIT 100
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-2 depends on stages: Stage-1
- Stage-0 depends on stages: Stage-2
- Stage-3 depends on stages: Stage-0
-
-STAGE PLANS:
- Stage: Stage-1
- Tez
-#### A masked pattern was here ####
- Edges:
- Reducer 2 <- Map 1 (SIMPLE_EDGE)
-#### A masked pattern was here ####
- Vertices:
- Map 1
- Map Operator Tree:
- TableScan
- alias: src
- Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
- Select Operator
- expressions: key (type: string), value (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
- Reduce Output Operator
- key expressions: _col0 (type: string)
- sort order: +
- Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
- TopN Hash Memory Usage: 0.1
- value expressions: _col1 (type: string)
- Reducer 2
- Reduce Operator Tree:
- Select Operator
- expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
- Limit
- Number of rows: 100
- Statistics: Num rows: 100 Data size: 17800 Basic stats: COMPLETE Column stats: COMPLETE
- Select Operator
- expressions: UDFToInteger(_col0) (type: int), _col1 (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 100 Data size: 9500 Basic stats: COMPLETE Column stats: COMPLETE
- File Output Operator
- compressed: false
- Statistics: Num rows: 100 Data size: 9500 Basic stats: COMPLETE Column stats: COMPLETE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.insert_into2
-
- Stage: Stage-2
- Dependency Collection
-
- Stage: Stage-0
- Move Operator
- tables:
- partition:
- ds 2
- replace: true
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.insert_into2
-
- Stage: Stage-3
- Stats-Aggr Operator
-
-PREHOOK: query: INSERT OVERWRITE TABLE insert_into2 PARTITION (ds='2')
- SELECT * FROM src order by key LIMIT 100
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src
-PREHOOK: Output: default@insert_into2@ds=2
-POSTHOOK: query: INSERT OVERWRITE TABLE insert_into2 PARTITION (ds='2')
- SELECT * FROM src order by key LIMIT 100
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
-POSTHOOK: Output: default@insert_into2@ds=2
-POSTHOOK: Lineage: insert_into2 PARTITION(ds=2).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: insert_into2 PARTITION(ds=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: SELECT SUM(HASH(c)) FROM (
- SELECT TRANSFORM(*) USING 'tr \t _' AS (c) FROM insert_into2
-) t
-PREHOOK: type: QUERY
-PREHOOK: Input: default@insert_into2
-PREHOOK: Input: default@insert_into2@ds=1
-PREHOOK: Input: default@insert_into2@ds=2
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT SUM(HASH(c)) FROM (
- SELECT TRANSFORM(*) USING 'tr \t _' AS (c) FROM insert_into2
-) t
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@insert_into2
-POSTHOOK: Input: default@insert_into2@ds=1
-POSTHOOK: Input: default@insert_into2@ds=2
-#### A masked pattern was here ####
--59352272126
-PREHOOK: query: explain
-SELECT COUNT(*) FROM insert_into2 WHERE ds='2'
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-SELECT COUNT(*) FROM insert_into2 WHERE ds='2'
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
- Stage-0 is a root stage
-
-STAGE PLANS:
- Stage: Stage-0
- Fetch Operator
- limit: 1
- Processor Tree:
- ListSink
-
-PREHOOK: query: SELECT COUNT(*) FROM insert_into2 WHERE ds='2'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@insert_into2
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT COUNT(*) FROM insert_into2 WHERE ds='2'
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@insert_into2
-#### A masked pattern was here ####
-100
-PREHOOK: query: EXPLAIN INSERT OVERWRITE TABLE insert_into2 PARTITION (ds='2')
- SELECT * FROM src order by key LIMIT 50
-PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE insert_into2 PARTITION (ds='2')
- SELECT * FROM src order by key LIMIT 50
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-2 depends on stages: Stage-1
- Stage-0 depends on stages: Stage-2
- Stage-3 depends on stages: Stage-0
-
-STAGE PLANS:
- Stage: Stage-1
- Tez
-#### A masked pattern was here ####
- Edges:
- Reducer 2 <- Map 1 (SIMPLE_EDGE)
-#### A masked pattern was here ####
- Vertices:
- Map 1
- Map Operator Tree:
- TableScan
- alias: src
- Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
- Select Operator
- expressions: key (type: string), value (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
- Reduce Output Operator
- key expressions: _col0 (type: string)
- sort order: +
- Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
- TopN Hash Memory Usage: 0.1
- value expressions: _col1 (type: string)
- Reducer 2
- Reduce Operator Tree:
- Select Operator
- expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
- Limit
- Number of rows: 50
- Statistics: Num rows: 50 Data size: 8900 Basic stats: COMPLETE Column stats: COMPLETE
- Select Operator
- expressions: UDFToInteger(_col0) (type: int), _col1 (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 50 Data size: 4750 Basic stats: COMPLETE Column stats: COMPLETE
- File Output Operator
- compressed: false
- Statistics: Num rows: 50 Data size: 4750 Basic stats: COMPLETE Column stats: COMPLETE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.insert_into2
-
- Stage: Stage-2
- Dependency Collection
-
- Stage: Stage-0
- Move Operator
- tables:
- partition:
- ds 2
- replace: true
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.insert_into2
-
- Stage: Stage-3
- Stats-Aggr Operator
-
-PREHOOK: query: INSERT OVERWRITE TABLE insert_into2 PARTITION (ds='2')
- SELECT * FROM src order by key LIMIT 50
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src
-PREHOOK: Output: default@insert_into2@ds=2
-POSTHOOK: query: INSERT OVERWRITE TABLE insert_into2 PARTITION (ds='2')
- SELECT * FROM src order by key LIMIT 50
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
-POSTHOOK: Output: default@insert_into2@ds=2
-POSTHOOK: Lineage: insert_into2 PARTITION(ds=2).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: insert_into2 PARTITION(ds=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: SELECT SUM(HASH(c)) FROM (
- SELECT TRANSFORM(*) USING 'tr \t _' AS (c) FROM insert_into2
-) t
-PREHOOK: type: QUERY
-PREHOOK: Input: default@insert_into2
-PREHOOK: Input: default@insert_into2@ds=1
-PREHOOK: Input: default@insert_into2@ds=2
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT SUM(HASH(c)) FROM (
- SELECT TRANSFORM(*) USING 'tr \t _' AS (c) FROM insert_into2
-) t
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@insert_into2
-POSTHOOK: Input: default@insert_into2@ds=1
-POSTHOOK: Input: default@insert_into2@ds=2
-#### A masked pattern was here ####
--33609711132
-PREHOOK: query: explain
-SELECT COUNT(*) FROM insert_into2 WHERE ds='2'
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-SELECT COUNT(*) FROM insert_into2 WHERE ds='2'
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
- Stage-0 is a root stage
-
-STAGE PLANS:
- Stage: Stage-0
- Fetch Operator
- limit: 1
- Processor Tree:
- ListSink
-
-PREHOOK: query: SELECT COUNT(*) FROM insert_into2 WHERE ds='2'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@insert_into2
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT COUNT(*) FROM insert_into2 WHERE ds='2'
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@insert_into2
-#### A masked pattern was here ####
-50
-PREHOOK: query: insert into table insert_into2 partition (ds='2') values(1, 'abc')
-PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
-PREHOOK: Output: default@insert_into2@ds=2
-POSTHOOK: query: insert into table insert_into2 partition (ds='2') values(1, 'abc')
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
-POSTHOOK: Output: default@insert_into2@ds=2
-POSTHOOK: Lineage: insert_into2 PARTITION(ds=2).key EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
-POSTHOOK: Lineage: insert_into2 PARTITION(ds=2).value SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-PREHOOK: query: explain
-SELECT COUNT(*) FROM insert_into2 where ds='2'
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-SELECT COUNT(*) FROM insert_into2 where ds='2'
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Tez
-#### A masked pattern was here ####
- Edges:
- Reducer 2 <- Map 1 (SIMPLE_EDGE)
-#### A masked pattern was here ####
- Vertices:
- Map 1
- Map Operator Tree:
- TableScan
- alias: insert_into2
- Statistics: Num rows: 50 Data size: 930 Basic stats: COMPLETE Column stats: COMPLETE
- Select Operator
- Statistics: Num rows: 50 Data size: 930 Basic stats: COMPLETE Column stats: COMPLETE
- Group By Operator
- aggregations: count()
- mode: hash
- outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
- Reduce Output Operator
- sort order:
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
- value expressions: _col0 (type: bigint)
- Reducer 2
- Reduce Operator Tree:
- Group By Operator
- aggregations: count(VALUE._col0)
- mode: mergepartial
- outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
- File Output Operator
- compressed: false
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
- table:
- input format: org.apache.hadoop.mapred.SequenceFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
- Stage: Stage-0
- Fetch Operator
- limit: -1
- Processor Tree:
- ListSink
-
-PREHOOK: query: select count(*) from insert_into2 where ds='2'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@insert_into2
-PREHOOK: Input: default@insert_into2@ds=2
-#### A masked pattern was here ####
-POSTHOOK: query: select count(*) from insert_into2 where ds='2'
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@insert_into2
-POSTHOOK: Input: default@insert_into2@ds=2
-#### A masked pattern was here ####
-51
-PREHOOK: query: DROP TABLE insert_into2
-PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@insert_into2
-PREHOOK: Output: default@insert_into2
-POSTHOOK: query: DROP TABLE insert_into2
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@insert_into2
-POSTHOOK: Output: default@insert_into2
http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/insert_orig_table.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/insert_orig_table.q.out b/ql/src/test/results/clientpositive/tez/insert_orig_table.q.out
deleted file mode 100644
index 5eea74d..0000000
--- a/ql/src/test/results/clientpositive/tez/insert_orig_table.q.out
+++ /dev/null
@@ -1,80 +0,0 @@
-PREHOOK: query: create table acid_iot(
- ctinyint TINYINT,
- csmallint SMALLINT,
- cint INT,
- cbigint BIGINT,
- cfloat FLOAT,
- cdouble DOUBLE,
- cstring1 STRING,
- cstring2 STRING,
- ctimestamp1 TIMESTAMP,
- ctimestamp2 TIMESTAMP,
- cboolean1 BOOLEAN,
- cboolean2 BOOLEAN) clustered by (cint) into 1 buckets stored as orc TBLPROPERTIES ('transactional'='true')
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@acid_iot
-POSTHOOK: query: create table acid_iot(
- ctinyint TINYINT,
- csmallint SMALLINT,
- cint INT,
- cbigint BIGINT,
- cfloat FLOAT,
- cdouble DOUBLE,
- cstring1 STRING,
- cstring2 STRING,
- ctimestamp1 TIMESTAMP,
- ctimestamp2 TIMESTAMP,
- cboolean1 BOOLEAN,
- cboolean2 BOOLEAN) clustered by (cint) into 1 buckets stored as orc TBLPROPERTIES ('transactional'='true')
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@acid_iot
-PREHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/alltypesorc" into table acid_iot
-PREHOOK: type: LOAD
-#### A masked pattern was here ####
-PREHOOK: Output: default@acid_iot
-POSTHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/alltypesorc" into table acid_iot
-POSTHOOK: type: LOAD
-#### A masked pattern was here ####
-POSTHOOK: Output: default@acid_iot
-PREHOOK: query: select count(*) from acid_iot
-PREHOOK: type: QUERY
-PREHOOK: Input: default@acid_iot
-#### A masked pattern was here ####
-POSTHOOK: query: select count(*) from acid_iot
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@acid_iot
-#### A masked pattern was here ####
-12288
-PREHOOK: query: insert into table acid_iot select ctinyint, csmallint, cint, cbigint, cfloat, cdouble, cstring1, cstring2, ctimestamp1, ctimestamp2,
- cboolean1, cboolean2 from alltypesorc where cint < 0 order by cint limit 10
-PREHOOK: type: QUERY
-PREHOOK: Input: default@alltypesorc
-PREHOOK: Output: default@acid_iot
-POSTHOOK: query: insert into table acid_iot select ctinyint, csmallint, cint, cbigint, cfloat, cdouble, cstring1, cstring2, ctimestamp1, ctimestamp2,
- cboolean1, cboolean2 from alltypesorc where cint < 0 order by cint limit 10
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@alltypesorc
-POSTHOOK: Output: default@acid_iot
-POSTHOOK: Lineage: acid_iot.cbigint SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cbigint, type:bigint, comment:null), ]
-POSTHOOK: Lineage: acid_iot.cboolean1 SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cboolean1, type:boolean, comment:null), ]
-POSTHOOK: Lineage: acid_iot.cboolean2 SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cboolean2, type:boolean, comment:null), ]
-POSTHOOK: Lineage: acid_iot.cdouble SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cdouble, type:double, comment:null), ]
-POSTHOOK: Lineage: acid_iot.cfloat SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cfloat, type:float, comment:null), ]
-POSTHOOK: Lineage: acid_iot.cint SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
-POSTHOOK: Lineage: acid_iot.csmallint SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:csmallint, type:smallint, comment:null), ]
-POSTHOOK: Lineage: acid_iot.cstring1 SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
-POSTHOOK: Lineage: acid_iot.cstring2 SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cstring2, type:string, comment:null), ]
-POSTHOOK: Lineage: acid_iot.ctimestamp1 SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:ctimestamp1, type:timestamp, comment:null), ]
-POSTHOOK: Lineage: acid_iot.ctimestamp2 SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:ctimestamp2, type:timestamp, comment:null), ]
-POSTHOOK: Lineage: acid_iot.ctinyint SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:ctinyint, type:tinyint, comment:null), ]
-PREHOOK: query: select count(*) from acid_iot
-PREHOOK: type: QUERY
-PREHOOK: Input: default@acid_iot
-#### A masked pattern was here ####
-POSTHOOK: query: select count(*) from acid_iot
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@acid_iot
-#### A masked pattern was here ####
-12298
http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/insert_update_delete.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/insert_update_delete.q.out b/ql/src/test/results/clientpositive/tez/insert_update_delete.q.out
deleted file mode 100644
index 9a3cf4b..0000000
--- a/ql/src/test/results/clientpositive/tez/insert_update_delete.q.out
+++ /dev/null
@@ -1,78 +0,0 @@
-PREHOOK: query: create table acid_iud(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@acid_iud
-POSTHOOK: query: create table acid_iud(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@acid_iud
-PREHOOK: query: insert into table acid_iud select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint < 0 order by cint limit 10
-PREHOOK: type: QUERY
-PREHOOK: Input: default@alltypesorc
-PREHOOK: Output: default@acid_iud
-POSTHOOK: query: insert into table acid_iud select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint < 0 order by cint limit 10
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@alltypesorc
-POSTHOOK: Output: default@acid_iud
-POSTHOOK: Lineage: acid_iud.a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
-POSTHOOK: Lineage: acid_iud.b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
-PREHOOK: query: select a,b from acid_iud order by a
-PREHOOK: type: QUERY
-PREHOOK: Input: default@acid_iud
-#### A masked pattern was here ####
-POSTHOOK: query: select a,b from acid_iud order by a
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@acid_iud
-#### A masked pattern was here ####
--1073279343 oj1YrV5Wa
--1073051226 A34p7oRr2WvUJNf
--1072910839 0iqrc5
--1072081801 dPkN74F7
--1072076362 2uLyD28144vklju213J1mr
--1071480828 aw724t8c5558x2xneC624
--1071363017 Anj0oF
--1070883071 0ruyd6Y50JpdGRf6HqD
--1070551679 iUR3Q
--1069736047 k17Am8uPHWk02cEf1jet
-PREHOOK: query: update acid_iud set b = 'fred'
-PREHOOK: type: QUERY
-PREHOOK: Input: default@acid_iud
-PREHOOK: Output: default@acid_iud
-POSTHOOK: query: update acid_iud set b = 'fred'
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@acid_iud
-POSTHOOK: Output: default@acid_iud
-PREHOOK: query: select a,b from acid_iud order by a
-PREHOOK: type: QUERY
-PREHOOK: Input: default@acid_iud
-#### A masked pattern was here ####
-POSTHOOK: query: select a,b from acid_iud order by a
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@acid_iud
-#### A masked pattern was here ####
--1073279343 fred
--1073051226 fred
--1072910839 fred
--1072081801 fred
--1072076362 fred
--1071480828 fred
--1071363017 fred
--1070883071 fred
--1070551679 fred
--1069736047 fred
-PREHOOK: query: delete from acid_iud
-PREHOOK: type: QUERY
-PREHOOK: Input: default@acid_iud
-PREHOOK: Output: default@acid_iud
-POSTHOOK: query: delete from acid_iud
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@acid_iud
-POSTHOOK: Output: default@acid_iud
-PREHOOK: query: select a,b from acid_iud order by a
-PREHOOK: type: QUERY
-PREHOOK: Input: default@acid_iud
-#### A masked pattern was here ####
-POSTHOOK: query: select a,b from acid_iud order by a
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@acid_iud
-#### A masked pattern was here ####
http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/insert_values_acid_not_bucketed.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/insert_values_acid_not_bucketed.q.out b/ql/src/test/results/clientpositive/tez/insert_values_acid_not_bucketed.q.out
deleted file mode 100644
index 4f8ddfa..0000000
--- a/ql/src/test/results/clientpositive/tez/insert_values_acid_not_bucketed.q.out
+++ /dev/null
@@ -1,28 +0,0 @@
-PREHOOK: query: create table acid_notbucketed(a int, b varchar(128)) stored as orc
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@acid_notbucketed
-POSTHOOK: query: create table acid_notbucketed(a int, b varchar(128)) stored as orc
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@acid_notbucketed
-PREHOOK: query: insert into table acid_notbucketed values (1, 'abc'), (2, 'def')
-PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
-PREHOOK: Output: default@acid_notbucketed
-POSTHOOK: query: insert into table acid_notbucketed values (1, 'abc'), (2, 'def')
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
-POSTHOOK: Output: default@acid_notbucketed
-POSTHOOK: Lineage: acid_notbucketed.a EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
-POSTHOOK: Lineage: acid_notbucketed.b EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-PREHOOK: query: select * from acid_notbucketed
-PREHOOK: type: QUERY
-PREHOOK: Input: default@acid_notbucketed
-#### A masked pattern was here ####
-POSTHOOK: query: select * from acid_notbucketed
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@acid_notbucketed
-#### A masked pattern was here ####
-1 abc
-2 def
http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/insert_values_dynamic_partitioned.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/insert_values_dynamic_partitioned.q.out b/ql/src/test/results/clientpositive/tez/insert_values_dynamic_partitioned.q.out
deleted file mode 100644
index 773feb4..0000000
--- a/ql/src/test/results/clientpositive/tez/insert_values_dynamic_partitioned.q.out
+++ /dev/null
@@ -1,45 +0,0 @@
-PREHOOK: query: create table ivdp(i int,
- de decimal(5,2),
- vc varchar(128)) partitioned by (ds string) clustered by (i) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@ivdp
-POSTHOOK: query: create table ivdp(i int,
- de decimal(5,2),
- vc varchar(128)) partitioned by (ds string) clustered by (i) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@ivdp
-PREHOOK: query: insert into table ivdp partition (ds) values
- (1, 109.23, 'and everywhere that mary went', 'today'),
- (6553, 923.19, 'the lamb was sure to go', 'tomorrow')
-PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
-PREHOOK: Output: default@ivdp
-POSTHOOK: query: insert into table ivdp partition (ds) values
- (1, 109.23, 'and everywhere that mary went', 'today'),
- (6553, 923.19, 'the lamb was sure to go', 'tomorrow')
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
-POSTHOOK: Output: default@ivdp@ds=today
-POSTHOOK: Output: default@ivdp@ds=tomorrow
-POSTHOOK: Lineage: ivdp PARTITION(ds=today).de EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: ivdp PARTITION(ds=today).i EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
-POSTHOOK: Lineage: ivdp PARTITION(ds=today).vc EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: ivdp PARTITION(ds=tomorrow).de EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: ivdp PARTITION(ds=tomorrow).i EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
-POSTHOOK: Lineage: ivdp PARTITION(ds=tomorrow).vc EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-PREHOOK: query: select * from ivdp order by ds
-PREHOOK: type: QUERY
-PREHOOK: Input: default@ivdp
-PREHOOK: Input: default@ivdp@ds=today
-PREHOOK: Input: default@ivdp@ds=tomorrow
-#### A masked pattern was here ####
-POSTHOOK: query: select * from ivdp order by ds
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@ivdp
-POSTHOOK: Input: default@ivdp@ds=today
-POSTHOOK: Input: default@ivdp@ds=tomorrow
-#### A masked pattern was here ####
-1 109.23 and everywhere that mary went today
-6553 923.19 the lamb was sure to go tomorrow
http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/insert_values_non_partitioned.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/insert_values_non_partitioned.q.out b/ql/src/test/results/clientpositive/tez/insert_values_non_partitioned.q.out
deleted file mode 100644
index 5b1c3cc..0000000
--- a/ql/src/test/results/clientpositive/tez/insert_values_non_partitioned.q.out
+++ /dev/null
@@ -1,70 +0,0 @@
-PREHOOK: query: create table acid_ivnp(ti tinyint,
- si smallint,
- i int,
- bi bigint,
- f float,
- d double,
- de decimal(5,2),
- t timestamp,
- dt date,
- b boolean,
- s string,
- vc varchar(128),
- ch char(12)) clustered by (i) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@acid_ivnp
-POSTHOOK: query: create table acid_ivnp(ti tinyint,
- si smallint,
- i int,
- bi bigint,
- f float,
- d double,
- de decimal(5,2),
- t timestamp,
- dt date,
- b boolean,
- s string,
- vc varchar(128),
- ch char(12)) clustered by (i) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@acid_ivnp
-PREHOOK: query: insert into table acid_ivnp values
- (1, 257, 65537, 4294967297, 3.14, 3.141592654, 109.23, '2014-08-25 17:21:30.0', '2014-08-25', true, 'mary had a little lamb', 'ring around the rosie', 'red'),
- (null, null, null, null, null, null, null, null, null, null, null, null, null),
- (3, 25, 6553, null, 0.14, 1923.141592654, 1.2301, '2014-08-24 17:21:30.0', '2014-08-26', false, 'its fleece was white as snow', 'a pocket full of posies', 'blue' )
-PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
-PREHOOK: Output: default@acid_ivnp
-POSTHOOK: query: insert into table acid_ivnp values
- (1, 257, 65537, 4294967297, 3.14, 3.141592654, 109.23, '2014-08-25 17:21:30.0', '2014-08-25', true, 'mary had a little lamb', 'ring around the rosie', 'red'),
- (null, null, null, null, null, null, null, null, null, null, null, null, null),
- (3, 25, 6553, null, 0.14, 1923.141592654, 1.2301, '2014-08-24 17:21:30.0', '2014-08-26', false, 'its fleece was white as snow', 'a pocket full of posies', 'blue' )
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
-POSTHOOK: Output: default@acid_ivnp
-POSTHOOK: Lineage: acid_ivnp.b EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col10, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivnp.bi EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivnp.ch EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col13, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivnp.d EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col6, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivnp.de EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col7, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivnp.dt EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col9, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivnp.f EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col5, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivnp.i EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivnp.s SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col11, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivnp.si EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivnp.t EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col8, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivnp.ti EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivnp.vc EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col12, type:string, comment:), ]
-PREHOOK: query: select * from acid_ivnp order by ti
-PREHOOK: type: QUERY
-PREHOOK: Input: default@acid_ivnp
-#### A masked pattern was here ####
-POSTHOOK: query: select * from acid_ivnp order by ti
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@acid_ivnp
-#### A masked pattern was here ####
-NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
-1 257 65537 4294967297 3.14 3.141592654 109.23 2014-08-25 17:21:30 2014-08-25 true mary had a little lamb ring around the rosie red
-3 25 6553 NULL 0.14 1923.141592654 1.23 2014-08-24 17:21:30 2014-08-26 false its fleece was white as snow a pocket full of posies blue
http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/insert_values_orig_table.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/insert_values_orig_table.q.out b/ql/src/test/results/clientpositive/tez/insert_values_orig_table.q.out
deleted file mode 100644
index 684cd1b..0000000
--- a/ql/src/test/results/clientpositive/tez/insert_values_orig_table.q.out
+++ /dev/null
@@ -1,82 +0,0 @@
-PREHOOK: query: create table acid_ivot(
- ctinyint TINYINT,
- csmallint SMALLINT,
- cint INT,
- cbigint BIGINT,
- cfloat FLOAT,
- cdouble DOUBLE,
- cstring1 STRING,
- cstring2 STRING,
- ctimestamp1 TIMESTAMP,
- ctimestamp2 TIMESTAMP,
- cboolean1 BOOLEAN,
- cboolean2 BOOLEAN) clustered by (cint) into 1 buckets stored as orc TBLPROPERTIES ('transactional'='true')
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@acid_ivot
-POSTHOOK: query: create table acid_ivot(
- ctinyint TINYINT,
- csmallint SMALLINT,
- cint INT,
- cbigint BIGINT,
- cfloat FLOAT,
- cdouble DOUBLE,
- cstring1 STRING,
- cstring2 STRING,
- ctimestamp1 TIMESTAMP,
- ctimestamp2 TIMESTAMP,
- cboolean1 BOOLEAN,
- cboolean2 BOOLEAN) clustered by (cint) into 1 buckets stored as orc TBLPROPERTIES ('transactional'='true')
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@acid_ivot
-PREHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/alltypesorc" into table acid_ivot
-PREHOOK: type: LOAD
-#### A masked pattern was here ####
-PREHOOK: Output: default@acid_ivot
-POSTHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/alltypesorc" into table acid_ivot
-POSTHOOK: type: LOAD
-#### A masked pattern was here ####
-POSTHOOK: Output: default@acid_ivot
-PREHOOK: query: select count(*) from acid_ivot
-PREHOOK: type: QUERY
-PREHOOK: Input: default@acid_ivot
-#### A masked pattern was here ####
-POSTHOOK: query: select count(*) from acid_ivot
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@acid_ivot
-#### A masked pattern was here ####
-12288
-PREHOOK: query: insert into table acid_ivot values
- (1, 2, 3, 4, 3.14, 2.34, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true),
- (111, 222, 3333, 444, 13.14, 10239302.34239320, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true)
-PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
-PREHOOK: Output: default@acid_ivot
-POSTHOOK: query: insert into table acid_ivot values
- (1, 2, 3, 4, 3.14, 2.34, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true),
- (111, 222, 3333, 444, 13.14, 10239302.34239320, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
-POSTHOOK: Output: default@acid_ivot
-POSTHOOK: Lineage: acid_ivot.cbigint EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivot.cboolean1 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col11, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivot.cboolean2 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col12, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivot.cdouble EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col6, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivot.cfloat EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col5, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivot.cint EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivot.csmallint EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivot.cstring1 SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col7, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivot.cstring2 SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col8, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivot.ctimestamp1 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col9, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivot.ctimestamp2 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col10, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivot.ctinyint EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
-PREHOOK: query: select count(*) from acid_ivot
-PREHOOK: type: QUERY
-PREHOOK: Input: default@acid_ivot
-#### A masked pattern was here ####
-POSTHOOK: query: select count(*) from acid_ivot
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@acid_ivot
-#### A masked pattern was here ####
-12290
http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/insert_values_partitioned.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/insert_values_partitioned.q.out b/ql/src/test/results/clientpositive/tez/insert_values_partitioned.q.out
deleted file mode 100644
index 6681992..0000000
--- a/ql/src/test/results/clientpositive/tez/insert_values_partitioned.q.out
+++ /dev/null
@@ -1,66 +0,0 @@
-PREHOOK: query: create table acid_ivp(ti tinyint,
- si smallint,
- i int,
- bi bigint,
- f float,
- d double,
- de decimal(5,2),
- t timestamp,
- dt date,
- s string,
- vc varchar(128),
- ch char(12)) partitioned by (ds string) clustered by (i) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@acid_ivp
-POSTHOOK: query: create table acid_ivp(ti tinyint,
- si smallint,
- i int,
- bi bigint,
- f float,
- d double,
- de decimal(5,2),
- t timestamp,
- dt date,
- s string,
- vc varchar(128),
- ch char(12)) partitioned by (ds string) clustered by (i) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@acid_ivp
-PREHOOK: query: insert into table acid_ivp partition (ds='today') values
- (1, 257, 65537, 4294967297, 3.14, 3.141592654, 109.23, '2014-08-25 17:21:30.0', '2014-08-25', 'mary had a little lamb', 'ring around the rosie', 'red'),
- (3, 25, 6553, 429496729, 0.14, 1923.141592654, 1.2301, '2014-08-24 17:21:30.0', '2014-08-26', 'its fleece was white as snow', 'a pocket full of posies', 'blue')
-PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
-PREHOOK: Output: default@acid_ivp@ds=today
-POSTHOOK: query: insert into table acid_ivp partition (ds='today') values
- (1, 257, 65537, 4294967297, 3.14, 3.141592654, 109.23, '2014-08-25 17:21:30.0', '2014-08-25', 'mary had a little lamb', 'ring around the rosie', 'red'),
- (3, 25, 6553, 429496729, 0.14, 1923.141592654, 1.2301, '2014-08-24 17:21:30.0', '2014-08-26', 'its fleece was white as snow', 'a pocket full of posies', 'blue')
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
-POSTHOOK: Output: default@acid_ivp@ds=today
-POSTHOOK: Lineage: acid_ivp PARTITION(ds=today).bi EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivp PARTITION(ds=today).ch EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col12, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivp PARTITION(ds=today).d EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col6, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivp PARTITION(ds=today).de EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col7, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivp PARTITION(ds=today).dt EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col9, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivp PARTITION(ds=today).f EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col5, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivp PARTITION(ds=today).i EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivp PARTITION(ds=today).s SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col10, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivp PARTITION(ds=today).si EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivp PARTITION(ds=today).t EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col8, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivp PARTITION(ds=today).ti EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivp PARTITION(ds=today).vc EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col11, type:string, comment:), ]
-PREHOOK: query: select * from acid_ivp order by i
-PREHOOK: type: QUERY
-PREHOOK: Input: default@acid_ivp
-PREHOOK: Input: default@acid_ivp@ds=today
-#### A masked pattern was here ####
-POSTHOOK: query: select * from acid_ivp order by i
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@acid_ivp
-POSTHOOK: Input: default@acid_ivp@ds=today
-#### A masked pattern was here ####
-3 25 6553 429496729 0.14 1923.141592654 1.23 2014-08-24 17:21:30 2014-08-26 its fleece was white as snow a pocket full of posies blue today
-1 257 65537 4294967297 3.14 3.141592654 109.23 2014-08-25 17:21:30 2014-08-25 mary had a little lamb ring around the rosie red today
http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/insert_values_tmp_table.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/insert_values_tmp_table.q.out b/ql/src/test/results/clientpositive/tez/insert_values_tmp_table.q.out
deleted file mode 100644
index 170b4a7..0000000
--- a/ql/src/test/results/clientpositive/tez/insert_values_tmp_table.q.out
+++ /dev/null
@@ -1,36 +0,0 @@
-PREHOOK: query: create temporary table acid_ivtt(i int, de decimal(5,2), vc varchar(128)) clustered by (vc) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@acid_ivtt
-POSTHOOK: query: create temporary table acid_ivtt(i int, de decimal(5,2), vc varchar(128)) clustered by (vc) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@acid_ivtt
-PREHOOK: query: insert into table acid_ivtt values
- (1, 109.23, 'mary had a little lamb'),
- (429496729, 0.14, 'its fleece was white as snow'),
- (-29496729, -0.14, 'negative values test')
-PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__1
-PREHOOK: Output: default@acid_ivtt
-POSTHOOK: query: insert into table acid_ivtt values
- (1, 109.23, 'mary had a little lamb'),
- (429496729, 0.14, 'its fleece was white as snow'),
- (-29496729, -0.14, 'negative values test')
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__1
-POSTHOOK: Output: default@acid_ivtt
-POSTHOOK: Lineage: acid_ivtt.de EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivtt.i EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
-POSTHOOK: Lineage: acid_ivtt.vc EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-PREHOOK: query: select i, de, vc from acid_ivtt order by i
-PREHOOK: type: QUERY
-PREHOOK: Input: default@acid_ivtt
-#### A masked pattern was here ####
-POSTHOOK: query: select i, de, vc from acid_ivtt order by i
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@acid_ivtt
-#### A masked pattern was here ####
--29496729 -0.14 negative values test
-1 109.23 mary had a little lamb
-429496729 0.14 its fleece was white as snow
http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/join0.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/join0.q.out b/ql/src/test/results/clientpositive/tez/join0.q.out
deleted file mode 100644
index 7d73272..0000000
--- a/ql/src/test/results/clientpositive/tez/join0.q.out
+++ /dev/null
@@ -1,237 +0,0 @@
-Warning: Shuffle Join MERGEJOIN[15][tables = [src1, src2]] in Stage 'Reducer 2' is a cross product
-PREHOOK: query: -- SORT_QUERY_RESULTS
-
-EXPLAIN
-SELECT src1.key as k1, src1.value as v1,
- src2.key as k2, src2.value as v2 FROM
- (SELECT * FROM src WHERE src.key < 10) src1
- JOIN
- (SELECT * FROM src WHERE src.key < 10) src2
- SORT BY k1, v1, k2, v2
-PREHOOK: type: QUERY
-POSTHOOK: query: -- SORT_QUERY_RESULTS
-
-EXPLAIN
-SELECT src1.key as k1, src1.value as v1,
- src2.key as k2, src2.value as v2 FROM
- (SELECT * FROM src WHERE src.key < 10) src1
- JOIN
- (SELECT * FROM src WHERE src.key < 10) src2
- SORT BY k1, v1, k2, v2
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Tez
-#### A masked pattern was here ####
- Edges:
- Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 4 (SIMPLE_EDGE)
- Reducer 3 <- Reducer 2 (SIMPLE_EDGE)
-#### A masked pattern was here ####
- Vertices:
- Map 1
- Map Operator Tree:
- TableScan
- alias: src
- Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
- Filter Operator
- predicate: (key < 10) (type: boolean)
- Statistics: Num rows: 166 Data size: 29548 Basic stats: COMPLETE Column stats: COMPLETE
- Select Operator
- expressions: key (type: string), value (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 166 Data size: 29548 Basic stats: COMPLETE Column stats: COMPLETE
- Reduce Output Operator
- sort order:
- Statistics: Num rows: 166 Data size: 29548 Basic stats: COMPLETE Column stats: COMPLETE
- value expressions: _col0 (type: string), _col1 (type: string)
- Map 4
- Map Operator Tree:
- TableScan
- alias: src
- Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
- Filter Operator
- predicate: (key < 10) (type: boolean)
- Statistics: Num rows: 166 Data size: 29548 Basic stats: COMPLETE Column stats: COMPLETE
- Select Operator
- expressions: key (type: string), value (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 166 Data size: 29548 Basic stats: COMPLETE Column stats: COMPLETE
- Reduce Output Operator
- sort order:
- Statistics: Num rows: 166 Data size: 29548 Basic stats: COMPLETE Column stats: COMPLETE
- value expressions: _col0 (type: string), _col1 (type: string)
- Reducer 2
- Reduce Operator Tree:
- Merge Join Operator
- condition map:
- Inner Join 0 to 1
- keys:
- 0
- 1
- outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 27556 Data size: 9809936 Basic stats: COMPLETE Column stats: COMPLETE
- Reduce Output Operator
- key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
- sort order: ++++
- Statistics: Num rows: 27556 Data size: 9809936 Basic stats: COMPLETE Column stats: COMPLETE
- Reducer 3
- Reduce Operator Tree:
- Select Operator
- expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string), KEY.reducesinkkey2 (type: string), KEY.reducesinkkey3 (type: string)
- outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 27556 Data size: 9809936 Basic stats: COMPLETE Column stats: COMPLETE
- File Output Operator
- compressed: false
- Statistics: Num rows: 27556 Data size: 9809936 Basic stats: COMPLETE Column stats: COMPLETE
- table:
- input format: org.apache.hadoop.mapred.SequenceFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
- Stage: Stage-0
- Fetch Operator
- limit: -1
- Processor Tree:
- ListSink
-
-Warning: Shuffle Join MERGEJOIN[15][tables = [src1, src2]] in Stage 'Reducer 2' is a cross product
-PREHOOK: query: EXPLAIN FORMATTED
-SELECT src1.key as k1, src1.value as v1,
- src2.key as k2, src2.value as v2 FROM
- (SELECT * FROM src WHERE src.key < 10) src1
- JOIN
- (SELECT * FROM src WHERE src.key < 10) src2
- SORT BY k1, v1, k2, v2
-PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN FORMATTED
-SELECT src1.key as k1, src1.value as v1,
- src2.key as k2, src2.value as v2 FROM
- (SELECT * FROM src WHERE src.key < 10) src1
- JOIN
- (SELECT * FROM src WHERE src.key < 10) src2
- SORT BY k1, v1, k2, v2
-POSTHOOK: type: QUERY
-#### A masked pattern was here ####
-Warning: Shuffle Join MERGEJOIN[15][tables = [src1, src2]] in Stage 'Reducer 2' is a cross product
-PREHOOK: query: SELECT src1.key as k1, src1.value as v1,
- src2.key as k2, src2.value as v2 FROM
- (SELECT * FROM src WHERE src.key < 10) src1
- JOIN
- (SELECT * FROM src WHERE src.key < 10) src2
- SORT BY k1, v1, k2, v2
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT src1.key as k1, src1.value as v1,
- src2.key as k2, src2.value as v2 FROM
- (SELECT * FROM src WHERE src.key < 10) src1
- JOIN
- (SELECT * FROM src WHERE src.key < 10) src2
- SORT BY k1, v1, k2, v2
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
-#### A masked pattern was here ####
-0 val_0 0 val_0
-0 val_0 0 val_0
-0 val_0 0 val_0
-0 val_0 0 val_0
-0 val_0 0 val_0
-0 val_0 0 val_0
-0 val_0 0 val_0
-0 val_0 0 val_0
-0 val_0 0 val_0
-0 val_0 2 val_2
-0 val_0 2 val_2
-0 val_0 2 val_2
-0 val_0 4 val_4
-0 val_0 4 val_4
-0 val_0 4 val_4
-0 val_0 5 val_5
-0 val_0 5 val_5
-0 val_0 5 val_5
-0 val_0 5 val_5
-0 val_0 5 val_5
-0 val_0 5 val_5
-0 val_0 5 val_5
-0 val_0 5 val_5
-0 val_0 5 val_5
-0 val_0 8 val_8
-0 val_0 8 val_8
-0 val_0 8 val_8
-0 val_0 9 val_9
-0 val_0 9 val_9
-0 val_0 9 val_9
-2 val_2 0 val_0
-2 val_2 0 val_0
-2 val_2 0 val_0
-2 val_2 2 val_2
-2 val_2 4 val_4
-2 val_2 5 val_5
-2 val_2 5 val_5
-2 val_2 5 val_5
-2 val_2 8 val_8
-2 val_2 9 val_9
-4 val_4 0 val_0
-4 val_4 0 val_0
-4 val_4 0 val_0
-4 val_4 2 val_2
-4 val_4 4 val_4
-4 val_4 5 val_5
-4 val_4 5 val_5
-4 val_4 5 val_5
-4 val_4 8 val_8
-4 val_4 9 val_9
-5 val_5 0 val_0
-5 val_5 0 val_0
-5 val_5 0 val_0
-5 val_5 0 val_0
-5 val_5 0 val_0
-5 val_5 0 val_0
-5 val_5 0 val_0
-5 val_5 0 val_0
-5 val_5 0 val_0
-5 val_5 2 val_2
-5 val_5 2 val_2
-5 val_5 2 val_2
-5 val_5 4 val_4
-5 val_5 4 val_4
-5 val_5 4 val_4
-5 val_5 5 val_5
-5 val_5 5 val_5
-5 val_5 5 val_5
-5 val_5 5 val_5
-5 val_5 5 val_5
-5 val_5 5 val_5
-5 val_5 5 val_5
-5 val_5 5 val_5
-5 val_5 5 val_5
-5 val_5 8 val_8
-5 val_5 8 val_8
-5 val_5 8 val_8
-5 val_5 9 val_9
-5 val_5 9 val_9
-5 val_5 9 val_9
-8 val_8 0 val_0
-8 val_8 0 val_0
-8 val_8 0 val_0
-8 val_8 2 val_2
-8 val_8 4 val_4
-8 val_8 5 val_5
-8 val_8 5 val_5
-8 val_8 5 val_5
-8 val_8 8 val_8
-8 val_8 9 val_9
-9 val_9 0 val_0
-9 val_9 0 val_0
-9 val_9 0 val_0
-9 val_9 2 val_2
-9 val_9 4 val_4
-9 val_9 5 val_5
-9 val_9 5 val_5
-9 val_9 5 val_5
-9 val_9 8 val_8
-9 val_9 9 val_9
http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/join1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/join1.q.out b/ql/src/test/results/clientpositive/tez/join1.q.out
deleted file mode 100644
index f884b46..0000000
--- a/ql/src/test/results/clientpositive/tez/join1.q.out
+++ /dev/null
@@ -1,1156 +0,0 @@
-PREHOOK: query: -- SORT_QUERY_RESULTS
-
-CREATE TABLE dest_j1(key INT, value STRING) STORED AS TEXTFILE
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@dest_j1
-POSTHOOK: query: -- SORT_QUERY_RESULTS
-
-CREATE TABLE dest_j1(key INT, value STRING) STORED AS TEXTFILE
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@dest_j1
-PREHOOK: query: EXPLAIN
-FROM src src1 JOIN src src2 ON (src1.key = src2.key)
-INSERT OVERWRITE TABLE dest_j1 SELECT src1.key, src2.value
-PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN
-FROM src src1 JOIN src src2 ON (src1.key = src2.key)
-INSERT OVERWRITE TABLE dest_j1 SELECT src1.key, src2.value
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-2 depends on stages: Stage-1
- Stage-0 depends on stages: Stage-2
- Stage-3 depends on stages: Stage-0
-
-STAGE PLANS:
- Stage: Stage-1
- Tez
-#### A masked pattern was here ####
- Edges:
- Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 3 (SIMPLE_EDGE)
-#### A masked pattern was here ####
- Vertices:
- Map 1
- Map Operator Tree:
- TableScan
- alias: src1
- Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
- Filter Operator
- predicate: key is not null (type: boolean)
- Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
- Select Operator
- expressions: key (type: string)
- outputColumnNames: _col0
- Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
- Reduce Output Operator
- key expressions: _col0 (type: string)
- sort order: +
- Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
- Map 3
- Map Operator Tree:
- TableScan
- alias: src2
- Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
- Filter Operator
- predicate: key is not null (type: boolean)
- Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
- Select Operator
- expressions: key (type: string), value (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
- Reduce Output Operator
- key expressions: _col0 (type: string)
- sort order: +
- Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
- value expressions: _col1 (type: string)
- Reducer 2
- Reduce Operator Tree:
- Merge Join Operator
- condition map:
- Inner Join 0 to 1
- keys:
- 0 _col0 (type: string)
- 1 _col0 (type: string)
- outputColumnNames: _col0, _col2
- Statistics: Num rows: 1219 Data size: 216982 Basic stats: COMPLETE Column stats: COMPLETE
- Select Operator
- expressions: UDFToInteger(_col0) (type: int), _col2 (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 1219 Data size: 115805 Basic stats: COMPLETE Column stats: COMPLETE
- File Output Operator
- compressed: false
- Statistics: Num rows: 1219 Data size: 115805 Basic stats: COMPLETE Column stats: COMPLETE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.dest_j1
-
- Stage: Stage-2
- Dependency Collection
-
- Stage: Stage-0
- Move Operator
- tables:
- replace: true
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.dest_j1
-
- Stage: Stage-3
- Stats-Aggr Operator
-
-PREHOOK: query: FROM src src1 JOIN src src2 ON (src1.key = src2.key)
-INSERT OVERWRITE TABLE dest_j1 SELECT src1.key, src2.value
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src
-PREHOOK: Output: default@dest_j1
-POSTHOOK: query: FROM src src1 JOIN src src2 ON (src1.key = src2.key)
-INSERT OVERWRITE TABLE dest_j1 SELECT src1.key, src2.value
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
-POSTHOOK: Output: default@dest_j1
-POSTHOOK: Lineage: dest_j1.key EXPRESSION [(src)src1.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: dest_j1.value SIMPLE [(src)src2.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: SELECT dest_j1.* FROM dest_j1
-PREHOOK: type: QUERY
-PREHOOK: Input: default@dest_j1
-#### A masked pattern was here ####
-POSTHOOK: query: SELECT dest_j1.* FROM dest_j1
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@dest_j1
-#### A masked pattern was here ####
-0 val_0
-0 val_0
-0 val_0
-0 val_0
-0 val_0
-0 val_0
-0 val_0
-0 val_0
-0 val_0
-10 val_10
-100 val_100
-100 val_100
-100 val_100
-100 val_100
-103 val_103
-103 val_103
-103 val_103
-103 val_103
-104 val_104
-104 val_104
-104 val_104
-104 val_104
-105 val_105
-11 val_11
-111 val_111
-113 val_113
-113 val_113
-113 val_113
-113 val_113
-114 val_114
-116 val_116
-118 val_118
-118 val_118
-118 val_118
-118 val_118
-119 val_119
-119 val_119
-119 val_119
-119 val_119
-119 val_119
-119 val_119
-119 val_119
-119 val_119
-119 val_119
-12 val_12
-12 val_12
-12 val_12
-12 val_12
-120 val_120
-120 val_120
-120 val_120
-120 val_120
-125 val_125
-125 val_125
-125 val_125
-125 val_125
-126 val_126
-128 val_128
-128 val_128
-128 val_128
-128 val_128
-128 val_128
-128 val_128
-128 val_128
-128 val_128
-128 val_128
-129 val_129
-129 val_129
-129 val_129
-129 val_129
-131 val_131
-133 val_133
-134 val_134
-134 val_134
-134 val_134
-134 val_134
-136 val_136
-137 val_137
-137 val_137
-137 val_137
-137 val_137
-138 val_138
-138 val_138
-138 val_138
-138 val_138
-138 val_138
-138 val_138
-138 val_138
-138 val_138
-138 val_138
-138 val_138
-138 val_138
-138 val_138
-138 val_138
-138 val_138
-138 val_138
-138 val_138
-143 val_143
-145 val_145
-146 val_146
-146 val_146
-146 val_146
-146 val_146
-149 val_149
-149 val_149
-149 val_149
-149 val_149
-15 val_15
-15 val_15
-15 val_15
-15 val_15
-150 val_150
-152 val_152
-152 val_152
-152 val_152
-152 val_152
-153 val_153
-155 val_155
-156 val_156
-157 val_157
-158 val_158
-160 val_160
-162 val_162
-163 val_163
-164 val_164
-164 val_164
-164 val_164
-164 val_164
-165 val_165
-165 val_165
-165 val_165
-165 val_165
-166 val_166
-167 val_167
-167 val_167
-167 val_167
-167 val_167
-167 val_167
-167 val_167
-167 val_167
-167 val_167
-167 val_167
-168 val_168
-169 val_169
-169 val_169
-169 val_169
-169 val_169
-169 val_169
-169 val_169
-169 val_169
-169 val_169
-169 val_169
-169 val_169
-169 val_169
-169 val_169
-169 val_169
-169 val_169
-169 val_169
-169 val_169
-17 val_17
-170 val_170
-172 val_172
-172 val_172
-172 val_172
-172 val_172
-174 val_174
-174 val_174
-174 val_174
-174 val_174
-175 val_175
-175 val_175
-175 val_175
-175 val_175
-176 val_176
-176 val_176
-176 val_176
-176 val_176
-177 val_177
-178 val_178
-179 val_179
-179 val_179
-179 val_179
-179 val_179
-18 val_18
-18 val_18
-18 val_18
-18 val_18
-180 val_180
-181 val_181
-183 val_183
-186 val_186
-187 val_187
-187 val_187
-187 val_187
-187 val_187
-187 val_187
-187 val_187
-187 val_187
-187 val_187
-187 val_187
-189 val_189
-19 val_19
-190 val_190
-191 val_191
-191 val_191
-191 val_191
-191 val_191
-192 val_192
-193 val_193
-193 val_193
-193 val_193
-193 val_193
-193 val_193
-193 val_193
-193 val_193
-193 val_193
-193 val_193
-194 val_194
-195 val_195
-195 val_195
-195 val_195
-195 val_195
-196 val_196
-197 val_197
-197 val_197
-197 val_197
-197 val_197
-199 val_199
-199 val_199
-199 val_199
-199 val_199
-199 val_199
-199 val_199
-199 val_199
-199 val_199
-199 val_199
-2 val_2
-20 val_20
-200 val_200
-200 val_200
-200 val_200
-200 val_200
-201 val_201
-202 val_202
-203 val_203
-203 val_203
-203 val_203
-203 val_203
-205 val_205
-205 val_205
-205 val_205
-205 val_205
-207 val_207
-207 val_207
-207 val_207
-207 val_207
-208 val_208
-208 val_208
-208 val_208
-208 val_208
-208 val_208
-208 val_208
-208 val_208
-208 val_208
-208 val_208
-209 val_209
-209 val_209
-209 val_209
-209 val_209
-213 val_213
-213 val_213
-213 val_213
-213 val_213
-214 val_214
-216 val_216
-216 val_216
-216 val_216
-216 val_216
-217 val_217
-217 val_217
-217 val_217
-217 val_217
-218 val_218
-219 val_219
-219 val_219
-219 val_219
-219 val_219
-221 val_221
-221 val_221
-221 val_221
-221 val_221
-222 val_222
-223 val_223
-223 val_223
-223 val_223
-223 val_223
-224 val_224
-224 val_224
-224 val_224
-224 val_224
-226 val_226
-228 val_228
-229 val_229
-229 val_229
-229 val_229
-229 val_229
-230 val_230
-230 val_230
-230 val_230
-230 val_230
-230 val_230
-230 val_230
-230 val_230
-230 val_230
-230 val_230
-230 val_230
-230 val_230
-230 val_230
-230 val_230
-230 val_230
-230 val_230
-230 val_230
-230 val_230
-230 val_230
-230 val_230
-230 val_230
-230 val_230
-230 val_230
-230 val_230
-230 val_230
-230 val_230
-233 val_233
-233 val_233
-233 val_233
-233 val_233
-235 val_235
-237 val_237
-237 val_237
-237 val_237
-237 val_237
-238 val_238
-238 val_238
-238 val_238
-238 val_238
-239 val_239
-239 val_239
-239 val_239
-239 val_239
-24 val_24
-24 val_24
-24 val_24
-24 val_24
-241 val_241
-242 val_242
-242 val_242
-242 val_242
-242 val_242
-244 val_244
-247 val_247
-248 val_248
-249 val_249
-252 val_252
-255 val_255
-255 val_255
-255 val_255
-255 val_255
-256 val_256
-256 val_256
-256 val_256
-256 val_256
-257 val_257
-258 val_258
-26 val_26
-26 val_26
-26 val_26
-26 val_26
-260 val_260
-262 val_262
-263 val_263
-265 val_265
-265 val_265
-265 val_265
-265 val_265
-266 val_266
-27 val_27
-272 val_272
-272 val_272
-272 val_272
-272 val_272
-273 val_273
-273 val_273
-273 val_273
-273 val_273
-273 val_273
-273 val_273
-273 val_273
-273 val_273
-273 val_273
-274 val_274
-275 val_275
-277 val_277
-277 val_277
-277 val_277
-277 val_277
-277 val_277
-277 val_277
-277 val_277
-277 val_277
-277 val_277
-277 val_277
-277 val_277
-277 val_277
-277 val_277
-277 val_277
-277 val_277
-277 val_277
-278 val_278
-278 val_278
-278 val_278
-278 val_278
-28 val_28
-280 val_280
-280 val_280
-280 val_280
-280 val_280
-281 val_281
-281 val_281
-281 val_281
-281 val_281
-282 val_282
-282 val_282
-282 val_282
-282 val_282
-283 val_283
-284 val_284
-285 val_285
-286 val_286
-287 val_287
-288 val_288
-288 val_288
-288 val_288
-288 val_288
-289 val_289
-291 val_291
-292 val_292
-296 val_296
-298 val_298
-298 val_298
-298 val_298
-298 val_298
-298 val_298
-298 val_298
-298 val_298
-298 val_298
-298 val_298
-30 val_30
-302 val_302
-305 val_305
-306 val_306
-307 val_307
-307 val_307
-307 val_307
-307 val_307
-308 val_308
-309 val_309
-309 val_309
-309 val_309
-309 val_309
-310 val_310
-311 val_311
-311 val_311
-311 val_311
-311 val_311
-311 val_311
-311 val_311
-311 val_311
-311 val_311
-311 val_311
-315 val_315
-316 val_316
-316 val_316
-316 val_316
-316 val_316
-316 val_316
-316 val_316
-316 val_316
-316 val_316
-316 val_316
-317 val_317
-317 val_317
-317 val_317
-317 val_317
-318 val_318
-318 val_318
-318 val_318
-318 val_318
-318 val_318
-318 val_318
-318 val_318
-318 val_318
-318 val_318
-321 val_321
-321 val_321
-321 val_321
-321 val_321
-322 val_322
-322 val_322
-322 val_322
-322 val_322
-323 val_323
-325 val_325
-325 val_325
-325 val_325
-325 val_325
-327 val_327
-327 val_327
-327 val_327
-327 val_327
-327 val_327
-327 val_327
-327 val_327
-327 val_327
-327 val_327
-33 val_33
-331 val_331
-331 val_331
-331 val_331
-331 val_331
-332 val_332
-333 val_333
-333 val_333
-333 val_333
-333 val_333
-335 val_335
-336 val_336
-338 val_338
-339 val_339
-34 val_34
-341 val_341
-342 val_342
-342 val_342
-342 val_342
-342 val_342
-344 val_344
-344 val_344
-344 val_344
-344 val_344
-345 val_345
-348 val_348
-348 val_348
-348 val_348
-348 val_348
-348 val_348
-348 val_348
-348 val_348
-348 val_348
-348 val_348
-348 val_348
-348 val_348
-348 val_348
-348 val_348
-348 val_348
-348 val_348
-348 val_348
-348 val_348
-348 val_348
-348 val_348
-348 val_348
-348 val_348
-348 val_348
-348 val_348
-348 val_348
-348 val_348
-35 val_35
-35 val_35
-35 val_35
-35 val_35
-35 val_35
-35 val_35
-35 val_35
-35 val_35
-35 val_35
-351 val_351
-353 val_353
-353 val_353
-353 val_353
-353 val_353
-356 val_356
-360 val_360
-362 val_362
-364 val_364
-365 val_365
-366 val_366
-367 val_367
-367 val_367
-367 val_367
-367 val_367
-368 val_368
-369 val_369
-369 val_369
-369 val_369
-369 val_369
-369 val_369
-369 val_369
-369 val_369
-369 val_369
-369 val_369
-37 val_37
-37 val_37
-37 val_37
-37 val_37
-373 val_373
-374 val_374
-375 val_375
-377 val_377
-378 val_378
-379 val_379
-382 val_382
-382 val_382
-382 val_382
-382 val_382
-384 val_384
-384 val_384
-384 val_384
-384 val_384
-384 val_384
-384 val_384
-384 val_384
-384 val_384
-384 val_384
-386 val_386
-389 val_389
-392 val_392
-393 val_393
-394 val_394
-395 val_395
-395 val_395
-395 val_395
-395 val_395
-396 val_396
-396 val_396
-396 val_396
-396 val_396
-396 val_396
-396 val_396
-396 val_396
-396 val_396
-396 val_396
-397 val_397
-397 val_397
-397 val_397
-397 val_397
-399 val_399
-399 val_399
-399 val_399
-399 val_399
-4 val_4
-400 val_400
-401 val_401
-401 val_401
-401 val_401
-401 val_401
-401 val_401
-401 val_401
-401 val_401
-401 val_401
-401 val_401
-401 val_401
-401 val_401
-401 val_401
-401 val_401
-401 val_401
-401 val_401
-401 val_401
-401 val_401
-401 val_401
-401 val_401
-401 val_401
-401 val_401
-401 val_401
-401 val_401
-401 val_401
-401 val_401
-402 val_402
-403 val_403
-403 val_403
-403 val_403
-403 val_403
-403 val_403
-403 val_403
-403 val_403
-403 val_403
-403 val_403
-404 val_404
-404 val_404
-404 val_404
-404 val_404
-406 val_406
-406 val_406
-406 val_406
-406 val_406
-406 val_406
-406 val_406
-406 val_406
-406 val_406
-406 val_406
-406 val_406
-406 val_406
-406 val_406
-406 val_406
-406 val_406
-406 val_406
-406 val_406
-407 val_407
-409 val_409
-409 val_409
-409 val_409
-409 val_409
-409 val_409
-409 val_409
-409 val_409
-409 val_409
-409 val_409
-41 val_41
-411 val_411
-413 val_413
-413 val_413
-413 val_413
-413 val_413
-414 val_414
-414 val_414
-414 val_414
-414 val_414
-417 val_417
-417 val_417
-417 val_417
-417 val_417
-417 val_417
-417 val_417
-417 val_417
-417 val_417
-417 val_417
-418 val_418
-419 val_419
-42 val_42
-42 val_42
-42 val_42
-42 val_42
-421 val_421
-424 val_424
-424 val_424
-424 val_424
-424 val_424
-427 val_427
-429 val_429
-429 val_429
-429 val_429
-429 val_429
-43 val_43
-430 val_430
-430 val_430
-430 val_430
-430 val_430
-430 val_430
-430 val_430
-430 val_430
-430 val_430
-430 val_430
-431 val_431
-431 val_431
-431 val_431
-431 val_431
-431 val_431
-431 val_431
-431 val_431
-431 val_431
-431 val_431
-432 val_432
-435 val_435
-436 val_436
-437 val_437
-438 val_438
-438 val_438
-438 val_438
-438 val_438
-438 val_438
-438 val_438
-438 val_438
-438 val_438
-438 val_438
-439 val_439
-439 val_439
-439 val_439
-439 val_439
-44 val_44
-443 val_443
-444 val_444
-446 val_446
-448 val_448
-449 val_449
-452 val_452
-453 val_453
-454 val_454
-454 val_454
-454 val_454
-454 val_454
-454 val_454
-454 val_454
-454 val_454
-454 val_454
-454 val_454
-455 val_455
-457 val_457
-458 val_458
-458 val_458
-458 val_458
-458 val_458
-459 val_459
-459 val_459
-459 val_459
-459 val_459
-460 val_460
-462 val_462
-462 val_462
-462 val_462
-462 val_462
-463 val_463
-463 val_463
-463 val_463
-463 val_463
-466 val_466
-466 val_466
-466 val_466
-466 val_466
-466 val_466
-466 val_466
-466 val_466
-466 val_466
-466 val_466
-467 val_467
-468 val_468
-468 val_468
-468 val_468
-468 val_468
-468 val_468
-468 val_468
-468 val_468
-468 val_468
-468 val_468
-468 val_468
-468 val_468
-468 val_468
-468 val_468
-468 val_468
-468 val_468
-468 val_468
-469 val_469
-469 val_469
-469 val_469
-469 val_469
-469 val_469
-469 val_469
-469 val_469
-469 val_469
-469 val_469
-469 val_469
-469 val_469
-469 val_469
-469 val_469
-469 val_469
-469 val_469
-469 val_469
-469 val_469
-469 val_469
-469 val_469
-469 val_469
-469 val_469
-469 val_469
-469 val_469
-469 val_469
-469 val_469
-47 val_47
-470 val_470
-472 val_472
-475 val_475
-477 val_477
-478 val_478
-478 val_478
-478 val_478
-478 val_478
-479 val_479
-480 val_480
-480 val_480
-480 val_480
-480 val_480
-480 val_480
-480 val_480
-480 val_480
-480 val_480
-480 val_480
-481 val_481
-482 val_482
-483 val_483
-484 val_484
-485 val_485
-487 val_487
-489 val_489
-489 val_489
-489 val_489
-489 val_489
-489 val_489
-489 val_489
-489 val_489
-489 val_489
-489 val_489
-489 val_489
-489 val_489
-489 val_489
-489 val_489
-489 val_489
-489 val_489
-489 val_489
-490 val_490
-491 val_491
-492 val_492
-492 val_492
-492 val_492
-492 val_492
-493 val_493
-494 val_494
-495 val_495
-496 val_496
-497 val_497
-498 val_498
-498 val_498
-498 val_498
-498 val_498
-498 val_498
-498 val_498
-498 val_498
-498 val_498
-498 val_498
-5 val_5
-5 val_5
-5 val_5
-5 val_5
-5 val_5
-5 val_5
-5 val_5
-5 val_5
-5 val_5
-51 val_51
-51 val_51
-51 val_51
-51 val_51
-53 val_53
-54 val_54
-57 val_57
-58 val_58
-58 val_58
-58 val_58
-58 val_58
-64 val_64
-65 val_65
-66 val_66
-67 val_67
-67 val_67
-67 val_67
-67 val_67
-69 val_69
-70 val_70
-70 val_70
-70 val_70
-70 val_70
-70 val_70
-70 val_70
-70 val_70
-70 val_70
-70 val_70
-72 val_72
-72 val_72
-72 val_72
-72 val_72
-74 val_74
-76 val_76
-76 val_76
-76 val_76
-76 val_76
-77 val_77
-78 val_78
-8 val_8
-80 val_80
-82 val_82
-83 val_83
-83 val_83
-83 val_83
-83 val_83
-84 val_84
-84 val_84
-84 val_84
-84 val_84
-85 val_85
-86 val_86
-87 val_87
-9 val_9
-90 val_90
-90 val_90
-90 val_90
-90 val_90
-90 val_90
-90 val_90
-90 val_90
-90 val_90
-90 val_90
-92 val_92
-95 val_95
-95 val_95
-95 val_95
-95 val_95
-96 val_96
-97 val_97
-97 val_97
-97 val_97
-97 val_97
-98 val_98
-98 val_98
-98 val_98
-98 val_98