| PREHOOK: query: select * from (select 'k2' as key, '1 ' as value from src limit 2)b |
| union all |
| select * from (select 'k3' as key, '' as value from src limit 2)b |
| union all |
| select * from (select 'k4' as key, ' ' as value from src limit 2)c |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| #### A masked pattern was here #### |
| POSTHOOK: query: select * from (select 'k2' as key, '1 ' as value from src limit 2)b |
| union all |
| select * from (select 'k3' as key, '' as value from src limit 2)b |
| union all |
| select * from (select 'k4' as key, ' ' as value from src limit 2)c |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| #### A masked pattern was here #### |
| k2 1 |
| k2 1 |
| k3 |
| k3 |
| k4 |
| k4 |
| PREHOOK: query: drop table if exists union_all_bug_test_1_n0 |
| PREHOOK: type: DROPTABLE |
| POSTHOOK: query: drop table if exists union_all_bug_test_1_n0 |
| POSTHOOK: type: DROPTABLE |
| PREHOOK: query: drop table if exists union_all_bug_test_2_n0 |
| PREHOOK: type: DROPTABLE |
| POSTHOOK: query: drop table if exists union_all_bug_test_2_n0 |
| POSTHOOK: type: DROPTABLE |
| PREHOOK: query: create table if not exists union_all_bug_test_1_n0 |
| ( |
| f1 int, |
| f2 int |
| ) |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@union_all_bug_test_1_n0 |
| POSTHOOK: query: create table if not exists union_all_bug_test_1_n0 |
| ( |
| f1 int, |
| f2 int |
| ) |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@union_all_bug_test_1_n0 |
| PREHOOK: query: create table if not exists union_all_bug_test_2_n0 |
| ( |
| f1 int |
| ) |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@union_all_bug_test_2_n0 |
| POSTHOOK: query: create table if not exists union_all_bug_test_2_n0 |
| ( |
| f1 int |
| ) |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@union_all_bug_test_2_n0 |
| PREHOOK: query: insert into table union_all_bug_test_1_n0 values (1,1) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: _dummy_database@_dummy_table |
| PREHOOK: Output: default@union_all_bug_test_1_n0 |
| POSTHOOK: query: insert into table union_all_bug_test_1_n0 values (1,1) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: _dummy_database@_dummy_table |
| POSTHOOK: Output: default@union_all_bug_test_1_n0 |
| POSTHOOK: Lineage: union_all_bug_test_1_n0.f1 SCRIPT [] |
| POSTHOOK: Lineage: union_all_bug_test_1_n0.f2 SCRIPT [] |
| PREHOOK: query: insert into table union_all_bug_test_2_n0 values (1) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: _dummy_database@_dummy_table |
| PREHOOK: Output: default@union_all_bug_test_2_n0 |
| POSTHOOK: query: insert into table union_all_bug_test_2_n0 values (1) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: _dummy_database@_dummy_table |
| POSTHOOK: Output: default@union_all_bug_test_2_n0 |
| POSTHOOK: Lineage: union_all_bug_test_2_n0.f1 SCRIPT [] |
| PREHOOK: query: insert into table union_all_bug_test_1_n0 values (0,0) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: _dummy_database@_dummy_table |
| PREHOOK: Output: default@union_all_bug_test_1_n0 |
| POSTHOOK: query: insert into table union_all_bug_test_1_n0 values (0,0) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: _dummy_database@_dummy_table |
| POSTHOOK: Output: default@union_all_bug_test_1_n0 |
| POSTHOOK: Lineage: union_all_bug_test_1_n0.f1 SCRIPT [] |
| POSTHOOK: Lineage: union_all_bug_test_1_n0.f2 SCRIPT [] |
| PREHOOK: query: insert into table union_all_bug_test_2_n0 values (0) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: _dummy_database@_dummy_table |
| PREHOOK: Output: default@union_all_bug_test_2_n0 |
| POSTHOOK: query: insert into table union_all_bug_test_2_n0 values (0) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: _dummy_database@_dummy_table |
| POSTHOOK: Output: default@union_all_bug_test_2_n0 |
| POSTHOOK: Lineage: union_all_bug_test_2_n0.f1 SCRIPT [] |
| PREHOOK: query: SELECT f1 |
| FROM ( |
| |
| SELECT |
| f1 |
| , if('helloworld' like '%hello%' ,f1,f2) as filter |
| FROM union_all_bug_test_1_n0 |
| |
| union all |
| |
| select |
| f1 |
| , 0 as filter |
| from union_all_bug_test_2_n0 |
| ) A |
| WHERE (filter = 1 and f1 = 1) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@union_all_bug_test_1_n0 |
| PREHOOK: Input: default@union_all_bug_test_2_n0 |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT f1 |
| FROM ( |
| |
| SELECT |
| f1 |
| , if('helloworld' like '%hello%' ,f1,f2) as filter |
| FROM union_all_bug_test_1_n0 |
| |
| union all |
| |
| select |
| f1 |
| , 0 as filter |
| from union_all_bug_test_2_n0 |
| ) A |
| WHERE (filter = 1 and f1 = 1) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@union_all_bug_test_1_n0 |
| POSTHOOK: Input: default@union_all_bug_test_2_n0 |
| #### A masked pattern was here #### |
| 1 |
| PREHOOK: query: select percentile(cast(key as bigint), array()) from src where false |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| #### A masked pattern was here #### |
| POSTHOOK: query: select percentile(cast(key as bigint), array()) from src where false |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| #### A masked pattern was here #### |
| NULL |
| PREHOOK: query: select unbase64("0xe23") from src limit 1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| #### A masked pattern was here #### |
| POSTHOOK: query: select unbase64("0xe23") from src limit 1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| #### A masked pattern was here #### |
| �� |
| PREHOOK: query: SELECT key,randum123, h4 |
| FROM (SELECT *, cast(rand() as double) AS randum123, hex(4) AS h4 FROM src WHERE key = 100) a |
| WHERE a.h4 <= 3 limit 1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT key,randum123, h4 |
| FROM (SELECT *, cast(rand() as double) AS randum123, hex(4) AS h4 FROM src WHERE key = 100) a |
| WHERE a.h4 <= 3 limit 1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| #### A masked pattern was here #### |
| PREHOOK: query: select null from src limit 1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| #### A masked pattern was here #### |
| POSTHOOK: query: select null from src limit 1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| #### A masked pattern was here #### |
| NULL |
| PREHOOK: query: explain select cast("1970-12-31 15:59:58.174" as TIMESTAMP) from src |
| PREHOOK: type: QUERY |
| POSTHOOK: query: explain select cast("1970-12-31 15:59:58.174" as TIMESTAMP) from src |
| POSTHOOK: type: QUERY |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| TableScan |
| alias: src |
| Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: TIMESTAMP'1970-12-31 15:59:58.174' (type: timestamp) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 500 Data size: 20000 Basic stats: COMPLETE Column stats: COMPLETE |
| ListSink |
| |
| PREHOOK: query: explain select cast("1970-12-31 15:59:58.174" as DATE) from src |
| PREHOOK: type: QUERY |
| POSTHOOK: query: explain select cast("1970-12-31 15:59:58.174" as DATE) from src |
| POSTHOOK: type: QUERY |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| TableScan |
| alias: src |
| Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: DATE'1970-12-31' (type: date) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 500 Data size: 28000 Basic stats: COMPLETE Column stats: COMPLETE |
| ListSink |
| |
| PREHOOK: query: CREATE TABLE dest1_n127(c1 STRING) STORED AS TEXTFILE |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@dest1_n127 |
| POSTHOOK: query: CREATE TABLE dest1_n127(c1 STRING) STORED AS TEXTFILE |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@dest1_n127 |
| PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest1_n127 SELECT ' abc ' WHERE src.key = 86 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| PREHOOK: Output: default@dest1_n127 |
| POSTHOOK: query: FROM src INSERT OVERWRITE TABLE dest1_n127 SELECT ' abc ' WHERE src.key = 86 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| POSTHOOK: Output: default@dest1_n127 |
| POSTHOOK: Lineage: dest1_n127.c1 SIMPLE [] |
| PREHOOK: query: EXPLAIN |
| SELECT ROUND(LN(3.0),12), LN(0.0), LN(-1), ROUND(LOG(3.0),12), LOG(0.0), |
| LOG(-1), ROUND(LOG2(3.0),12), LOG2(0.0), LOG2(-1), |
| ROUND(LOG10(3.0),12), LOG10(0.0), LOG10(-1), ROUND(LOG(2, 3.0),12), |
| LOG(2, 0.0), LOG(2, -1), LOG(0.5, 2), LOG(2, 0.5), ROUND(EXP(2.0),12), |
| POW(2,3), POWER(2,3), POWER(2,-3), POWER(0.5, -3), POWER(4, 0.5), |
| POWER(-1, 0.5), POWER(-1, 2), POWER(CAST (1 AS DECIMAL), CAST (0 AS INT)), |
| POWER(CAST (2 AS DECIMAL), CAST (3 AS INT)), |
| POW(CAST (2 AS DECIMAL), CAST(3 AS INT)) FROM dest1_n127 |
| PREHOOK: type: QUERY |
| POSTHOOK: query: EXPLAIN |
| SELECT ROUND(LN(3.0),12), LN(0.0), LN(-1), ROUND(LOG(3.0),12), LOG(0.0), |
| LOG(-1), ROUND(LOG2(3.0),12), LOG2(0.0), LOG2(-1), |
| ROUND(LOG10(3.0),12), LOG10(0.0), LOG10(-1), ROUND(LOG(2, 3.0),12), |
| LOG(2, 0.0), LOG(2, -1), LOG(0.5, 2), LOG(2, 0.5), ROUND(EXP(2.0),12), |
| POW(2,3), POWER(2,3), POWER(2,-3), POWER(0.5, -3), POWER(4, 0.5), |
| POWER(-1, 0.5), POWER(-1, 2), POWER(CAST (1 AS DECIMAL), CAST (0 AS INT)), |
| POWER(CAST (2 AS DECIMAL), CAST (3 AS INT)), |
| POW(CAST (2 AS DECIMAL), CAST(3 AS INT)) FROM dest1_n127 |
| POSTHOOK: type: QUERY |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| TableScan |
| alias: dest1_n127 |
| Statistics: Num rows: 1 Data size: 7 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: 1.098612288668D (type: double), null (type: double), null (type: double), 1.098612288668D (type: double), null (type: double), null (type: double), 1.584962500721D (type: double), null (type: double), null (type: double), 0.47712125472D (type: double), null (type: double), null (type: double), 1.584962500721D (type: double), null (type: double), null (type: double), null (type: double), -1.0D (type: double), 7.389056098931D (type: double), 8.0D (type: double), 8.0D (type: double), 0.125D (type: double), 8.0D (type: double), 2.0D (type: double), NaND (type: double), 1.0D (type: double), 1.0D (type: double), 8.0D (type: double), 8.0D (type: double) |
| 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 |
| Statistics: Num rows: 1 Data size: 224 Basic stats: COMPLETE Column stats: COMPLETE |
| ListSink |
| |
| PREHOOK: query: SELECT ROUND(LN(3.0),12), LN(0.0), LN(-1), ROUND(LOG(3.0),12), LOG(0.0), |
| LOG(-1), ROUND(LOG2(3.0),12), LOG2(0.0), LOG2(-1), |
| ROUND(LOG10(3.0),12), LOG10(0.0), LOG10(-1), ROUND(LOG(2, 3.0),12), |
| LOG(2, 0.0), LOG(2, -1), LOG(0.5, 2), LOG(2, 0.5), ROUND(EXP(2.0),12), |
| POW(2,3), POWER(2,3), POWER(2,-3), POWER(0.5, -3), POWER(4, 0.5), |
| POWER(-1, 0.5), POWER(-1, 2), POWER(CAST (1 AS DECIMAL), CAST (0 AS INT)), |
| POWER(CAST (2 AS DECIMAL), CAST (3 AS INT)), |
| POW(CAST (2 AS DECIMAL), CAST(3 AS INT)) FROM dest1_n127 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@dest1_n127 |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT ROUND(LN(3.0),12), LN(0.0), LN(-1), ROUND(LOG(3.0),12), LOG(0.0), |
| LOG(-1), ROUND(LOG2(3.0),12), LOG2(0.0), LOG2(-1), |
| ROUND(LOG10(3.0),12), LOG10(0.0), LOG10(-1), ROUND(LOG(2, 3.0),12), |
| LOG(2, 0.0), LOG(2, -1), LOG(0.5, 2), LOG(2, 0.5), ROUND(EXP(2.0),12), |
| POW(2,3), POWER(2,3), POWER(2,-3), POWER(0.5, -3), POWER(4, 0.5), |
| POWER(-1, 0.5), POWER(-1, 2), POWER(CAST (1 AS DECIMAL), CAST (0 AS INT)), |
| POWER(CAST (2 AS DECIMAL), CAST (3 AS INT)), |
| POW(CAST (2 AS DECIMAL), CAST(3 AS INT)) FROM dest1_n127 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@dest1_n127 |
| #### A masked pattern was here #### |
| 1.098612288668 NULL NULL 1.098612288668 NULL NULL 1.584962500721 NULL NULL 0.47712125472 NULL NULL 1.584962500721 NULL NULL NULL -1.0 7.389056098931 8.0 8.0 0.125 8.0 2.0 NaN 1.0 1.0 8.0 8.0 |