PREHOOK: query: DROP TABLE infertypes PREHOOK: type: DROPTABLE POSTHOOK: query: DROP TABLE infertypes POSTHOOK: type: DROPTABLE PREHOOK: query: CREATE TABLE infertypes(ti TINYINT, si SMALLINT, i INT, bi BIGINT, fl FLOAT, db DOUBLE, str STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@infertypes POSTHOOK: query: CREATE TABLE infertypes(ti TINYINT, si SMALLINT, i INT, bi BIGINT, fl FLOAT, db DOUBLE, str STRING) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@infertypes PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/infer_const_type.txt' OVERWRITE INTO TABLE infertypes PREHOOK: type: LOAD #### A masked pattern was here #### PREHOOK: Output: default@infertypes POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/infer_const_type.txt' OVERWRITE INTO TABLE infertypes POSTHOOK: type: LOAD #### A masked pattern was here #### POSTHOOK: Output: default@infertypes PREHOOK: query: SELECT * FROM infertypes PREHOOK: type: QUERY PREHOOK: Input: default@infertypes #### A masked pattern was here #### POSTHOOK: query: SELECT * FROM infertypes POSTHOOK: type: QUERY POSTHOOK: Input: default@infertypes #### A masked pattern was here #### 127 32767 12345 -12345 906.0 -307.0 1234 126 32767 12345 -12345 906.0 -307.0 1234 126 32767 12345 -12345 906.0 -307.0 1.57 PREHOOK: query: EXPLAIN SELECT * FROM infertypes WHERE ti = '127' AND si = 32767 AND i = '12345' AND bi = '-12345' AND fl = '0906' AND db = '-307' AND str = 1234 PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT * FROM infertypes WHERE ti = '127' AND si = 32767 AND i = '12345' AND bi = '-12345' AND fl = '0906' AND db = '-307' AND str = 1234 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: infertypes Statistics: Num rows: 3 Data size: 117 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (((((((ti = 127) and (si = 32767)) and (i = 12345)) and (bi = -12345)) and (fl = 906.0)) and (db = -307.0)) and (UDFToDouble(str) = 1234.0)) (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator expressions: 127 (type: tinyint), 32767 (type: smallint), 12345 (type: int), -12345 (type: bigint), 906.0 (type: float), -307.0 (type: double), '1234' (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 0 Data size: 0 Basic stats: NONE 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 Stage: Stage-0 Fetch Operator limit: -1 Processor Tree: ListSink PREHOOK: query: SELECT * FROM infertypes WHERE ti = '127' AND si = 32767 AND i = '12345' AND bi = '-12345' AND fl = '0906' AND db = '-307' AND str = 1234 PREHOOK: type: QUERY PREHOOK: Input: default@infertypes #### A masked pattern was here #### POSTHOOK: query: SELECT * FROM infertypes WHERE ti = '127' AND si = 32767 AND i = '12345' AND bi = '-12345' AND fl = '0906' AND db = '-307' AND str = 1234 POSTHOOK: type: QUERY POSTHOOK: Input: default@infertypes #### A masked pattern was here #### 127 32767 12345 -12345 906.0 -307.0 1234 PREHOOK: query: -- all should return false as all numbers exceeed the largest number -- which could be represented by the corresponding type -- and string_col = long_const should return false EXPLAIN SELECT * FROM infertypes WHERE ti = '128' OR si = 32768 OR i = '2147483648' OR bi = '9223372036854775808' OR fl = 'float' OR db = 'double' PREHOOK: type: QUERY POSTHOOK: query: -- all should return false as all numbers exceeed the largest number -- which could be represented by the corresponding type -- and string_col = long_const should return false EXPLAIN SELECT * FROM infertypes WHERE ti = '128' OR si = 32768 OR i = '2147483648' OR bi = '9223372036854775808' OR fl = 'float' OR db = 'double' 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: infertypes Statistics: Num rows: 0 Data size: 117 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: false (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator expressions: ti (type: tinyint), si (type: smallint), i (type: int), bi (type: bigint), fl (type: float), db (type: double), str (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 0 Data size: 0 Basic stats: NONE 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 Stage: Stage-0 Fetch Operator limit: -1 Processor Tree: ListSink PREHOOK: query: SELECT * FROM infertypes WHERE ti = '128' OR si = 32768 OR i = '2147483648' OR bi = '9223372036854775808' OR fl = 'float' OR db = 'double' PREHOOK: type: QUERY PREHOOK: Input: default@infertypes #### A masked pattern was here #### POSTHOOK: query: SELECT * FROM infertypes WHERE ti = '128' OR si = 32768 OR i = '2147483648' OR bi = '9223372036854775808' OR fl = 'float' OR db = 'double' POSTHOOK: type: QUERY POSTHOOK: Input: default@infertypes #### A masked pattern was here #### PREHOOK: query: -- for the query like: int_col = double, should return false EXPLAIN SELECT * FROM infertypes WHERE ti = '127.0' OR si = 327.0 OR i = '-100.0' PREHOOK: type: QUERY POSTHOOK: query: -- for the query like: int_col = double, should return false EXPLAIN SELECT * FROM infertypes WHERE ti = '127.0' OR si = 327.0 OR i = '-100.0' 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: infertypes Statistics: Num rows: 0 Data size: 117 Basic stats: PARTIAL Column stats: NONE Filter Operator predicate: false (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator expressions: ti (type: tinyint), si (type: smallint), i (type: int), bi (type: bigint), fl (type: float), db (type: double), str (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 0 Data size: 0 Basic stats: NONE 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 Stage: Stage-0 Fetch Operator limit: -1 Processor Tree: ListSink PREHOOK: query: SELECT * FROM infertypes WHERE ti = '127.0' OR si = 327.0 OR i = '-100.0' PREHOOK: type: QUERY PREHOOK: Input: default@infertypes #### A masked pattern was here #### POSTHOOK: query: SELECT * FROM infertypes WHERE ti = '127.0' OR si = 327.0 OR i = '-100.0' POSTHOOK: type: QUERY POSTHOOK: Input: default@infertypes #### A masked pattern was here #### PREHOOK: query: EXPLAIN SELECT * FROM infertypes WHERE ti < '127.0' AND i > '100.0' AND str = 1.57 PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT * FROM infertypes WHERE ti < '127.0' AND i > '100.0' AND str = 1.57 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: infertypes Statistics: Num rows: 3 Data size: 117 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (((UDFToDouble(ti) < 127.0) and (UDFToDouble(i) > 100.0)) and (UDFToDouble(str) = 1.57)) (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator expressions: ti (type: tinyint), si (type: smallint), i (type: int), bi (type: bigint), fl (type: float), db (type: double), '1.57' (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 0 Data size: 0 Basic stats: NONE 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 Stage: Stage-0 Fetch Operator limit: -1 Processor Tree: ListSink PREHOOK: query: SELECT * FROM infertypes WHERE ti < '127.0' AND i > '100.0' AND str = 1.57 PREHOOK: type: QUERY PREHOOK: Input: default@infertypes #### A masked pattern was here #### POSTHOOK: query: SELECT * FROM infertypes WHERE ti < '127.0' AND i > '100.0' AND str = 1.57 POSTHOOK: type: QUERY POSTHOOK: Input: default@infertypes #### A masked pattern was here #### 126 32767 12345 -12345 906.0 -307.0 1.57 PREHOOK: query: DROP TABLE infertypes PREHOOK: type: DROPTABLE PREHOOK: Input: default@infertypes PREHOOK: Output: default@infertypes POSTHOOK: query: DROP TABLE infertypes POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@infertypes POSTHOOK: Output: default@infertypes