PREHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE POSTHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE 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 POSTHOOK: Lineage: dest1.c1 SIMPLE [] ABSTRACT SYNTAX TREE: (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME dest1))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION round 1.0)) (TOK_SELEXPR (TOK_FUNCTION round 1.5)) (TOK_SELEXPR (TOK_FUNCTION round (- 1.5))) (TOK_SELEXPR (TOK_FUNCTION floor 1.0)) (TOK_SELEXPR (TOK_FUNCTION floor 1.5)) (TOK_SELEXPR (TOK_FUNCTION floor (- 1.5))) (TOK_SELEXPR (TOK_FUNCTION sqrt 1.0)) (TOK_SELEXPR (TOK_FUNCTION sqrt (- 1.0))) (TOK_SELEXPR (TOK_FUNCTION sqrt 0.0)) (TOK_SELEXPR (TOK_FUNCTION ceil 1.0)) (TOK_SELEXPR (TOK_FUNCTION ceil 1.5)) (TOK_SELEXPR (TOK_FUNCTION ceil (- 1.5))) (TOK_SELEXPR (TOK_FUNCTION ceiling 1.0)) (TOK_SELEXPR (TOK_FUNCTION rand 3)) (TOK_SELEXPR (+ 3)) (TOK_SELEXPR (- 3)) (TOK_SELEXPR (+ 1 (+ 2))) (TOK_SELEXPR (+ 1 (- 2))) (TOK_SELEXPR (~ 1)) (TOK_SELEXPR (~ (TOK_FUNCTION TOK_TINYINT 1))) (TOK_SELEXPR (~ (TOK_FUNCTION TOK_SMALLINT 1))) (TOK_SELEXPR (~ (TOK_FUNCTION TOK_BIGINT 1))) (TOK_SELEXPR (& (TOK_FUNCTION TOK_TINYINT 1) (TOK_FUNCTION TOK_TINYINT 2))) (TOK_SELEXPR (& (TOK_FUNCTION TOK_SMALLINT 1) (TOK_FUNCTION TOK_SMALLINT 2))) (TOK_SELEXPR (& 1 2)) (TOK_SELEXPR (& (TOK_FUNCTION TOK_BIGINT 1) (TOK_FUNCTION TOK_BIGINT 2))) (TOK_SELEXPR (| (TOK_FUNCTION TOK_TINYINT 1) (TOK_FUNCTION TOK_TINYINT 2))) (TOK_SELEXPR (| (TOK_FUNCTION TOK_SMALLINT 1) (TOK_FUNCTION TOK_SMALLINT 2))) (TOK_SELEXPR (| 1 2)) (TOK_SELEXPR (| (TOK_FUNCTION TOK_BIGINT 1) (TOK_FUNCTION TOK_BIGINT 2))) (TOK_SELEXPR (^ (TOK_FUNCTION TOK_TINYINT 1) (TOK_FUNCTION TOK_TINYINT 3))) (TOK_SELEXPR (^ (TOK_FUNCTION TOK_SMALLINT 1) (TOK_FUNCTION TOK_SMALLINT 3))) (TOK_SELEXPR (^ 1 3)) (TOK_SELEXPR (^ (TOK_FUNCTION TOK_BIGINT 1) (TOK_FUNCTION TOK_BIGINT 3)))))) STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 is a root stage STAGE PLANS: Stage: Stage-1 Map Reduce Alias -> Map Operator Tree: dest1 TableScan alias: dest1 Select Operator expressions: expr: round(1.0) type: double expr: round(1.5) type: double expr: round((- 1.5)) type: double expr: floor(1.0) type: bigint expr: floor(1.5) type: bigint expr: floor((- 1.5)) type: bigint expr: sqrt(1.0) type: double expr: sqrt((- 1.0)) type: double expr: sqrt(0.0) type: double expr: ceil(1.0) type: bigint expr: ceil(1.5) type: bigint expr: ceil((- 1.5)) type: bigint expr: ceiling(1.0) type: bigint expr: rand(3) type: double expr: 3 type: int expr: (- 3) type: int expr: (1 + 2) type: int expr: (1 + (- 2)) type: int expr: (~ 1) type: int expr: (~ UDFToByte(1)) type: tinyint expr: (~ UDFToShort(1)) type: smallint expr: (~ UDFToLong(1)) type: bigint expr: (UDFToByte(1) & UDFToByte(2)) type: tinyint expr: (UDFToShort(1) & UDFToShort(2)) type: smallint expr: (1 & 2) type: int expr: (UDFToLong(1) & UDFToLong(2)) type: bigint expr: (UDFToByte(1) | UDFToByte(2)) type: tinyint expr: (UDFToShort(1) | UDFToShort(2)) type: smallint expr: (1 | 2) type: int expr: (UDFToLong(1) | UDFToLong(2)) type: bigint expr: (UDFToByte(1) ^ UDFToByte(3)) type: tinyint expr: (UDFToShort(1) ^ UDFToShort(3)) type: smallint expr: (1 ^ 3) type: int expr: (UDFToLong(1) ^ UDFToLong(3)) 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 File Output Operator compressed: false GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Stage: Stage-0 Fetch Operator limit: -1 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 #### POSTHOOK: Lineage: dest1.c1 SIMPLE [] 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