hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kgyrtk...@apache.org
Subject [09/54] [partial] hive git commit: HIVE-17550: Remove unreferenced q.out-s (Zoltan Haindrich, reviewed by Ashutosh Chauhan)
Date Thu, 21 Sep 2017 09:06:46 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/6f5c1135/ql/src/test/results/clientpositive/insert_into_with_schema.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/insert_into_with_schema.q.out b/ql/src/test/results/clientpositive/insert_into_with_schema.q.out
deleted file mode 100644
index 040d118..0000000
--- a/ql/src/test/results/clientpositive/insert_into_with_schema.q.out
+++ /dev/null
@@ -1,348 +0,0 @@
-PREHOOK: query: -- set of tests HIVE-9481
-
-drop database if exists x314 cascade
-PREHOOK: type: DROPDATABASE
-POSTHOOK: query: -- set of tests HIVE-9481
-
-drop database if exists x314 cascade
-POSTHOOK: type: DROPDATABASE
-PREHOOK: query: create database x314
-PREHOOK: type: CREATEDATABASE
-PREHOOK: Output: database:x314
-POSTHOOK: query: create database x314
-POSTHOOK: type: CREATEDATABASE
-POSTHOOK: Output: database:x314
-PREHOOK: query: use x314
-PREHOOK: type: SWITCHDATABASE
-PREHOOK: Input: database:x314
-POSTHOOK: query: use x314
-POSTHOOK: type: SWITCHDATABASE
-POSTHOOK: Input: database:x314
-PREHOOK: query: create table source(s1 int, s2 int)
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:x314
-PREHOOK: Output: x314@source
-POSTHOOK: query: create table source(s1 int, s2 int)
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:x314
-POSTHOOK: Output: x314@source
-PREHOOK: query: create table target1(x int, y int, z int)
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:x314
-PREHOOK: Output: x314@target1
-POSTHOOK: query: create table target1(x int, y int, z int)
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:x314
-POSTHOOK: Output: x314@target1
-PREHOOK: query: create table target2(x int, y int, z int)
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:x314
-PREHOOK: Output: x314@target2
-POSTHOOK: query: create table target2(x int, y int, z int)
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:x314
-POSTHOOK: Output: x314@target2
-PREHOOK: query: insert into source(s2,s1) values(2,1)
-PREHOOK: type: QUERY
-PREHOOK: Output: x314@source
-POSTHOOK: query: insert into source(s2,s1) values(2,1)
-POSTHOOK: type: QUERY
-POSTHOOK: Output: x314@source
-POSTHOOK: Lineage: source.s1 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2,
type:string, comment:), ]
-POSTHOOK: Lineage: source.s2 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1,
type:string, comment:), ]
-PREHOOK: query: -- expect source to contain 1 row (1,2)
-select * from source
-PREHOOK: type: QUERY
-PREHOOK: Input: x314@source
-#### A masked pattern was here ####
-POSTHOOK: query: -- expect source to contain 1 row (1,2)
-select * from source
-POSTHOOK: type: QUERY
-POSTHOOK: Input: x314@source
-#### A masked pattern was here ####
-1	2
-PREHOOK: query: insert into target1(z,x) select * from source
-PREHOOK: type: QUERY
-PREHOOK: Input: x314@source
-PREHOOK: Output: x314@target1
-POSTHOOK: query: insert into target1(z,x) select * from source
-POSTHOOK: type: QUERY
-POSTHOOK: Input: x314@source
-POSTHOOK: Output: x314@target1
-POSTHOOK: Lineage: target1.x SIMPLE [(source)source.FieldSchema(name:s2, type:int, comment:null),
]
-POSTHOOK: Lineage: target1.y SIMPLE []
-POSTHOOK: Lineage: target1.z SIMPLE [(source)source.FieldSchema(name:s1, type:int, comment:null),
]
-PREHOOK: query: -- expect target1 to contain 1 row (2,NULL,1)
-select * from target1
-PREHOOK: type: QUERY
-PREHOOK: Input: x314@target1
-#### A masked pattern was here ####
-POSTHOOK: query: -- expect target1 to contain 1 row (2,NULL,1)
-select * from target1
-POSTHOOK: type: QUERY
-POSTHOOK: Input: x314@target1
-#### A masked pattern was here ####
-2	NULL	1
-PREHOOK: query: -- note that schema spec for target1 and target2 are different
-from source insert into target1(x,y) select * insert into target2(x,z) select s2,s1
-PREHOOK: type: QUERY
-PREHOOK: Input: x314@source
-PREHOOK: Output: x314@target1
-PREHOOK: Output: x314@target2
-POSTHOOK: query: -- note that schema spec for target1 and target2 are different
-from source insert into target1(x,y) select * insert into target2(x,z) select s2,s1
-POSTHOOK: type: QUERY
-POSTHOOK: Input: x314@source
-POSTHOOK: Output: x314@target1
-POSTHOOK: Output: x314@target2
-POSTHOOK: Lineage: target1.x SIMPLE [(source)source.FieldSchema(name:s1, type:int, comment:null),
]
-POSTHOOK: Lineage: target1.y SIMPLE [(source)source.FieldSchema(name:s2, type:int, comment:null),
]
-POSTHOOK: Lineage: target1.z SIMPLE []
-POSTHOOK: Lineage: target2.x SIMPLE [(source)source.FieldSchema(name:s2, type:int, comment:null),
]
-POSTHOOK: Lineage: target2.y SIMPLE []
-POSTHOOK: Lineage: target2.z SIMPLE [(source)source.FieldSchema(name:s1, type:int, comment:null),
]
-PREHOOK: query: --expect target1 to have 2rows (2,NULL,1), (1,2,NULL)
-select * from target1 order by x,y,z
-PREHOOK: type: QUERY
-PREHOOK: Input: x314@target1
-#### A masked pattern was here ####
-POSTHOOK: query: --expect target1 to have 2rows (2,NULL,1), (1,2,NULL)
-select * from target1 order by x,y,z
-POSTHOOK: type: QUERY
-POSTHOOK: Input: x314@target1
-#### A masked pattern was here ####
-1	2	NULL
-2	NULL	1
-PREHOOK: query: -- expect target2 to have 1 row: (2,NULL,1)
-select * from target2
-PREHOOK: type: QUERY
-PREHOOK: Input: x314@target2
-#### A masked pattern was here ####
-POSTHOOK: query: -- expect target2 to have 1 row: (2,NULL,1)
-select * from target2
-POSTHOOK: type: QUERY
-POSTHOOK: Input: x314@target2
-#### A masked pattern was here ####
-2	NULL	1
-PREHOOK: query: from source insert into target1(x,y,z) select null as x, * insert into target2(x,y,z)
select null as x, source.*
-PREHOOK: type: QUERY
-PREHOOK: Input: x314@source
-PREHOOK: Output: x314@target1
-PREHOOK: Output: x314@target2
-POSTHOOK: query: from source insert into target1(x,y,z) select null as x, * insert into target2(x,y,z)
select null as x, source.*
-POSTHOOK: type: QUERY
-POSTHOOK: Input: x314@source
-POSTHOOK: Output: x314@target1
-POSTHOOK: Output: x314@target2
-POSTHOOK: Lineage: target1.x EXPRESSION []
-POSTHOOK: Lineage: target1.y SIMPLE [(source)source.FieldSchema(name:s1, type:int, comment:null),
]
-POSTHOOK: Lineage: target1.z SIMPLE [(source)source.FieldSchema(name:s2, type:int, comment:null),
]
-POSTHOOK: Lineage: target2.x EXPRESSION []
-POSTHOOK: Lineage: target2.y SIMPLE [(source)source.FieldSchema(name:s1, type:int, comment:null),
]
-POSTHOOK: Lineage: target2.z SIMPLE [(source)source.FieldSchema(name:s2, type:int, comment:null),
]
-PREHOOK: query: -- expect target1 to have 3 rows: (2,NULL,1), (1,2,NULL), (NULL, 1,2)
-select * from target1 order by x,y,z
-PREHOOK: type: QUERY
-PREHOOK: Input: x314@target1
-#### A masked pattern was here ####
-POSTHOOK: query: -- expect target1 to have 3 rows: (2,NULL,1), (1,2,NULL), (NULL, 1,2)
-select * from target1 order by x,y,z
-POSTHOOK: type: QUERY
-POSTHOOK: Input: x314@target1
-#### A masked pattern was here ####
-NULL	1	2
-1	2	NULL
-2	NULL	1
-PREHOOK: query: -- expect target2 to have 2 rows: (2,NULL,1), (NULL, 1,2)
-select * from target2 order by x,y,z
-PREHOOK: type: QUERY
-PREHOOK: Input: x314@target2
-#### A masked pattern was here ####
-POSTHOOK: query: -- expect target2 to have 2 rows: (2,NULL,1), (NULL, 1,2)
-select * from target2 order by x,y,z
-POSTHOOK: type: QUERY
-POSTHOOK: Input: x314@target2
-#### A masked pattern was here ####
-NULL	1	2
-2	NULL	1
-PREHOOK: query: truncate table target1
-PREHOOK: type: TRUNCATETABLE
-PREHOOK: Output: x314@target1
-POSTHOOK: query: truncate table target1
-POSTHOOK: type: TRUNCATETABLE
-POSTHOOK: Output: x314@target1
-PREHOOK: query: create table source2(s1 int, s2 int)
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:x314
-PREHOOK: Output: x314@source2
-POSTHOOK: query: create table source2(s1 int, s2 int)
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:x314
-POSTHOOK: Output: x314@source2
-PREHOOK: query: insert into target1 (x,z) select source.s1,source2.s2 from source left outer
join source2 on source.s1=source2.s2
-PREHOOK: type: QUERY
-PREHOOK: Input: x314@source
-PREHOOK: Input: x314@source2
-PREHOOK: Output: x314@target1
-POSTHOOK: query: insert into target1 (x,z) select source.s1,source2.s2 from source left outer
join source2 on source.s1=source2.s2
-POSTHOOK: type: QUERY
-POSTHOOK: Input: x314@source
-POSTHOOK: Input: x314@source2
-POSTHOOK: Output: x314@target1
-POSTHOOK: Lineage: target1.x SIMPLE [(source)source.FieldSchema(name:s1, type:int, comment:null),
]
-POSTHOOK: Lineage: target1.y SIMPLE []
-POSTHOOK: Lineage: target1.z SIMPLE [(source2)source2.FieldSchema(name:s2, type:int, comment:null),
]
-PREHOOK: query: --expect target1 to have 1 row (1,NULL,NULL)
-select * from target1
-PREHOOK: type: QUERY
-PREHOOK: Input: x314@target1
-#### A masked pattern was here ####
-POSTHOOK: query: --expect target1 to have 1 row (1,NULL,NULL)
-select * from target1
-POSTHOOK: type: QUERY
-POSTHOOK: Input: x314@target1
-#### A masked pattern was here ####
-1	NULL	NULL
-PREHOOK: query: -- partitioned tables
-CREATE TABLE pageviews (userid VARCHAR(64), link STRING, source STRING) PARTITIONED BY (datestamp
STRING, i int) CLUSTERED BY (userid) INTO 256 BUCKETS STORED AS ORC
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:x314
-PREHOOK: Output: x314@pageviews
-POSTHOOK: query: -- partitioned tables
-CREATE TABLE pageviews (userid VARCHAR(64), link STRING, source STRING) PARTITIONED BY (datestamp
STRING, i int) CLUSTERED BY (userid) INTO 256 BUCKETS STORED AS ORC
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:x314
-POSTHOOK: Output: x314@pageviews
-PREHOOK: query: INSERT INTO TABLE pageviews PARTITION (datestamp = '2014-09-23', i = 1)(userid,link)
VALUES ('jsmith', 'mail.com')
-PREHOOK: type: QUERY
-PREHOOK: Output: x314@pageviews@datestamp=2014-09-23/i=1
-POSTHOOK: query: INSERT INTO TABLE pageviews PARTITION (datestamp = '2014-09-23', i = 1)(userid,link)
VALUES ('jsmith', 'mail.com')
-POSTHOOK: type: QUERY
-POSTHOOK: Output: x314@pageviews@datestamp=2014-09-23/i=1
-POSTHOOK: Lineage: pageviews PARTITION(datestamp=2014-09-23,i=1).link SIMPLE [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2,
type:string, comment:), ]
-POSTHOOK: Lineage: pageviews PARTITION(datestamp=2014-09-23,i=1).source SIMPLE []
-POSTHOOK: Lineage: pageviews PARTITION(datestamp=2014-09-23,i=1).userid EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1,
type:string, comment:), ]
-PREHOOK: query: -- expect 1 row: ('jsmith', 'mail.com', NULL) in partition '2014-09-23'/'1'
-select * from pageviews
-PREHOOK: type: QUERY
-PREHOOK: Input: x314@pageviews
-PREHOOK: Input: x314@pageviews@datestamp=2014-09-23/i=1
-#### A masked pattern was here ####
-POSTHOOK: query: -- expect 1 row: ('jsmith', 'mail.com', NULL) in partition '2014-09-23'/'1'
-select * from pageviews
-POSTHOOK: type: QUERY
-POSTHOOK: Input: x314@pageviews
-POSTHOOK: Input: x314@pageviews@datestamp=2014-09-23/i=1
-#### A masked pattern was here ####
-jsmith	mail.com	NULL	2014-09-23	1
-PREHOOK: query: -- dynamic partitioning 
-
-
-
-INSERT INTO TABLE pageviews PARTITION (datestamp='2014-09-23',i)(userid,i,link) VALUES ('jsmith',
7, '7mail.com')
-PREHOOK: type: QUERY
-PREHOOK: Output: x314@pageviews@datestamp=2014-09-23
-POSTHOOK: query: -- dynamic partitioning 
-
-
-
-INSERT INTO TABLE pageviews PARTITION (datestamp='2014-09-23',i)(userid,i,link) VALUES ('jsmith',
7, '7mail.com')
-POSTHOOK: type: QUERY
-POSTHOOK: Output: x314@pageviews@datestamp=2014-09-23/i=7
-POSTHOOK: Lineage: pageviews PARTITION(datestamp=2014-09-23,i=7).link SIMPLE [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col3,
type:string, comment:), ]
-POSTHOOK: Lineage: pageviews PARTITION(datestamp=2014-09-23,i=7).source SIMPLE []
-POSTHOOK: Lineage: pageviews PARTITION(datestamp=2014-09-23,i=7).userid EXPRESSION [(values__tmp__table__3)values__tmp__table__3.FieldSchema(name:tmp_values_col1,
type:string, comment:), ]
-PREHOOK: query: INSERT INTO TABLE pageviews PARTITION (datestamp,i)(userid,i,link,datestamp)
VALUES ('jsmith', 17, '17mail.com', '2014-09-23')
-PREHOOK: type: QUERY
-PREHOOK: Output: x314@pageviews
-POSTHOOK: query: INSERT INTO TABLE pageviews PARTITION (datestamp,i)(userid,i,link,datestamp)
VALUES ('jsmith', 17, '17mail.com', '2014-09-23')
-POSTHOOK: type: QUERY
-POSTHOOK: Output: x314@pageviews@datestamp=2014-09-23/i=17
-POSTHOOK: Lineage: pageviews PARTITION(datestamp=2014-09-23,i=17).link SIMPLE [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col3,
type:string, comment:), ]
-POSTHOOK: Lineage: pageviews PARTITION(datestamp=2014-09-23,i=17).source SIMPLE []
-POSTHOOK: Lineage: pageviews PARTITION(datestamp=2014-09-23,i=17).userid EXPRESSION [(values__tmp__table__4)values__tmp__table__4.FieldSchema(name:tmp_values_col1,
type:string, comment:), ]
-PREHOOK: query: INSERT INTO TABLE pageviews PARTITION (datestamp,i)(userid,i,link,datestamp)
VALUES ('jsmith', 19, '19mail.com', '2014-09-24')
-PREHOOK: type: QUERY
-PREHOOK: Output: x314@pageviews
-POSTHOOK: query: INSERT INTO TABLE pageviews PARTITION (datestamp,i)(userid,i,link,datestamp)
VALUES ('jsmith', 19, '19mail.com', '2014-09-24')
-POSTHOOK: type: QUERY
-POSTHOOK: Output: x314@pageviews@datestamp=2014-09-24/i=19
-POSTHOOK: Lineage: pageviews PARTITION(datestamp=2014-09-24,i=19).link SIMPLE [(values__tmp__table__5)values__tmp__table__5.FieldSchema(name:tmp_values_col3,
type:string, comment:), ]
-POSTHOOK: Lineage: pageviews PARTITION(datestamp=2014-09-24,i=19).source SIMPLE []
-POSTHOOK: Lineage: pageviews PARTITION(datestamp=2014-09-24,i=19).userid EXPRESSION [(values__tmp__table__5)values__tmp__table__5.FieldSchema(name:tmp_values_col1,
type:string, comment:), ]
-PREHOOK: query: -- here the 'datestamp' partition column is not provided and will be NULL-filled
-INSERT INTO TABLE pageviews PARTITION (datestamp,i)(userid,i,link) VALUES ('jsmith', 23,
'23mail.com')
-PREHOOK: type: QUERY
-PREHOOK: Output: x314@pageviews
-POSTHOOK: query: -- here the 'datestamp' partition column is not provided and will be NULL-filled
-INSERT INTO TABLE pageviews PARTITION (datestamp,i)(userid,i,link) VALUES ('jsmith', 23,
'23mail.com')
-POSTHOOK: type: QUERY
-POSTHOOK: Output: x314@pageviews@datestamp=__HIVE_DEFAULT_PARTITION__/i=23
-POSTHOOK: Lineage: pageviews PARTITION(datestamp=__HIVE_DEFAULT_PARTITION__,i=23).link SIMPLE
[(values__tmp__table__6)values__tmp__table__6.FieldSchema(name:tmp_values_col3, type:string,
comment:), ]
-POSTHOOK: Lineage: pageviews PARTITION(datestamp=__HIVE_DEFAULT_PARTITION__,i=23).source
SIMPLE []
-POSTHOOK: Lineage: pageviews PARTITION(datestamp=__HIVE_DEFAULT_PARTITION__,i=23).userid
EXPRESSION [(values__tmp__table__6)values__tmp__table__6.FieldSchema(name:tmp_values_col1,
type:string, comment:), ]
-PREHOOK: query: -- expect 5 rows:
--- expect ('jsmith', 'mail.com', NULL) in partition '2014-09-23'/'1'
--- expect ('jsmith', '7mail.com', NULL) in partition '2014-09-23'/'7'
--- expect ('jsmith', '17mail.com', NULL) in partition '2014-09-23'/'17'
--- expect ('jsmith', '19mail.com', NULL) in partition '2014-09-24'/'19'
--- expect ('jsmith', '23mail.com', NULL) in partition '__HIVE_DEFAULT_PARTITION__'/'23'
-select * from pageviews order by link
-PREHOOK: type: QUERY
-PREHOOK: Input: x314@pageviews
-PREHOOK: Input: x314@pageviews@datestamp=2014-09-23/i=1
-PREHOOK: Input: x314@pageviews@datestamp=2014-09-23/i=17
-PREHOOK: Input: x314@pageviews@datestamp=2014-09-23/i=7
-PREHOOK: Input: x314@pageviews@datestamp=2014-09-24/i=19
-PREHOOK: Input: x314@pageviews@datestamp=__HIVE_DEFAULT_PARTITION__/i=23
-#### A masked pattern was here ####
-POSTHOOK: query: -- expect 5 rows:
--- expect ('jsmith', 'mail.com', NULL) in partition '2014-09-23'/'1'
--- expect ('jsmith', '7mail.com', NULL) in partition '2014-09-23'/'7'
--- expect ('jsmith', '17mail.com', NULL) in partition '2014-09-23'/'17'
--- expect ('jsmith', '19mail.com', NULL) in partition '2014-09-24'/'19'
--- expect ('jsmith', '23mail.com', NULL) in partition '__HIVE_DEFAULT_PARTITION__'/'23'
-select * from pageviews order by link
-POSTHOOK: type: QUERY
-POSTHOOK: Input: x314@pageviews
-POSTHOOK: Input: x314@pageviews@datestamp=2014-09-23/i=1
-POSTHOOK: Input: x314@pageviews@datestamp=2014-09-23/i=17
-POSTHOOK: Input: x314@pageviews@datestamp=2014-09-23/i=7
-POSTHOOK: Input: x314@pageviews@datestamp=2014-09-24/i=19
-POSTHOOK: Input: x314@pageviews@datestamp=__HIVE_DEFAULT_PARTITION__/i=23
-#### A masked pattern was here ####
-jsmith	17mail.com	NULL	2014-09-23	17
-jsmith	19mail.com	NULL	2014-09-24	19
-jsmith	23mail.com	NULL	__HIVE_DEFAULT_PARTITION__	23
-jsmith	7mail.com	NULL	2014-09-23	7
-jsmith	mail.com	NULL	2014-09-23	1
-PREHOOK: query: drop database if exists x314 cascade
-PREHOOK: type: DROPDATABASE
-PREHOOK: Input: database:x314
-PREHOOK: Output: database:x314
-PREHOOK: Output: x314@pageviews
-PREHOOK: Output: x314@source
-PREHOOK: Output: x314@source2
-PREHOOK: Output: x314@target1
-PREHOOK: Output: x314@target2
-PREHOOK: Output: x314@values__tmp__table__1
-PREHOOK: Output: x314@values__tmp__table__2
-PREHOOK: Output: x314@values__tmp__table__3
-PREHOOK: Output: x314@values__tmp__table__4
-PREHOOK: Output: x314@values__tmp__table__5
-PREHOOK: Output: x314@values__tmp__table__6
-POSTHOOK: query: drop database if exists x314 cascade
-POSTHOOK: type: DROPDATABASE
-POSTHOOK: Input: database:x314
-POSTHOOK: Output: database:x314
-POSTHOOK: Output: x314@pageviews
-POSTHOOK: Output: x314@source
-POSTHOOK: Output: x314@source2
-POSTHOOK: Output: x314@target1
-POSTHOOK: Output: x314@target2
-POSTHOOK: Output: x314@values__tmp__table__1
-POSTHOOK: Output: x314@values__tmp__table__2
-POSTHOOK: Output: x314@values__tmp__table__3
-POSTHOOK: Output: x314@values__tmp__table__4
-POSTHOOK: Output: x314@values__tmp__table__5
-POSTHOOK: Output: x314@values__tmp__table__6

