HIVE-18797 : ExprConstNodeDesc's getExprString should put appropriate qualifier with...
[hive.git] / ql / src / test / results / clientpositive / llap / vector_string_decimal.q.out
1 PREHOOK: query: drop table orc_decimal
2 PREHOOK: type: DROPTABLE
3 POSTHOOK: query: drop table orc_decimal
4 POSTHOOK: type: DROPTABLE
5 PREHOOK: query: drop table staging
6 PREHOOK: type: DROPTABLE
7 POSTHOOK: query: drop table staging
8 POSTHOOK: type: DROPTABLE
9 PREHOOK: query: create table orc_decimal (id decimal(18,0)) stored as orc
10 PREHOOK: type: CREATETABLE
11 PREHOOK: Output: database:default
12 PREHOOK: Output: default@orc_decimal
13 POSTHOOK: query: create table orc_decimal (id decimal(18,0)) stored as orc
14 POSTHOOK: type: CREATETABLE
15 POSTHOOK: Output: database:default
16 POSTHOOK: Output: default@orc_decimal
17 PREHOOK: query: create table staging (id decimal(18,0))
18 PREHOOK: type: CREATETABLE
19 PREHOOK: Output: database:default
20 PREHOOK: Output: default@staging
21 POSTHOOK: query: create table staging (id decimal(18,0))
22 POSTHOOK: type: CREATETABLE
23 POSTHOOK: Output: database:default
24 POSTHOOK: Output: default@staging
25 PREHOOK: query: insert into staging values (34324.0), (100000000.0), (200000000.0), (300000000.0)
26 PREHOOK: type: QUERY
27 PREHOOK: Input: _dummy_database@_dummy_table
28 PREHOOK: Output: default@staging
29 POSTHOOK: query: insert into staging values (34324.0), (100000000.0), (200000000.0), (300000000.0)
30 POSTHOOK: type: QUERY
31 POSTHOOK: Input: _dummy_database@_dummy_table
32 POSTHOOK: Output: default@staging
33 POSTHOOK: Lineage: staging.id SCRIPT []
34 PREHOOK: query: insert overwrite table orc_decimal select id from staging
35 PREHOOK: type: QUERY
36 PREHOOK: Input: default@staging
37 PREHOOK: Output: default@orc_decimal
38 POSTHOOK: query: insert overwrite table orc_decimal select id from staging
39 POSTHOOK: type: QUERY
40 POSTHOOK: Input: default@staging
41 POSTHOOK: Output: default@orc_decimal
42 POSTHOOK: Lineage: orc_decimal.id SIMPLE [(staging)staging.FieldSchema(name:id, type:decimal(18,0), comment:null), ]
43 PREHOOK: query: explain vectorization expression
44 select * from orc_decimal where id in ('100000000', '200000000')
45 PREHOOK: type: QUERY
46 POSTHOOK: query: explain vectorization expression
47 select * from orc_decimal where id in ('100000000', '200000000')
48 POSTHOOK: type: QUERY
49 PLAN VECTORIZATION:
50   enabled: true
51   enabledConditionsMet: [hive.vectorized.execution.enabled IS true]
52
53 STAGE DEPENDENCIES:
54   Stage-1 is a root stage
55   Stage-0 depends on stages: Stage-1
56
57 STAGE PLANS:
58   Stage: Stage-1
59     Tez
60 #### A masked pattern was here ####
61       Vertices:
62         Map 1 
63             Map Operator Tree:
64                 TableScan
65                   alias: orc_decimal
66                   Statistics: Num rows: 4 Data size: 448 Basic stats: COMPLETE Column stats: COMPLETE
67                   TableScan Vectorization:
68                       native: true
69                   Filter Operator
70                     Filter Vectorization:
71                         className: VectorFilterOperator
72                         native: true
73                         predicateExpression: FilterDoubleColumnInList(col 2:double, values [1.0E8, 2.0E8])(children: CastDecimalToDouble(col 0:decimal(18,0)) -> 2:double)
74                     predicate: (UDFToDouble(id)) IN (1.0E8D, 2.0E8D) (type: boolean)
75                     Statistics: Num rows: 2 Data size: 224 Basic stats: COMPLETE Column stats: COMPLETE
76                     Select Operator
77                       expressions: id (type: decimal(18,0))
78                       outputColumnNames: _col0
79                       Select Vectorization:
80                           className: VectorSelectOperator
81                           native: true
82                           projectedOutputColumnNums: [0]
83                       Statistics: Num rows: 2 Data size: 224 Basic stats: COMPLETE Column stats: COMPLETE
84                       File Output Operator
85                         compressed: false
86                         File Sink Vectorization:
87                             className: VectorFileSinkOperator
88                             native: false
89                         Statistics: Num rows: 2 Data size: 224 Basic stats: COMPLETE Column stats: COMPLETE
90                         table:
91                             input format: org.apache.hadoop.mapred.SequenceFileInputFormat
92                             output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
93                             serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
94             Execution mode: vectorized, llap
95             LLAP IO: all inputs
96             Map Vectorization:
97                 enabled: true
98                 enabledConditionsMet: hive.vectorized.use.vectorized.input.format IS true
99                 inputFormatFeatureSupport: []
100                 featureSupportInUse: []
101                 inputFileFormats: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
102                 allNative: false
103                 usesVectorUDFAdaptor: false
104                 vectorized: true
105
106   Stage: Stage-0
107     Fetch Operator
108       limit: -1
109       Processor Tree:
110         ListSink
111
112 PREHOOK: query: select * from orc_decimal where id in ('100000000', '200000000')
113 PREHOOK: type: QUERY
114 PREHOOK: Input: default@orc_decimal
115 #### A masked pattern was here ####
116 POSTHOOK: query: select * from orc_decimal where id in ('100000000', '200000000')
117 POSTHOOK: type: QUERY
118 POSTHOOK: Input: default@orc_decimal
119 #### A masked pattern was here ####
120 100000000
121 200000000
122 PREHOOK: query: drop table orc_decimal
123 PREHOOK: type: DROPTABLE
124 PREHOOK: Input: default@orc_decimal
125 PREHOOK: Output: default@orc_decimal
126 POSTHOOK: query: drop table orc_decimal
127 POSTHOOK: type: DROPTABLE
128 POSTHOOK: Input: default@orc_decimal
129 POSTHOOK: Output: default@orc_decimal
130 PREHOOK: query: drop table staging
131 PREHOOK: type: DROPTABLE
132 PREHOOK: Input: default@staging
133 PREHOOK: Output: default@staging
134 POSTHOOK: query: drop table staging
135 POSTHOOK: type: DROPTABLE
136 POSTHOOK: Input: default@staging
137 POSTHOOK: Output: default@staging