hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From xu...@apache.org
Subject [2/4] hive git commit: HIVE-11180: Enable native vectorized map join for spark [Spark Branch] (Rui reviewed by Xuefu)
Date Thu, 19 Nov 2015 02:36:14 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/fa6f5cf6/ql/src/test/results/clientpositive/spark/vector_outer_join4.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/vector_outer_join4.q.out b/ql/src/test/results/clientpositive/spark/vector_outer_join4.q.out
new file mode 100644
index 0000000..182dbb0
--- /dev/null
+++ b/ql/src/test/results/clientpositive/spark/vector_outer_join4.q.out
@@ -0,0 +1,1000 @@
+PREHOOK: query: -- Using cint and ctinyint in test queries
+create table small_alltypesorc1b as select * from alltypesorc where cint is not null and
ctinyint is not null order by ctinyint, csmallint, cint, cbigint, cfloat, cdouble, cstring1,
cstring2, ctimestamp1, ctimestamp2, cboolean1, cboolean2 limit 10
+PREHOOK: type: CREATETABLE_AS_SELECT
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: database:default
+PREHOOK: Output: default@small_alltypesorc1b
+POSTHOOK: query: -- Using cint and ctinyint in test queries
+create table small_alltypesorc1b as select * from alltypesorc where cint is not null and
ctinyint is not null order by ctinyint, csmallint, cint, cbigint, cfloat, cdouble, cstring1,
cstring2, ctimestamp1, ctimestamp2, cboolean1, cboolean2 limit 10
+POSTHOOK: type: CREATETABLE_AS_SELECT
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@small_alltypesorc1b
+PREHOOK: query: create table small_alltypesorc2b as select * from alltypesorc where cint
is null and ctinyint is not null order by ctinyint, csmallint, cint, cbigint, cfloat, cdouble,
cstring1, cstring2, ctimestamp1, ctimestamp2, cboolean1, cboolean2 limit 10
+PREHOOK: type: CREATETABLE_AS_SELECT
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: database:default
+PREHOOK: Output: default@small_alltypesorc2b
+POSTHOOK: query: create table small_alltypesorc2b as select * from alltypesorc where cint
is null and ctinyint is not null order by ctinyint, csmallint, cint, cbigint, cfloat, cdouble,
cstring1, cstring2, ctimestamp1, ctimestamp2, cboolean1, cboolean2 limit 10
+POSTHOOK: type: CREATETABLE_AS_SELECT
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@small_alltypesorc2b
+PREHOOK: query: create table small_alltypesorc3b as select * from alltypesorc where cint
is not null and ctinyint is null order by ctinyint, csmallint, cint, cbigint, cfloat, cdouble,
cstring1, cstring2, ctimestamp1, ctimestamp2, cboolean1, cboolean2 limit 10
+PREHOOK: type: CREATETABLE_AS_SELECT
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: database:default
+PREHOOK: Output: default@small_alltypesorc3b
+POSTHOOK: query: create table small_alltypesorc3b as select * from alltypesorc where cint
is not null and ctinyint is null order by ctinyint, csmallint, cint, cbigint, cfloat, cdouble,
cstring1, cstring2, ctimestamp1, ctimestamp2, cboolean1, cboolean2 limit 10
+POSTHOOK: type: CREATETABLE_AS_SELECT
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@small_alltypesorc3b
+PREHOOK: query: create table small_alltypesorc4b as select * from alltypesorc where cint
is null and ctinyint is null order by ctinyint, csmallint, cint, cbigint, cfloat, cdouble,
cstring1, cstring2, ctimestamp1, ctimestamp2, cboolean1, cboolean2 limit 10
+PREHOOK: type: CREATETABLE_AS_SELECT
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: database:default
+PREHOOK: Output: default@small_alltypesorc4b
+POSTHOOK: query: create table small_alltypesorc4b as select * from alltypesorc where cint
is null and ctinyint is null order by ctinyint, csmallint, cint, cbigint, cfloat, cdouble,
cstring1, cstring2, ctimestamp1, ctimestamp2, cboolean1, cboolean2 limit 10
+POSTHOOK: type: CREATETABLE_AS_SELECT
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@small_alltypesorc4b
+PREHOOK: query: select * from small_alltypesorc1b
+PREHOOK: type: QUERY
+PREHOOK: Input: default@small_alltypesorc1b
+#### A masked pattern was here ####
+POSTHOOK: query: select * from small_alltypesorc1b
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@small_alltypesorc1b
+#### A masked pattern was here ####
+-64	-10462	626923679	NULL	-64.0	-10462.0	821UdmGbkEf4j	NULL	1969-12-31 16:00:02.496	1969-12-31
16:00:00.164	true	NULL
+-64	-15920	528534767	NULL	-64.0	-15920.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:51.859	1969-12-31
16:00:14.468	true	NULL
+-64	-3097	253665376	NULL	-64.0	-3097.0	1cGVWH7n1QU	NULL	1969-12-31 16:00:00.013	1969-12-31
16:00:06.097	true	NULL
+-64	-3586	626923679	NULL	-64.0	-3586.0	821UdmGbkEf4j	NULL	1969-12-31 16:00:11.952	1969-12-31
15:59:51.131	true	NULL
+-64	-4018	626923679	NULL	-64.0	-4018.0	821UdmGbkEf4j	NULL	1969-12-31 15:59:58.959	1969-12-31
16:00:07.803	true	NULL
+-64	-4040	528534767	NULL	-64.0	-4040.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:47.733	1969-12-31
15:59:46.044	true	NULL
+-64	-4803	626923679	NULL	-64.0	-4803.0	821UdmGbkEf4j	NULL	1969-12-31 16:00:04.662	1969-12-31
16:00:01.609	true	NULL
+-64	-6907	253665376	NULL	-64.0	-6907.0	1cGVWH7n1QU	NULL	NULL	1969-12-31 15:59:53.66	true
NULL
+-64	-8080	528534767	NULL	-64.0	-8080.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:58.044	1969-12-31
15:59:48.655	true	NULL
+-64	-9842	253665376	NULL	-64.0	-9842.0	1cGVWH7n1QU	NULL	1969-12-31 16:00:00.631	1969-12-31
16:00:01.781	true	NULL
+PREHOOK: query: select * from small_alltypesorc2b
+PREHOOK: type: QUERY
+PREHOOK: Input: default@small_alltypesorc2b
+#### A masked pattern was here ####
+POSTHOOK: query: select * from small_alltypesorc2b
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@small_alltypesorc2b
+#### A masked pattern was here ####
+-64	-200	NULL	-1809444706	-64.0	-200.0	NULL	B87YVb3UASqg	1969-12-31 16:00:10.858	1969-12-31
15:59:55.451	NULL	true
+-64	-200	NULL	2118653994	-64.0	-200.0	NULL	ONHGSDy1U4Ft431DfQp15	1969-12-31 16:00:03.944
1969-12-31 15:59:55.451	NULL	true
+-64	-200	NULL	927647669	-64.0	-200.0	NULL	DhxkBT	1969-12-31 16:00:00.199	1969-12-31 15:59:55.451
NULL	false
+-64	-7196	NULL	-1615920595	-64.0	-7196.0	NULL	X5rDjl	1969-12-31 16:00:11.912	1969-12-31 15:59:58.174
NULL	false
+-64	-7196	NULL	-1639157869	-64.0	-7196.0	NULL	IJ0Oj7qAiqNGsN7gn	1969-12-31 16:00:01.785	1969-12-31
15:59:58.174	NULL	false
+-64	-7196	NULL	-527203677	-64.0	-7196.0	NULL	JBE4H5RoK412Cs260I72	1969-12-31 15:59:50.184
1969-12-31 15:59:58.174	NULL	true
+-64	-7196	NULL	1090418478	-64.0	-7196.0	NULL	3E06w2	1969-12-31 16:00:00.29	1969-12-31 15:59:58.174
NULL	true
+-64	-7196	NULL	1805860756	-64.0	-7196.0	NULL	4aOn4s2ATygu0476eD	1969-12-31 16:00:12.339	1969-12-31
15:59:58.174	NULL	false
+-64	-7196	NULL	406535485	-64.0	-7196.0	NULL	E011i	1969-12-31 15:59:56.048	1969-12-31 15:59:58.174
NULL	false
+-64	-7196	NULL	658026952	-64.0	-7196.0	NULL	4tAur	1969-12-31 15:59:53.866	1969-12-31 15:59:58.174
NULL	true
+PREHOOK: query: select * from small_alltypesorc3b
+PREHOOK: type: QUERY
+PREHOOK: Input: default@small_alltypesorc3b
+#### A masked pattern was here ####
+POSTHOOK: query: select * from small_alltypesorc3b
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@small_alltypesorc3b
+#### A masked pattern was here ####
+NULL	NULL	-1015272448	-1887561756	NULL	NULL	jTQ68531mP	4hA4KQj2vD3fI6gX82220d	NULL	1969-12-31
15:59:45.854	false	false
+NULL	NULL	-609074876	-1887561756	NULL	NULL	EcM71	4hA4KQj2vD3fI6gX82220d	NULL	1969-12-31 15:59:55.061
true	false
+NULL	NULL	-700300206	-1887561756	NULL	NULL	kdqQE010	4hA4KQj2vD3fI6gX82220d	NULL	1969-12-31
15:59:58.384	false	false
+NULL	NULL	-726473298	1864027286	NULL	NULL	OFy1a1xf37f75b5N	4KWs6gw7lv2WYd66P	NULL	1969-12-31
16:00:11.799	true	true
+NULL	NULL	-738747840	-1645852809	NULL	NULL	vmAT10eeE47fgH20pLi	xH7445Rals48VOulSyR5F	NULL
1969-12-31 16:00:11.55	true	false
+NULL	NULL	-838810013	1864027286	NULL	NULL	N016jPED08o	4KWs6gw7lv2WYd66P	NULL	1969-12-31 15:59:44.252
false	true
+NULL	NULL	-850295959	-1887561756	NULL	NULL	WMIgGA73	4hA4KQj2vD3fI6gX82220d	NULL	1969-12-31
16:00:00.348	false	false
+NULL	NULL	-886426182	-1887561756	NULL	NULL	0i88xYq3gx1nW4vKjp7vBp3	4hA4KQj2vD3fI6gX82220d
NULL	1969-12-31 16:00:04.472	true	false
+NULL	NULL	-899422227	-1645852809	NULL	NULL	73xdw4X	xH7445Rals48VOulSyR5F	NULL	1969-12-31
16:00:07.395	false	false
+NULL	NULL	-971543377	-1645852809	NULL	NULL	uN803aW	xH7445Rals48VOulSyR5F	NULL	1969-12-31
16:00:05.43	false	false
+PREHOOK: query: select * from small_alltypesorc4b
+PREHOOK: type: QUERY
+PREHOOK: Input: default@small_alltypesorc4b
+#### A masked pattern was here ####
+POSTHOOK: query: select * from small_alltypesorc4b
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@small_alltypesorc4b
+#### A masked pattern was here ####
+PREHOOK: query: create table small_alltypesorc_b stored as orc as select * from 
+(select * from (select * from small_alltypesorc1b) sq1
+ union all
+ select * from (select * from small_alltypesorc2b) sq2
+ union all
+ select * from (select * from small_alltypesorc3b) sq3
+ union all
+ select * from (select * from small_alltypesorc4b) sq4) q
+PREHOOK: type: CREATETABLE_AS_SELECT
+PREHOOK: Input: default@small_alltypesorc1b
+PREHOOK: Input: default@small_alltypesorc2b
+PREHOOK: Input: default@small_alltypesorc3b
+PREHOOK: Input: default@small_alltypesorc4b
+PREHOOK: Output: database:default
+PREHOOK: Output: default@small_alltypesorc_b
+POSTHOOK: query: create table small_alltypesorc_b stored as orc as select * from 
+(select * from (select * from small_alltypesorc1b) sq1
+ union all
+ select * from (select * from small_alltypesorc2b) sq2
+ union all
+ select * from (select * from small_alltypesorc3b) sq3
+ union all
+ select * from (select * from small_alltypesorc4b) sq4) q
+POSTHOOK: type: CREATETABLE_AS_SELECT
+POSTHOOK: Input: default@small_alltypesorc1b
+POSTHOOK: Input: default@small_alltypesorc2b
+POSTHOOK: Input: default@small_alltypesorc3b
+POSTHOOK: Input: default@small_alltypesorc4b
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@small_alltypesorc_b
+PREHOOK: query: ANALYZE TABLE small_alltypesorc_b COMPUTE STATISTICS
+PREHOOK: type: QUERY
+PREHOOK: Input: default@small_alltypesorc_b
+PREHOOK: Output: default@small_alltypesorc_b
+POSTHOOK: query: ANALYZE TABLE small_alltypesorc_b COMPUTE STATISTICS
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@small_alltypesorc_b
+POSTHOOK: Output: default@small_alltypesorc_b
+PREHOOK: query: ANALYZE TABLE small_alltypesorc_b COMPUTE STATISTICS FOR COLUMNS
+PREHOOK: type: QUERY
+PREHOOK: Input: default@small_alltypesorc_b
+#### A masked pattern was here ####
+POSTHOOK: query: ANALYZE TABLE small_alltypesorc_b COMPUTE STATISTICS FOR COLUMNS
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@small_alltypesorc_b
+#### A masked pattern was here ####
+PREHOOK: query: select * from small_alltypesorc_b
+PREHOOK: type: QUERY
+PREHOOK: Input: default@small_alltypesorc_b
+#### A masked pattern was here ####
+POSTHOOK: query: select * from small_alltypesorc_b
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@small_alltypesorc_b
+#### A masked pattern was here ####
+-64	-10462	626923679	NULL	-64.0	-10462.0	821UdmGbkEf4j	NULL	1969-12-31 16:00:02.496	1969-12-31
16:00:00.164	true	NULL
+-64	-15920	528534767	NULL	-64.0	-15920.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:51.859	1969-12-31
16:00:14.468	true	NULL
+-64	-200	NULL	-1809444706	-64.0	-200.0	NULL	B87YVb3UASqg	1969-12-31 16:00:10.858	1969-12-31
15:59:55.451	NULL	true
+-64	-200	NULL	2118653994	-64.0	-200.0	NULL	ONHGSDy1U4Ft431DfQp15	1969-12-31 16:00:03.944
1969-12-31 15:59:55.451	NULL	true
+-64	-200	NULL	927647669	-64.0	-200.0	NULL	DhxkBT	1969-12-31 16:00:00.199	1969-12-31 15:59:55.451
NULL	false
+-64	-3097	253665376	NULL	-64.0	-3097.0	1cGVWH7n1QU	NULL	1969-12-31 16:00:00.013	1969-12-31
16:00:06.097	true	NULL
+-64	-3586	626923679	NULL	-64.0	-3586.0	821UdmGbkEf4j	NULL	1969-12-31 16:00:11.952	1969-12-31
15:59:51.131	true	NULL
+-64	-4018	626923679	NULL	-64.0	-4018.0	821UdmGbkEf4j	NULL	1969-12-31 15:59:58.959	1969-12-31
16:00:07.803	true	NULL
+-64	-4040	528534767	NULL	-64.0	-4040.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:47.733	1969-12-31
15:59:46.044	true	NULL
+-64	-4803	626923679	NULL	-64.0	-4803.0	821UdmGbkEf4j	NULL	1969-12-31 16:00:04.662	1969-12-31
16:00:01.609	true	NULL
+-64	-6907	253665376	NULL	-64.0	-6907.0	1cGVWH7n1QU	NULL	NULL	1969-12-31 15:59:53.66	true
NULL
+-64	-7196	NULL	-1615920595	-64.0	-7196.0	NULL	X5rDjl	1969-12-31 16:00:11.912	1969-12-31 15:59:58.174
NULL	false
+-64	-7196	NULL	-1639157869	-64.0	-7196.0	NULL	IJ0Oj7qAiqNGsN7gn	1969-12-31 16:00:01.785	1969-12-31
15:59:58.174	NULL	false
+-64	-7196	NULL	-527203677	-64.0	-7196.0	NULL	JBE4H5RoK412Cs260I72	1969-12-31 15:59:50.184
1969-12-31 15:59:58.174	NULL	true
+-64	-7196	NULL	1090418478	-64.0	-7196.0	NULL	3E06w2	1969-12-31 16:00:00.29	1969-12-31 15:59:58.174
NULL	true
+-64	-7196	NULL	1805860756	-64.0	-7196.0	NULL	4aOn4s2ATygu0476eD	1969-12-31 16:00:12.339	1969-12-31
15:59:58.174	NULL	false
+-64	-7196	NULL	406535485	-64.0	-7196.0	NULL	E011i	1969-12-31 15:59:56.048	1969-12-31 15:59:58.174
NULL	false
+-64	-7196	NULL	658026952	-64.0	-7196.0	NULL	4tAur	1969-12-31 15:59:53.866	1969-12-31 15:59:58.174
NULL	true
+-64	-8080	528534767	NULL	-64.0	-8080.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:58.044	1969-12-31
15:59:48.655	true	NULL
+-64	-9842	253665376	NULL	-64.0	-9842.0	1cGVWH7n1QU	NULL	1969-12-31 16:00:00.631	1969-12-31
16:00:01.781	true	NULL
+NULL	NULL	-1015272448	-1887561756	NULL	NULL	jTQ68531mP	4hA4KQj2vD3fI6gX82220d	NULL	1969-12-31
15:59:45.854	false	false
+NULL	NULL	-609074876	-1887561756	NULL	NULL	EcM71	4hA4KQj2vD3fI6gX82220d	NULL	1969-12-31 15:59:55.061
true	false
+NULL	NULL	-700300206	-1887561756	NULL	NULL	kdqQE010	4hA4KQj2vD3fI6gX82220d	NULL	1969-12-31
15:59:58.384	false	false
+NULL	NULL	-726473298	1864027286	NULL	NULL	OFy1a1xf37f75b5N	4KWs6gw7lv2WYd66P	NULL	1969-12-31
16:00:11.799	true	true
+NULL	NULL	-738747840	-1645852809	NULL	NULL	vmAT10eeE47fgH20pLi	xH7445Rals48VOulSyR5F	NULL
1969-12-31 16:00:11.55	true	false
+NULL	NULL	-838810013	1864027286	NULL	NULL	N016jPED08o	4KWs6gw7lv2WYd66P	NULL	1969-12-31 15:59:44.252
false	true
+NULL	NULL	-850295959	-1887561756	NULL	NULL	WMIgGA73	4hA4KQj2vD3fI6gX82220d	NULL	1969-12-31
16:00:00.348	false	false
+NULL	NULL	-886426182	-1887561756	NULL	NULL	0i88xYq3gx1nW4vKjp7vBp3	4hA4KQj2vD3fI6gX82220d
NULL	1969-12-31 16:00:04.472	true	false
+NULL	NULL	-899422227	-1645852809	NULL	NULL	73xdw4X	xH7445Rals48VOulSyR5F	NULL	1969-12-31
16:00:07.395	false	false
+NULL	NULL	-971543377	-1645852809	NULL	NULL	uN803aW	xH7445Rals48VOulSyR5F	NULL	1969-12-31
16:00:05.43	false	false
+PREHOOK: query: explain
+select * 
+from small_alltypesorc_b c
+left outer join small_alltypesorc_b cd
+  on cd.cint = c.cint
+PREHOOK: type: QUERY
+POSTHOOK: query: explain
+select * 
+from small_alltypesorc_b c
+left outer join small_alltypesorc_b cd
+  on cd.cint = c.cint
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+  Stage-2 is a root stage
+  Stage-1 depends on stages: Stage-2
+  Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+  Stage: Stage-2
+    Spark
+#### A masked pattern was here ####
+      Vertices:
+        Map 2 
+            Map Operator Tree:
+                TableScan
+                  alias: c
+                  Statistics: Num rows: 30 Data size: 4298 Basic stats: COMPLETE Column stats:
NONE
+                  Select Operator
+                    expressions: ctinyint (type: tinyint), csmallint (type: smallint), cint
(type: int), cbigint (type: bigint), cfloat (type: float), cdouble (type: double), cstring1
(type: string), cstring2 (type: string), ctimestamp1 (type: timestamp), ctimestamp2 (type:
timestamp), cboolean1 (type: boolean), cboolean2 (type: boolean)
+                    outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7,
_col8, _col9, _col10, _col11
+                    Statistics: Num rows: 30 Data size: 4298 Basic stats: COMPLETE Column
stats: NONE
+                    Spark HashTable Sink Operator
+                      keys:
+                        0 _col2 (type: int)
+                        1 _col2 (type: int)
+            Local Work:
+              Map Reduce Local Work
+            Execution mode: vectorized
+
+  Stage: Stage-1
+    Spark
+#### A masked pattern was here ####
+      Vertices:
+        Map 1 
+            Map Operator Tree:
+                TableScan
+                  alias: c
+                  Statistics: Num rows: 30 Data size: 4298 Basic stats: COMPLETE Column stats:
NONE
+                  Select Operator
+                    expressions: ctinyint (type: tinyint), csmallint (type: smallint), cint
(type: int), cbigint (type: bigint), cfloat (type: float), cdouble (type: double), cstring1
(type: string), cstring2 (type: string), ctimestamp1 (type: timestamp), ctimestamp2 (type:
timestamp), cboolean1 (type: boolean), cboolean2 (type: boolean)
+                    outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7,
_col8, _col9, _col10, _col11
+                    Statistics: Num rows: 30 Data size: 4298 Basic stats: COMPLETE Column
stats: NONE
+                    Map Join Operator
+                      condition map:
+                           Left Outer Join0 to 1
+                      keys:
+                        0 _col2 (type: int)
+                        1 _col2 (type: int)
+                      outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6,
_col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16, _col17, _col18,
_col19, _col20, _col21, _col22, _col23
+                      input vertices:
+                        1 Map 2
+                      Statistics: Num rows: 33 Data size: 4727 Basic stats: COMPLETE Column
stats: NONE
+                      File Output Operator
+                        compressed: false
+                        Statistics: Num rows: 33 Data size: 4727 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
+            Local Work:
+              Map Reduce Local Work
+            Execution mode: vectorized
+
+  Stage: Stage-0
+    Fetch Operator
+      limit: -1
+      Processor Tree:
+        ListSink
+
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+select * 
+from small_alltypesorc_b c
+left outer join small_alltypesorc_b cd
+  on cd.cint = c.cint
+PREHOOK: type: QUERY
+PREHOOK: Input: default@small_alltypesorc_b
+#### A masked pattern was here ####
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+select * 
+from small_alltypesorc_b c
+left outer join small_alltypesorc_b cd
+  on cd.cint = c.cint
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@small_alltypesorc_b
+#### A masked pattern was here ####
+-64	-10462	626923679	NULL	-64.0	-10462.0	821UdmGbkEf4j	NULL	1969-12-31 16:00:02.496	1969-12-31
16:00:00.164	true	NULL	-64	-10462	626923679	NULL	-64.0	-10462.0	821UdmGbkEf4j	NULL	1969-12-31
16:00:02.496	1969-12-31 16:00:00.164	true	NULL
+-64	-10462	626923679	NULL	-64.0	-10462.0	821UdmGbkEf4j	NULL	1969-12-31 16:00:02.496	1969-12-31
16:00:00.164	true	NULL	-64	-3586	626923679	NULL	-64.0	-3586.0	821UdmGbkEf4j	NULL	1969-12-31
16:00:11.952	1969-12-31 15:59:51.131	true	NULL
+-64	-10462	626923679	NULL	-64.0	-10462.0	821UdmGbkEf4j	NULL	1969-12-31 16:00:02.496	1969-12-31
16:00:00.164	true	NULL	-64	-4018	626923679	NULL	-64.0	-4018.0	821UdmGbkEf4j	NULL	1969-12-31
15:59:58.959	1969-12-31 16:00:07.803	true	NULL
+-64	-10462	626923679	NULL	-64.0	-10462.0	821UdmGbkEf4j	NULL	1969-12-31 16:00:02.496	1969-12-31
16:00:00.164	true	NULL	-64	-4803	626923679	NULL	-64.0	-4803.0	821UdmGbkEf4j	NULL	1969-12-31
16:00:04.662	1969-12-31 16:00:01.609	true	NULL
+-64	-15920	528534767	NULL	-64.0	-15920.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:51.859	1969-12-31
16:00:14.468	true	NULL	-64	-15920	528534767	NULL	-64.0	-15920.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31
15:59:51.859	1969-12-31 16:00:14.468	true	NULL
+-64	-15920	528534767	NULL	-64.0	-15920.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:51.859	1969-12-31
16:00:14.468	true	NULL	-64	-4040	528534767	NULL	-64.0	-4040.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31
15:59:47.733	1969-12-31 15:59:46.044	true	NULL
+-64	-15920	528534767	NULL	-64.0	-15920.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:51.859	1969-12-31
16:00:14.468	true	NULL	-64	-8080	528534767	NULL	-64.0	-8080.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31
15:59:58.044	1969-12-31 15:59:48.655	true	NULL
+-64	-200	NULL	-1809444706	-64.0	-200.0	NULL	B87YVb3UASqg	1969-12-31 16:00:10.858	1969-12-31
15:59:55.451	NULL	true	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
+-64	-200	NULL	2118653994	-64.0	-200.0	NULL	ONHGSDy1U4Ft431DfQp15	1969-12-31 16:00:03.944
1969-12-31 15:59:55.451	NULL	true	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
+-64	-200	NULL	927647669	-64.0	-200.0	NULL	DhxkBT	1969-12-31 16:00:00.199	1969-12-31 15:59:55.451
NULL	false	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
+-64	-3097	253665376	NULL	-64.0	-3097.0	1cGVWH7n1QU	NULL	1969-12-31 16:00:00.013	1969-12-31
16:00:06.097	true	NULL	-64	-3097	253665376	NULL	-64.0	-3097.0	1cGVWH7n1QU	NULL	1969-12-31
16:00:00.013	1969-12-31 16:00:06.097	true	NULL
+-64	-3097	253665376	NULL	-64.0	-3097.0	1cGVWH7n1QU	NULL	1969-12-31 16:00:00.013	1969-12-31
16:00:06.097	true	NULL	-64	-6907	253665376	NULL	-64.0	-6907.0	1cGVWH7n1QU	NULL	NULL	1969-12-31
15:59:53.66	true	NULL
+-64	-3097	253665376	NULL	-64.0	-3097.0	1cGVWH7n1QU	NULL	1969-12-31 16:00:00.013	1969-12-31
16:00:06.097	true	NULL	-64	-9842	253665376	NULL	-64.0	-9842.0	1cGVWH7n1QU	NULL	1969-12-31
16:00:00.631	1969-12-31 16:00:01.781	true	NULL
+-64	-3586	626923679	NULL	-64.0	-3586.0	821UdmGbkEf4j	NULL	1969-12-31 16:00:11.952	1969-12-31
15:59:51.131	true	NULL	-64	-10462	626923679	NULL	-64.0	-10462.0	821UdmGbkEf4j	NULL	1969-12-31
16:00:02.496	1969-12-31 16:00:00.164	true	NULL
+-64	-3586	626923679	NULL	-64.0	-3586.0	821UdmGbkEf4j	NULL	1969-12-31 16:00:11.952	1969-12-31
15:59:51.131	true	NULL	-64	-3586	626923679	NULL	-64.0	-3586.0	821UdmGbkEf4j	NULL	1969-12-31
16:00:11.952	1969-12-31 15:59:51.131	true	NULL
+-64	-3586	626923679	NULL	-64.0	-3586.0	821UdmGbkEf4j	NULL	1969-12-31 16:00:11.952	1969-12-31
15:59:51.131	true	NULL	-64	-4018	626923679	NULL	-64.0	-4018.0	821UdmGbkEf4j	NULL	1969-12-31
15:59:58.959	1969-12-31 16:00:07.803	true	NULL
+-64	-3586	626923679	NULL	-64.0	-3586.0	821UdmGbkEf4j	NULL	1969-12-31 16:00:11.952	1969-12-31
15:59:51.131	true	NULL	-64	-4803	626923679	NULL	-64.0	-4803.0	821UdmGbkEf4j	NULL	1969-12-31
16:00:04.662	1969-12-31 16:00:01.609	true	NULL
+-64	-4018	626923679	NULL	-64.0	-4018.0	821UdmGbkEf4j	NULL	1969-12-31 15:59:58.959	1969-12-31
16:00:07.803	true	NULL	-64	-10462	626923679	NULL	-64.0	-10462.0	821UdmGbkEf4j	NULL	1969-12-31
16:00:02.496	1969-12-31 16:00:00.164	true	NULL
+-64	-4018	626923679	NULL	-64.0	-4018.0	821UdmGbkEf4j	NULL	1969-12-31 15:59:58.959	1969-12-31
16:00:07.803	true	NULL	-64	-3586	626923679	NULL	-64.0	-3586.0	821UdmGbkEf4j	NULL	1969-12-31
16:00:11.952	1969-12-31 15:59:51.131	true	NULL
+-64	-4018	626923679	NULL	-64.0	-4018.0	821UdmGbkEf4j	NULL	1969-12-31 15:59:58.959	1969-12-31
16:00:07.803	true	NULL	-64	-4018	626923679	NULL	-64.0	-4018.0	821UdmGbkEf4j	NULL	1969-12-31
15:59:58.959	1969-12-31 16:00:07.803	true	NULL
+-64	-4018	626923679	NULL	-64.0	-4018.0	821UdmGbkEf4j	NULL	1969-12-31 15:59:58.959	1969-12-31
16:00:07.803	true	NULL	-64	-4803	626923679	NULL	-64.0	-4803.0	821UdmGbkEf4j	NULL	1969-12-31
16:00:04.662	1969-12-31 16:00:01.609	true	NULL
+-64	-4040	528534767	NULL	-64.0	-4040.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:47.733	1969-12-31
15:59:46.044	true	NULL	-64	-15920	528534767	NULL	-64.0	-15920.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31
15:59:51.859	1969-12-31 16:00:14.468	true	NULL
+-64	-4040	528534767	NULL	-64.0	-4040.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:47.733	1969-12-31
15:59:46.044	true	NULL	-64	-4040	528534767	NULL	-64.0	-4040.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31
15:59:47.733	1969-12-31 15:59:46.044	true	NULL
+-64	-4040	528534767	NULL	-64.0	-4040.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:47.733	1969-12-31
15:59:46.044	true	NULL	-64	-8080	528534767	NULL	-64.0	-8080.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31
15:59:58.044	1969-12-31 15:59:48.655	true	NULL
+-64	-4803	626923679	NULL	-64.0	-4803.0	821UdmGbkEf4j	NULL	1969-12-31 16:00:04.662	1969-12-31
16:00:01.609	true	NULL	-64	-10462	626923679	NULL	-64.0	-10462.0	821UdmGbkEf4j	NULL	1969-12-31
16:00:02.496	1969-12-31 16:00:00.164	true	NULL
+-64	-4803	626923679	NULL	-64.0	-4803.0	821UdmGbkEf4j	NULL	1969-12-31 16:00:04.662	1969-12-31
16:00:01.609	true	NULL	-64	-3586	626923679	NULL	-64.0	-3586.0	821UdmGbkEf4j	NULL	1969-12-31
16:00:11.952	1969-12-31 15:59:51.131	true	NULL
+-64	-4803	626923679	NULL	-64.0	-4803.0	821UdmGbkEf4j	NULL	1969-12-31 16:00:04.662	1969-12-31
16:00:01.609	true	NULL	-64	-4018	626923679	NULL	-64.0	-4018.0	821UdmGbkEf4j	NULL	1969-12-31
15:59:58.959	1969-12-31 16:00:07.803	true	NULL
+-64	-4803	626923679	NULL	-64.0	-4803.0	821UdmGbkEf4j	NULL	1969-12-31 16:00:04.662	1969-12-31
16:00:01.609	true	NULL	-64	-4803	626923679	NULL	-64.0	-4803.0	821UdmGbkEf4j	NULL	1969-12-31
16:00:04.662	1969-12-31 16:00:01.609	true	NULL
+-64	-6907	253665376	NULL	-64.0	-6907.0	1cGVWH7n1QU	NULL	NULL	1969-12-31 15:59:53.66	true
NULL	-64	-3097	253665376	NULL	-64.0	-3097.0	1cGVWH7n1QU	NULL	1969-12-31 16:00:00.013	1969-12-31
16:00:06.097	true	NULL
+-64	-6907	253665376	NULL	-64.0	-6907.0	1cGVWH7n1QU	NULL	NULL	1969-12-31 15:59:53.66	true
NULL	-64	-6907	253665376	NULL	-64.0	-6907.0	1cGVWH7n1QU	NULL	NULL	1969-12-31 15:59:53.66	true
NULL
+-64	-6907	253665376	NULL	-64.0	-6907.0	1cGVWH7n1QU	NULL	NULL	1969-12-31 15:59:53.66	true
NULL	-64	-9842	253665376	NULL	-64.0	-9842.0	1cGVWH7n1QU	NULL	1969-12-31 16:00:00.631	1969-12-31
16:00:01.781	true	NULL
+-64	-7196	NULL	-1615920595	-64.0	-7196.0	NULL	X5rDjl	1969-12-31 16:00:11.912	1969-12-31 15:59:58.174
NULL	false	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
+-64	-7196	NULL	-1639157869	-64.0	-7196.0	NULL	IJ0Oj7qAiqNGsN7gn	1969-12-31 16:00:01.785	1969-12-31
15:59:58.174	NULL	false	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
+-64	-7196	NULL	-527203677	-64.0	-7196.0	NULL	JBE4H5RoK412Cs260I72	1969-12-31 15:59:50.184
1969-12-31 15:59:58.174	NULL	true	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
+-64	-7196	NULL	1090418478	-64.0	-7196.0	NULL	3E06w2	1969-12-31 16:00:00.29	1969-12-31 15:59:58.174
NULL	true	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
+-64	-7196	NULL	1805860756	-64.0	-7196.0	NULL	4aOn4s2ATygu0476eD	1969-12-31 16:00:12.339	1969-12-31
15:59:58.174	NULL	false	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
+-64	-7196	NULL	406535485	-64.0	-7196.0	NULL	E011i	1969-12-31 15:59:56.048	1969-12-31 15:59:58.174
NULL	false	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
+-64	-7196	NULL	658026952	-64.0	-7196.0	NULL	4tAur	1969-12-31 15:59:53.866	1969-12-31 15:59:58.174
NULL	true	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
+-64	-8080	528534767	NULL	-64.0	-8080.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:58.044	1969-12-31
15:59:48.655	true	NULL	-64	-15920	528534767	NULL	-64.0	-15920.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31
15:59:51.859	1969-12-31 16:00:14.468	true	NULL
+-64	-8080	528534767	NULL	-64.0	-8080.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:58.044	1969-12-31
15:59:48.655	true	NULL	-64	-4040	528534767	NULL	-64.0	-4040.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31
15:59:47.733	1969-12-31 15:59:46.044	true	NULL
+-64	-8080	528534767	NULL	-64.0	-8080.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31 15:59:58.044	1969-12-31
15:59:48.655	true	NULL	-64	-8080	528534767	NULL	-64.0	-8080.0	cvLH6Eat2yFsyy7p	NULL	1969-12-31
15:59:58.044	1969-12-31 15:59:48.655	true	NULL
+-64	-9842	253665376	NULL	-64.0	-9842.0	1cGVWH7n1QU	NULL	1969-12-31 16:00:00.631	1969-12-31
16:00:01.781	true	NULL	-64	-3097	253665376	NULL	-64.0	-3097.0	1cGVWH7n1QU	NULL	1969-12-31
16:00:00.013	1969-12-31 16:00:06.097	true	NULL
+-64	-9842	253665376	NULL	-64.0	-9842.0	1cGVWH7n1QU	NULL	1969-12-31 16:00:00.631	1969-12-31
16:00:01.781	true	NULL	-64	-6907	253665376	NULL	-64.0	-6907.0	1cGVWH7n1QU	NULL	NULL	1969-12-31
15:59:53.66	true	NULL
+-64	-9842	253665376	NULL	-64.0	-9842.0	1cGVWH7n1QU	NULL	1969-12-31 16:00:00.631	1969-12-31
16:00:01.781	true	NULL	-64	-9842	253665376	NULL	-64.0	-9842.0	1cGVWH7n1QU	NULL	1969-12-31
16:00:00.631	1969-12-31 16:00:01.781	true	NULL
+NULL	NULL	-1015272448	-1887561756	NULL	NULL	jTQ68531mP	4hA4KQj2vD3fI6gX82220d	NULL	1969-12-31
15:59:45.854	false	false	NULL	NULL	-1015272448	-1887561756	NULL	NULL	jTQ68531mP	4hA4KQj2vD3fI6gX82220d
NULL	1969-12-31 15:59:45.854	false	false
+NULL	NULL	-609074876	-1887561756	NULL	NULL	EcM71	4hA4KQj2vD3fI6gX82220d	NULL	1969-12-31 15:59:55.061
true	false	NULL	NULL	-609074876	-1887561756	NULL	NULL	EcM71	4hA4KQj2vD3fI6gX82220d	NULL	1969-12-31
15:59:55.061	true	false
+NULL	NULL	-700300206	-1887561756	NULL	NULL	kdqQE010	4hA4KQj2vD3fI6gX82220d	NULL	1969-12-31
15:59:58.384	false	false	NULL	NULL	-700300206	-1887561756	NULL	NULL	kdqQE010	4hA4KQj2vD3fI6gX82220d
NULL	1969-12-31 15:59:58.384	false	false
+NULL	NULL	-726473298	1864027286	NULL	NULL	OFy1a1xf37f75b5N	4KWs6gw7lv2WYd66P	NULL	1969-12-31
16:00:11.799	true	true	NULL	NULL	-726473298	1864027286	NULL	NULL	OFy1a1xf37f75b5N	4KWs6gw7lv2WYd66P
NULL	1969-12-31 16:00:11.799	true	true
+NULL	NULL	-738747840	-1645852809	NULL	NULL	vmAT10eeE47fgH20pLi	xH7445Rals48VOulSyR5F	NULL
1969-12-31 16:00:11.55	true	false	NULL	NULL	-738747840	-1645852809	NULL	NULL	vmAT10eeE47fgH20pLi
xH7445Rals48VOulSyR5F	NULL	1969-12-31 16:00:11.55	true	false
+NULL	NULL	-838810013	1864027286	NULL	NULL	N016jPED08o	4KWs6gw7lv2WYd66P	NULL	1969-12-31 15:59:44.252
false	true	NULL	NULL	-838810013	1864027286	NULL	NULL	N016jPED08o	4KWs6gw7lv2WYd66P	NULL	1969-12-31
15:59:44.252	false	true
+NULL	NULL	-850295959	-1887561756	NULL	NULL	WMIgGA73	4hA4KQj2vD3fI6gX82220d	NULL	1969-12-31
16:00:00.348	false	false	NULL	NULL	-850295959	-1887561756	NULL	NULL	WMIgGA73	4hA4KQj2vD3fI6gX82220d
NULL	1969-12-31 16:00:00.348	false	false
+NULL	NULL	-886426182	-1887561756	NULL	NULL	0i88xYq3gx1nW4vKjp7vBp3	4hA4KQj2vD3fI6gX82220d
NULL	1969-12-31 16:00:04.472	true	false	NULL	NULL	-886426182	-1887561756	NULL	NULL	0i88xYq3gx1nW4vKjp7vBp3
4hA4KQj2vD3fI6gX82220d	NULL	1969-12-31 16:00:04.472	true	false
+NULL	NULL	-899422227	-1645852809	NULL	NULL	73xdw4X	xH7445Rals48VOulSyR5F	NULL	1969-12-31
16:00:07.395	false	false	NULL	NULL	-899422227	-1645852809	NULL	NULL	73xdw4X	xH7445Rals48VOulSyR5F
NULL	1969-12-31 16:00:07.395	false	false
+NULL	NULL	-971543377	-1645852809	NULL	NULL	uN803aW	xH7445Rals48VOulSyR5F	NULL	1969-12-31
16:00:05.43	false	false	NULL	NULL	-971543377	-1645852809	NULL	NULL	uN803aW	xH7445Rals48VOulSyR5F
NULL	1969-12-31 16:00:05.43	false	false
+PREHOOK: query: explain
+select c.ctinyint 
+from small_alltypesorc_b c
+left outer join small_alltypesorc_b hd
+  on hd.ctinyint = c.ctinyint
+PREHOOK: type: QUERY
+POSTHOOK: query: explain
+select c.ctinyint 
+from small_alltypesorc_b c
+left outer join small_alltypesorc_b hd
+  on hd.ctinyint = c.ctinyint
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+  Stage-2 is a root stage
+  Stage-1 depends on stages: Stage-2
+  Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+  Stage: Stage-2
+    Spark
+#### A masked pattern was here ####
+      Vertices:
+        Map 2 
+            Map Operator Tree:
+                TableScan
+                  alias: c
+                  Statistics: Num rows: 30 Data size: 4298 Basic stats: COMPLETE Column stats:
NONE
+                  Select Operator
+                    expressions: ctinyint (type: tinyint)
+                    outputColumnNames: _col0
+                    Statistics: Num rows: 30 Data size: 4298 Basic stats: COMPLETE Column
stats: NONE
+                    Spark HashTable Sink Operator
+                      keys:
+                        0 _col0 (type: tinyint)
+                        1 _col0 (type: tinyint)
+            Local Work:
+              Map Reduce Local Work
+            Execution mode: vectorized
+
+  Stage: Stage-1
+    Spark
+#### A masked pattern was here ####
+      Vertices:
+        Map 1 
+            Map Operator Tree:
+                TableScan
+                  alias: c
+                  Statistics: Num rows: 30 Data size: 4298 Basic stats: COMPLETE Column stats:
NONE
+                  Select Operator
+                    expressions: ctinyint (type: tinyint)
+                    outputColumnNames: _col0
+                    Statistics: Num rows: 30 Data size: 4298 Basic stats: COMPLETE Column
stats: NONE
+                    Map Join Operator
+                      condition map:
+                           Left Outer Join0 to 1
+                      keys:
+                        0 _col0 (type: tinyint)
+                        1 _col0 (type: tinyint)
+                      outputColumnNames: _col0
+                      input vertices:
+                        1 Map 2
+                      Statistics: Num rows: 33 Data size: 4727 Basic stats: COMPLETE Column
stats: NONE
+                      File Output Operator
+                        compressed: false
+                        Statistics: Num rows: 33 Data size: 4727 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
+            Local Work:
+              Map Reduce Local Work
+            Execution mode: vectorized
+
+  Stage: Stage-0
+    Fetch Operator
+      limit: -1
+      Processor Tree:
+        ListSink
+
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+select c.ctinyint 
+from small_alltypesorc_b c
+left outer join small_alltypesorc_b hd
+  on hd.ctinyint = c.ctinyint
+PREHOOK: type: QUERY
+PREHOOK: Input: default@small_alltypesorc_b
+#### A masked pattern was here ####
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+select c.ctinyint 
+from small_alltypesorc_b c
+left outer join small_alltypesorc_b hd
+  on hd.ctinyint = c.ctinyint
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@small_alltypesorc_b
+#### A masked pattern was here ####
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+-64
+NULL
+NULL
+NULL
+NULL
+NULL
+NULL
+NULL
+NULL
+NULL
+NULL
+PREHOOK: query: explain
+select count(*) from (select c.ctinyint 
+from small_alltypesorc_b c
+left outer join small_alltypesorc_b cd
+  on cd.cint = c.cint 
+left outer join small_alltypesorc_b hd
+  on hd.ctinyint = c.ctinyint
+) t1
+PREHOOK: type: QUERY
+POSTHOOK: query: explain
+select count(*) from (select c.ctinyint 
+from small_alltypesorc_b c
+left outer join small_alltypesorc_b cd
+  on cd.cint = c.cint 
+left outer join small_alltypesorc_b hd
+  on hd.ctinyint = c.ctinyint
+) t1
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+  Stage-2 is a root stage
+  Stage-1 depends on stages: Stage-2
+  Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+  Stage: Stage-2
+    Spark
+#### A masked pattern was here ####
+      Vertices:
+        Map 3 
+            Map Operator Tree:
+                TableScan
+                  alias: c
+                  Statistics: Num rows: 30 Data size: 4298 Basic stats: COMPLETE Column stats:
NONE
+                  Select Operator
+                    expressions: cint (type: int)
+                    outputColumnNames: _col0
+                    Statistics: Num rows: 30 Data size: 4298 Basic stats: COMPLETE Column
stats: NONE
+                    Spark HashTable Sink Operator
+                      keys:
+                        0 _col1 (type: int)
+                        1 _col0 (type: int)
+            Local Work:
+              Map Reduce Local Work
+            Execution mode: vectorized
+        Map 4 
+            Map Operator Tree:
+                TableScan
+                  alias: c
+                  Statistics: Num rows: 30 Data size: 4298 Basic stats: COMPLETE Column stats:
NONE
+                  Select Operator
+                    expressions: ctinyint (type: tinyint)
+                    outputColumnNames: _col0
+                    Statistics: Num rows: 30 Data size: 4298 Basic stats: COMPLETE Column
stats: NONE
+                    Spark HashTable Sink Operator
+                      keys:
+                        0 _col0 (type: tinyint)
+                        1 _col0 (type: tinyint)
+            Local Work:
+              Map Reduce Local Work
+            Execution mode: vectorized
+
+  Stage: Stage-1
+    Spark
+      Edges:
+        Reducer 2 <- Map 1 (GROUP, 1)
+#### A masked pattern was here ####
+      Vertices:
+        Map 1 
+            Map Operator Tree:
+                TableScan
+                  alias: c
+                  Statistics: Num rows: 30 Data size: 4298 Basic stats: COMPLETE Column stats:
NONE
+                  Select Operator
+                    expressions: ctinyint (type: tinyint), cint (type: int)
+                    outputColumnNames: _col0, _col1
+                    Statistics: Num rows: 30 Data size: 4298 Basic stats: COMPLETE Column
stats: NONE
+                    Map Join Operator
+                      condition map:
+                           Left Outer Join0 to 1
+                      keys:
+                        0 _col1 (type: int)
+                        1 _col0 (type: int)
+                      outputColumnNames: _col0
+                      input vertices:
+                        1 Map 3
+                      Statistics: Num rows: 33 Data size: 4727 Basic stats: COMPLETE Column
stats: NONE
+                      Map Join Operator
+                        condition map:
+                             Left Outer Join0 to 1
+                        keys:
+                          0 _col0 (type: tinyint)
+                          1 _col0 (type: tinyint)
+                        input vertices:
+                          1 Map 4
+                        Statistics: Num rows: 36 Data size: 5199 Basic stats: COMPLETE Column
stats: NONE
+                        Group By Operator
+                          aggregations: count()
+                          mode: hash
+                          outputColumnNames: _col0
+                          Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column
stats: NONE
+                          Reduce Output Operator
+                            sort order: 
+                            Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column
stats: NONE
+                            value expressions: _col0 (type: bigint)
+            Local Work:
+              Map Reduce Local Work
+            Execution mode: vectorized
+        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:
NONE
+                File Output Operator
+                  compressed: false
+                  Statistics: Num rows: 1 Data size: 8 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
+            Execution mode: vectorized
+
+  Stage: Stage-0
+    Fetch Operator
+      limit: -1
+      Processor Tree:
+        ListSink
+
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+select count(*) from (select c.ctinyint
+from small_alltypesorc_b c
+left outer join small_alltypesorc_b cd
+  on cd.cint = c.cint 
+left outer join small_alltypesorc_b hd
+  on hd.ctinyint = c.ctinyint
+) t1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@small_alltypesorc_b
+#### A masked pattern was here ####
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+select count(*) from (select c.ctinyint
+from small_alltypesorc_b c
+left outer join small_alltypesorc_b cd
+  on cd.cint = c.cint 
+left outer join small_alltypesorc_b hd
+  on hd.ctinyint = c.ctinyint
+) t1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@small_alltypesorc_b
+#### A masked pattern was here ####
+890


Mime
View raw message