| PREHOOK: query: create table sc as select * |
| from (select '2011-01-11', '2011-01-11+14:18:26' from src tablesample (1 rows) |
| union all |
| select '2011-01-11', '2011-01-11+15:18:26' from src tablesample (1 rows) |
| union all |
| select '2011-01-11', '2011-01-11+16:18:26' from src tablesample (1 rows) ) s |
| PREHOOK: type: CREATETABLE_AS_SELECT |
| PREHOOK: Input: default@src |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@sc |
| POSTHOOK: query: create table sc as select * |
| from (select '2011-01-11', '2011-01-11+14:18:26' from src tablesample (1 rows) |
| union all |
| select '2011-01-11', '2011-01-11+15:18:26' from src tablesample (1 rows) |
| union all |
| select '2011-01-11', '2011-01-11+16:18:26' from src tablesample (1 rows) ) s |
| POSTHOOK: type: CREATETABLE_AS_SELECT |
| POSTHOOK: Input: default@src |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@sc |
| POSTHOOK: Lineage: sc._c0 EXPRESSION [] |
| POSTHOOK: Lineage: sc._c1 EXPRESSION [] |
| PREHOOK: query: create table sc_part (key string) partitioned by (ts string) stored as rcfile |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@sc_part |
| POSTHOOK: query: create table sc_part (key string) partitioned by (ts string) stored as rcfile |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@sc_part |
| PREHOOK: query: insert overwrite table sc_part partition(ts) select * from sc |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@sc |
| PREHOOK: Output: default@sc_part |
| POSTHOOK: query: insert overwrite table sc_part partition(ts) select * from sc |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@sc |
| POSTHOOK: Output: default@sc_part |
| POSTHOOK: Output: default@sc_part@ts=2011-01-11+14%3A18%3A26 |
| POSTHOOK: Output: default@sc_part@ts=2011-01-11+15%3A18%3A26 |
| POSTHOOK: Output: default@sc_part@ts=2011-01-11+16%3A18%3A26 |
| POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+14:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ] |
| POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+15:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ] |
| POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+16:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ] |
| PREHOOK: query: show partitions sc_part |
| PREHOOK: type: SHOWPARTITIONS |
| PREHOOK: Input: default@sc_part |
| POSTHOOK: query: show partitions sc_part |
| POSTHOOK: type: SHOWPARTITIONS |
| POSTHOOK: Input: default@sc_part |
| ts=2011-01-11+14%3A18%3A26 |
| ts=2011-01-11+15%3A18%3A26 |
| ts=2011-01-11+16%3A18%3A26 |
| PREHOOK: query: select count(*) from sc_part where ts is not null |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@sc_part |
| #### A masked pattern was here #### |
| POSTHOOK: query: select count(*) from sc_part where ts is not null |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@sc_part |
| #### A masked pattern was here #### |
| 3 |
| PREHOOK: query: insert overwrite table sc_part partition(ts) select * from sc |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@sc |
| PREHOOK: Output: default@sc_part |
| POSTHOOK: query: insert overwrite table sc_part partition(ts) select * from sc |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@sc |
| POSTHOOK: Output: default@sc_part |
| POSTHOOK: Output: default@sc_part@ts=2011-01-11+14%3A18%3A26 |
| POSTHOOK: Output: default@sc_part@ts=2011-01-11+15%3A18%3A26 |
| POSTHOOK: Output: default@sc_part@ts=2011-01-11+16%3A18%3A26 |
| POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+14:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ] |
| POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+15:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ] |
| POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+16:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ] |
| PREHOOK: query: show partitions sc_part |
| PREHOOK: type: SHOWPARTITIONS |
| PREHOOK: Input: default@sc_part |
| POSTHOOK: query: show partitions sc_part |
| POSTHOOK: type: SHOWPARTITIONS |
| POSTHOOK: Input: default@sc_part |
| ts=2011-01-11+14%3A18%3A26 |
| ts=2011-01-11+15%3A18%3A26 |
| ts=2011-01-11+16%3A18%3A26 |
| PREHOOK: query: select count(*) from sc_part where ts is not null |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@sc_part |
| #### A masked pattern was here #### |
| POSTHOOK: query: select count(*) from sc_part where ts is not null |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@sc_part |
| #### A masked pattern was here #### |
| 3 |