HIVE-18797 : ExprConstNodeDesc's getExprString should put appropriate qualifier with...
[hive.git] / ql / src / test / results / clientpositive / spark / parquet_vectorization_part_project.q.out
1 PREHOOK: query: CREATE TABLE alltypesparquet_part(ctinyint tinyint, csmallint smallint, cint int, cbigint bigint, cfloat float, cdouble double, cstring1 string, cstring2 string, ctimestamp1 timestamp, ctimestamp2 timestamp, cboolean1 boolean, cboolean2 boolean) partitioned by (ds string) STORED AS PARQUET
2 PREHOOK: type: CREATETABLE
3 PREHOOK: Output: database:default
4 PREHOOK: Output: default@alltypesparquet_part
5 POSTHOOK: query: CREATE TABLE alltypesparquet_part(ctinyint tinyint, csmallint smallint, cint int, cbigint bigint, cfloat float, cdouble double, cstring1 string, cstring2 string, ctimestamp1 timestamp, ctimestamp2 timestamp, cboolean1 boolean, cboolean2 boolean) partitioned by (ds string) STORED AS PARQUET
6 POSTHOOK: type: CREATETABLE
7 POSTHOOK: Output: database:default
8 POSTHOOK: Output: default@alltypesparquet_part
9 PREHOOK: query: insert overwrite table alltypesparquet_part partition (ds='2011') select * from alltypesparquet order by ctinyint, cint, cbigint limit 100
10 PREHOOK: type: QUERY
11 PREHOOK: Input: default@alltypesparquet
12 PREHOOK: Output: default@alltypesparquet_part@ds=2011
13 POSTHOOK: query: insert overwrite table alltypesparquet_part partition (ds='2011') select * from alltypesparquet order by ctinyint, cint, cbigint limit 100
14 POSTHOOK: type: QUERY
15 POSTHOOK: Input: default@alltypesparquet
16 POSTHOOK: Output: default@alltypesparquet_part@ds=2011
17 POSTHOOK: Lineage: alltypesparquet_part PARTITION(ds=2011).cbigint SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:cbigint, type:bigint, comment:null), ]
18 POSTHOOK: Lineage: alltypesparquet_part PARTITION(ds=2011).cboolean1 SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:cboolean1, type:boolean, comment:null), ]
19 POSTHOOK: Lineage: alltypesparquet_part PARTITION(ds=2011).cboolean2 SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:cboolean2, type:boolean, comment:null), ]
20 POSTHOOK: Lineage: alltypesparquet_part PARTITION(ds=2011).cdouble SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:cdouble, type:double, comment:null), ]
21 POSTHOOK: Lineage: alltypesparquet_part PARTITION(ds=2011).cfloat SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:cfloat, type:float, comment:null), ]
22 POSTHOOK: Lineage: alltypesparquet_part PARTITION(ds=2011).cint SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:cint, type:int, comment:null), ]
23 POSTHOOK: Lineage: alltypesparquet_part PARTITION(ds=2011).csmallint SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:csmallint, type:smallint, comment:null), ]
24 POSTHOOK: Lineage: alltypesparquet_part PARTITION(ds=2011).cstring1 SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:cstring1, type:string, comment:null), ]
25 POSTHOOK: Lineage: alltypesparquet_part PARTITION(ds=2011).cstring2 SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:cstring2, type:string, comment:null), ]
26 POSTHOOK: Lineage: alltypesparquet_part PARTITION(ds=2011).ctimestamp1 SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:ctimestamp1, type:timestamp, comment:null), ]
27 POSTHOOK: Lineage: alltypesparquet_part PARTITION(ds=2011).ctimestamp2 SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:ctimestamp2, type:timestamp, comment:null), ]
28 POSTHOOK: Lineage: alltypesparquet_part PARTITION(ds=2011).ctinyint SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:ctinyint, type:tinyint, comment:null), ]
29 PREHOOK: query: insert overwrite table alltypesparquet_part partition (ds='2012') select * from alltypesparquet order by ctinyint, cint, cbigint limit 100
30 PREHOOK: type: QUERY
31 PREHOOK: Input: default@alltypesparquet
32 PREHOOK: Output: default@alltypesparquet_part@ds=2012
33 POSTHOOK: query: insert overwrite table alltypesparquet_part partition (ds='2012') select * from alltypesparquet order by ctinyint, cint, cbigint limit 100
34 POSTHOOK: type: QUERY
35 POSTHOOK: Input: default@alltypesparquet
36 POSTHOOK: Output: default@alltypesparquet_part@ds=2012
37 POSTHOOK: Lineage: alltypesparquet_part PARTITION(ds=2012).cbigint SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:cbigint, type:bigint, comment:null), ]
38 POSTHOOK: Lineage: alltypesparquet_part PARTITION(ds=2012).cboolean1 SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:cboolean1, type:boolean, comment:null), ]
39 POSTHOOK: Lineage: alltypesparquet_part PARTITION(ds=2012).cboolean2 SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:cboolean2, type:boolean, comment:null), ]
40 POSTHOOK: Lineage: alltypesparquet_part PARTITION(ds=2012).cdouble SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:cdouble, type:double, comment:null), ]
41 POSTHOOK: Lineage: alltypesparquet_part PARTITION(ds=2012).cfloat SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:cfloat, type:float, comment:null), ]
42 POSTHOOK: Lineage: alltypesparquet_part PARTITION(ds=2012).cint SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:cint, type:int, comment:null), ]
43 POSTHOOK: Lineage: alltypesparquet_part PARTITION(ds=2012).csmallint SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:csmallint, type:smallint, comment:null), ]
44 POSTHOOK: Lineage: alltypesparquet_part PARTITION(ds=2012).cstring1 SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:cstring1, type:string, comment:null), ]
45 POSTHOOK: Lineage: alltypesparquet_part PARTITION(ds=2012).cstring2 SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:cstring2, type:string, comment:null), ]
46 POSTHOOK: Lineage: alltypesparquet_part PARTITION(ds=2012).ctimestamp1 SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:ctimestamp1, type:timestamp, comment:null), ]
47 POSTHOOK: Lineage: alltypesparquet_part PARTITION(ds=2012).ctimestamp2 SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:ctimestamp2, type:timestamp, comment:null), ]
48 POSTHOOK: Lineage: alltypesparquet_part PARTITION(ds=2012).ctinyint SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:ctinyint, type:tinyint, comment:null), ]
49 PREHOOK: query: explain vectorization select (cdouble+2) c1 from alltypesparquet_part order by c1 limit 10
50 PREHOOK: type: QUERY
51 POSTHOOK: query: explain vectorization select (cdouble+2) c1 from alltypesparquet_part order by c1 limit 10
52 POSTHOOK: type: QUERY
53 PLAN VECTORIZATION:
54   enabled: true
55   enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
56
57 STAGE DEPENDENCIES:
58   Stage-1 is a root stage
59   Stage-0 depends on stages: Stage-1
60
61 STAGE PLANS:
62   Stage: Stage-1
63     Spark
64       Edges:
65         Reducer 2 <- Map 1 (SORT, 1)
66 #### A masked pattern was here ####
67       Vertices:
68         Map 1 
69             Map Operator Tree:
70                 TableScan
71                   alias: alltypesparquet_part
72                   Statistics: Num rows: 200 Data size: 2400 Basic stats: COMPLETE Column stats: NONE
73                   Select Operator
74                     expressions: (cdouble + 2.0D) (type: double)
75                     outputColumnNames: _col0
76                     Statistics: Num rows: 200 Data size: 2400 Basic stats: COMPLETE Column stats: NONE
77                     Reduce Output Operator
78                       key expressions: _col0 (type: double)
79                       sort order: +
80                       Statistics: Num rows: 200 Data size: 2400 Basic stats: COMPLETE Column stats: NONE
81                       TopN Hash Memory Usage: 0.1
82             Execution mode: vectorized
83             Map Vectorization:
84                 enabled: true
85                 enabledConditionsMet: hive.vectorized.use.vectorized.input.format IS true
86                 inputFormatFeatureSupport: []
87                 featureSupportInUse: []
88                 inputFileFormats: org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat
89                 allNative: true
90                 usesVectorUDFAdaptor: false
91                 vectorized: true
92         Reducer 2 
93             Execution mode: vectorized
94             Reduce Vectorization:
95                 enabled: true
96                 enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine spark IN [tez, spark] IS true
97                 allNative: false
98                 usesVectorUDFAdaptor: false
99                 vectorized: true
100             Reduce Operator Tree:
101               Select Operator
102                 expressions: KEY.reducesinkkey0 (type: double)
103                 outputColumnNames: _col0
104                 Statistics: Num rows: 200 Data size: 2400 Basic stats: COMPLETE Column stats: NONE
105                 Limit
106                   Number of rows: 10
107                   Statistics: Num rows: 10 Data size: 120 Basic stats: COMPLETE Column stats: NONE
108                   File Output Operator
109                     compressed: false
110                     Statistics: Num rows: 10 Data size: 120 Basic stats: COMPLETE Column stats: NONE
111                     table:
112                         input format: org.apache.hadoop.mapred.SequenceFileInputFormat
113                         output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
114                         serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
115
116   Stage: Stage-0
117     Fetch Operator
118       limit: 10
119       Processor Tree:
120         ListSink
121
122 PREHOOK: query: select (cdouble+2) c1 from alltypesparquet_part order by c1 limit 10
123 PREHOOK: type: QUERY
124 PREHOOK: Input: default@alltypesparquet_part
125 PREHOOK: Input: default@alltypesparquet_part@ds=2011
126 PREHOOK: Input: default@alltypesparquet_part@ds=2012
127 #### A masked pattern was here ####
128 POSTHOOK: query: select (cdouble+2) c1 from alltypesparquet_part order by c1 limit 10
129 POSTHOOK: type: QUERY
130 POSTHOOK: Input: default@alltypesparquet_part
131 POSTHOOK: Input: default@alltypesparquet_part@ds=2011
132 POSTHOOK: Input: default@alltypesparquet_part@ds=2012
133 #### A masked pattern was here ####
134 NULL
135 NULL
136 -15863.0
137 -15863.0
138 -14988.0
139 -14988.0
140 -14646.0
141 -14646.0
142 -14236.0
143 -14236.0