| PREHOOK: query: create table acid_dap(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true') |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@acid_dap |
| POSTHOOK: query: create table acid_dap(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true') |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@acid_dap |
| PREHOOK: query: insert into table acid_dap partition (ds='today') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint < 0 order by cint limit 10 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@alltypesorc |
| PREHOOK: Output: default@acid_dap@ds=today |
| POSTHOOK: query: insert into table acid_dap partition (ds='today') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint < 0 order by cint limit 10 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@alltypesorc |
| POSTHOOK: Output: default@acid_dap@ds=today |
| POSTHOOK: Lineage: acid_dap PARTITION(ds=today).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ] |
| POSTHOOK: Lineage: acid_dap PARTITION(ds=today).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ] |
| PREHOOK: query: insert into table acid_dap partition (ds='tomorrow') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint > 1000 order by cint limit 10 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@alltypesorc |
| PREHOOK: Output: default@acid_dap@ds=tomorrow |
| POSTHOOK: query: insert into table acid_dap partition (ds='tomorrow') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint > 1000 order by cint limit 10 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@alltypesorc |
| POSTHOOK: Output: default@acid_dap@ds=tomorrow |
| POSTHOOK: Lineage: acid_dap PARTITION(ds=tomorrow).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ] |
| POSTHOOK: Lineage: acid_dap PARTITION(ds=tomorrow).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ] |
| PREHOOK: query: select a,b,ds from acid_dap order by a,b |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@acid_dap |
| PREHOOK: Input: default@acid_dap@ds=today |
| PREHOOK: Input: default@acid_dap@ds=tomorrow |
| #### A masked pattern was here #### |
| POSTHOOK: query: select a,b,ds from acid_dap order by a,b |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@acid_dap |
| POSTHOOK: Input: default@acid_dap@ds=today |
| POSTHOOK: Input: default@acid_dap@ds=tomorrow |
| #### A masked pattern was here #### |
| -1073279343 oj1YrV5Wa today |
| -1073051226 A34p7oRr2WvUJNf today |
| -1072910839 0iqrc5 today |
| -1072081801 dPkN74F7 today |
| -1072076362 2uLyD28144vklju213J1mr today |
| -1071480828 aw724t8c5558x2xneC624 today |
| -1071363017 Anj0oF today |
| -1070883071 0ruyd6Y50JpdGRf6HqD today |
| -1070551679 iUR3Q today |
| -1069736047 k17Am8uPHWk02cEf1jet today |
| 6981 1FNNhmiFLGw425NA13g tomorrow |
| 6981 4KhrrQ0nJ7bMNTvhSCA tomorrow |
| 6981 K630vaVf tomorrow |
| 6981 Y5x3JuI3M8jngv5N tomorrow |
| 6981 YdG61y00526u5 tomorrow |
| 6981 a3EhVU6Wuy7ycJ7wY7h2gv tomorrow |
| 6981 o4lvY20511w0EOX3P3I82p63 tomorrow |
| 6981 o5mb0QP5Y48Qd4vdB0 tomorrow |
| 6981 sF2CRfgt2K tomorrow |
| 6981 NULL tomorrow |
| PREHOOK: query: delete from acid_dap |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@acid_dap |
| PREHOOK: Input: default@acid_dap@ds=today |
| PREHOOK: Input: default@acid_dap@ds=tomorrow |
| PREHOOK: Output: default@acid_dap@ds=today |
| PREHOOK: Output: default@acid_dap@ds=tomorrow |
| POSTHOOK: query: delete from acid_dap |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@acid_dap |
| POSTHOOK: Input: default@acid_dap@ds=today |
| POSTHOOK: Input: default@acid_dap@ds=tomorrow |
| POSTHOOK: Output: default@acid_dap@ds=today |
| POSTHOOK: Output: default@acid_dap@ds=tomorrow |
| PREHOOK: query: select * from acid_dap |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@acid_dap |
| PREHOOK: Input: default@acid_dap@ds=today |
| PREHOOK: Input: default@acid_dap@ds=tomorrow |
| #### A masked pattern was here #### |
| POSTHOOK: query: select * from acid_dap |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@acid_dap |
| POSTHOOK: Input: default@acid_dap@ds=today |
| POSTHOOK: Input: default@acid_dap@ds=tomorrow |
| #### A masked pattern was here #### |