http://git-wip-us.apache.org/repos/asf/hive/blob/6f5c1135/ql/src/test/results/clientpositive/join1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/join1.q.out b/ql/src/test/results/clientpositive/join1.q.out
deleted file mode 100644
index 5d54ee3..0000000
--- a/ql/src/test/results/clientpositive/join1.q.out
+++ /dev/null
@@ -1,1143 +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-0 depends on stages: Stage-1
-  Stage-2 depends on stages: Stage-0
-
-STAGE PLANS:
-  Stage: Stage-1
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            alias: src1
-            Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats:
NONE
-            Filter Operator
-              predicate: key is not null (type: boolean)
-              Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats:
NONE
-              Select Operator
-                expressions: key (type: string)
-                outputColumnNames: _col0
-                Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats:
NONE
-                Reduce Output Operator
-                  key expressions: _col0 (type: string)
-                  sort order: +
-                  Map-reduce partition columns: _col0 (type: string)
-                  Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats:
NONE
-          TableScan
-            alias: src2
-            Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats:
NONE
-            Filter Operator
-              predicate: key is not null (type: boolean)
-              Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats:
NONE
-              Select Operator
-                expressions: key (type: string), value (type: string)
-                outputColumnNames: _col0, _col1
-                Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats:
NONE
-                Reduce Output Operator
-                  key expressions: _col0 (type: string)
-                  sort order: +
-                  Map-reduce partition columns: _col0 (type: string)
-                  Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats:
NONE
-                  value expressions: _col1 (type: string)
-      Reduce Operator Tree:
-        Join Operator
-          condition map:
-               Inner Join 0 to 1
-          keys:
-            0 _col0 (type: string)
-            1 _col0 (type: string)
-          outputColumnNames: _col0, _col2
-          Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
-          Select Operator
-            expressions: UDFToInteger(_col0) (type: int), _col2 (type: string)
-            outputColumnNames: _col0, _col1
-            Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats:
NONE
-            File Output Operator
-              compressed: false
-              Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats:
NONE
-              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-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-2
-    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


Mime
View raw message