PREHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@dest1 POSTHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@dest1 PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT ' abc ' WHERE src.key = 86 PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@dest1 POSTHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT ' abc ' WHERE src.key = 86 POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: default@dest1 POSTHOOK: Lineage: dest1.c1 SIMPLE [] PREHOOK: query: EXPLAIN SELECT round(1.0), round(1.5), round(-1.5), floor(1.0), floor(1.5), floor(-1.5), sqrt(1.0), sqrt(-1.0), sqrt(0.0), ceil(1.0), ceil(1.5), ceil(-1.5), ceiling(1.0), rand(3), +3, -3, 1++2, 1+-2, ~1, ~CAST(1 AS TINYINT), ~CAST(1 AS SMALLINT), ~CAST(1 AS BIGINT), CAST(1 AS TINYINT) & CAST(2 AS TINYINT), CAST(1 AS SMALLINT) & CAST(2 AS SMALLINT), 1 & 2, CAST(1 AS BIGINT) & CAST(2 AS BIGINT), CAST(1 AS TINYINT) | CAST(2 AS TINYINT), CAST(1 AS SMALLINT) | CAST(2 AS SMALLINT), 1 | 2, CAST(1 AS BIGINT) | CAST(2 AS BIGINT), CAST(1 AS TINYINT) ^ CAST(3 AS TINYINT), CAST(1 AS SMALLINT) ^ CAST(3 AS SMALLINT), 1 ^ 3, CAST(1 AS BIGINT) ^ CAST(3 AS BIGINT) FROM dest1 PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT round(1.0), round(1.5), round(-1.5), floor(1.0), floor(1.5), floor(-1.5), sqrt(1.0), sqrt(-1.0), sqrt(0.0), ceil(1.0), ceil(1.5), ceil(-1.5), ceiling(1.0), rand(3), +3, -3, 1++2, 1+-2, ~1, ~CAST(1 AS TINYINT), ~CAST(1 AS SMALLINT), ~CAST(1 AS BIGINT), CAST(1 AS TINYINT) & CAST(2 AS TINYINT), CAST(1 AS SMALLINT) & CAST(2 AS SMALLINT), 1 & 2, CAST(1 AS BIGINT) & CAST(2 AS BIGINT), CAST(1 AS TINYINT) | CAST(2 AS TINYINT), CAST(1 AS SMALLINT) | CAST(2 AS SMALLINT), 1 | 2, CAST(1 AS BIGINT) | CAST(2 AS BIGINT), CAST(1 AS TINYINT) ^ CAST(3 AS TINYINT), CAST(1 AS SMALLINT) ^ CAST(3 AS SMALLINT), 1 ^ 3, CAST(1 AS BIGINT) ^ CAST(3 AS BIGINT) FROM dest1 POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 STAGE PLANS: Stage: Stage-1 Map Reduce Map Operator Tree: TableScan alias: dest1 Statistics: Num rows: 1 Data size: 7 Basic stats: COMPLETE Column stats: COMPLETE Select Operator expressions: 1.0 (type: double), 2.0 (type: double), -2.0 (type: double), 1 (type: bigint), 1 (type: bigint), -2 (type: bigint), 1.0 (type: double), null (type: void), 0.0 (type: double), 1 (type: bigint), 2 (type: bigint), -1 (type: bigint), 1 (type: bigint), rand(3) (type: double), 3 (type: int), -3 (type: int), 3 (type: int), -1 (type: int), -2 (type: int), -2 (type: tinyint), -2 (type: smallint), -2 (type: bigint), 0 (type: tinyint), 0 (type: smallint), 0 (type: int), 0 (type: bigint), 3 (type: tinyint), 3 (type: smallint), 3 (type: int), 3 (type: bigint), 2 (type: tinyint), 2 (type: smallint), 2 (type: int), 2 (type: bigint) 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, _col24, _col25, _col26, _col27, _col28, _col29, _col30, _col31, _col32, _col33 Statistics: Num rows: 1 Data size: 200 Basic stats: COMPLETE Column stats: COMPLETE File Output Operator compressed: false Statistics: Num rows: 1 Data size: 200 Basic stats: COMPLETE Column stats: COMPLETE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator limit: -1 Processor Tree: ListSink PREHOOK: query: SELECT round(1.0), round(1.5), round(-1.5), floor(1.0), floor(1.5), floor(-1.5), sqrt(1.0), sqrt(-1.0), sqrt(0.0), ceil(1.0), ceil(1.5), ceil(-1.5), ceiling(1.0), rand(3), +3, -3, 1++2, 1+-2, ~1, ~CAST(1 AS TINYINT), ~CAST(1 AS SMALLINT), ~CAST(1 AS BIGINT), CAST(1 AS TINYINT) & CAST(2 AS TINYINT), CAST(1 AS SMALLINT) & CAST(2 AS SMALLINT), 1 & 2, CAST(1 AS BIGINT) & CAST(2 AS BIGINT), CAST(1 AS TINYINT) | CAST(2 AS TINYINT), CAST(1 AS SMALLINT) | CAST(2 AS SMALLINT), 1 | 2, CAST(1 AS BIGINT) | CAST(2 AS BIGINT), CAST(1 AS TINYINT) ^ CAST(3 AS TINYINT), CAST(1 AS SMALLINT) ^ CAST(3 AS SMALLINT), 1 ^ 3, CAST(1 AS BIGINT) ^ CAST(3 AS BIGINT) FROM dest1 PREHOOK: type: QUERY PREHOOK: Input: default@dest1 #### A masked pattern was here #### POSTHOOK: query: SELECT round(1.0), round(1.5), round(-1.5), floor(1.0), floor(1.5), floor(-1.5), sqrt(1.0), sqrt(-1.0), sqrt(0.0), ceil(1.0), ceil(1.5), ceil(-1.5), ceiling(1.0), rand(3), +3, -3, 1++2, 1+-2, ~1, ~CAST(1 AS TINYINT), ~CAST(1 AS SMALLINT), ~CAST(1 AS BIGINT), CAST(1 AS TINYINT) & CAST(2 AS TINYINT), CAST(1 AS SMALLINT) & CAST(2 AS SMALLINT), 1 & 2, CAST(1 AS BIGINT) & CAST(2 AS BIGINT), CAST(1 AS TINYINT) | CAST(2 AS TINYINT), CAST(1 AS SMALLINT) | CAST(2 AS SMALLINT), 1 | 2, CAST(1 AS BIGINT) | CAST(2 AS BIGINT), CAST(1 AS TINYINT) ^ CAST(3 AS TINYINT), CAST(1 AS SMALLINT) ^ CAST(3 AS SMALLINT), 1 ^ 3, CAST(1 AS BIGINT) ^ CAST(3 AS BIGINT) FROM dest1 POSTHOOK: type: QUERY POSTHOOK: Input: default@dest1 #### A masked pattern was here #### 1.0 2.0 -2.0 1 1 -2 1.0 NULL 0.0 1 2 -1 1 0.731057369148862 3 -3 3 -1 -2 -2 -2 -2 0 0 0 0 3 3 3 3 2 2 2 2