| PREHOOK: query: CREATE TABLE alltypesparquet_part_varchar(ctinyint tinyint, csmallint smallint, cint int, cbigint bigint, cfloat float, cdouble double, cstring1 string, cstring2 string, ctimestamp1 timestamp, ctimestamp2 timestamp, cboolean1 boolean, cboolean2 boolean) partitioned by (ds varchar(4)) STORED AS PARQUET |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@alltypesparquet_part_varchar |
| POSTHOOK: query: CREATE TABLE alltypesparquet_part_varchar(ctinyint tinyint, csmallint smallint, cint int, cbigint bigint, cfloat float, cdouble double, cstring1 string, cstring2 string, ctimestamp1 timestamp, ctimestamp2 timestamp, cboolean1 boolean, cboolean2 boolean) partitioned by (ds varchar(4)) STORED AS PARQUET |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@alltypesparquet_part_varchar |
| PREHOOK: query: insert overwrite table alltypesparquet_part_varchar partition (ds='2011') select * from alltypesparquet limit 100 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@alltypesparquet |
| PREHOOK: Output: default@alltypesparquet_part_varchar@ds=2011 |
| POSTHOOK: query: insert overwrite table alltypesparquet_part_varchar partition (ds='2011') select * from alltypesparquet limit 100 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@alltypesparquet |
| POSTHOOK: Output: default@alltypesparquet_part_varchar@ds=2011 |
| POSTHOOK: Lineage: alltypesparquet_part_varchar PARTITION(ds=2011).cbigint SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:cbigint, type:bigint, comment:null), ] |
| POSTHOOK: Lineage: alltypesparquet_part_varchar PARTITION(ds=2011).cboolean1 SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:cboolean1, type:boolean, comment:null), ] |
| POSTHOOK: Lineage: alltypesparquet_part_varchar PARTITION(ds=2011).cboolean2 SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:cboolean2, type:boolean, comment:null), ] |
| POSTHOOK: Lineage: alltypesparquet_part_varchar PARTITION(ds=2011).cdouble SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:cdouble, type:double, comment:null), ] |
| POSTHOOK: Lineage: alltypesparquet_part_varchar PARTITION(ds=2011).cfloat SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:cfloat, type:float, comment:null), ] |
| POSTHOOK: Lineage: alltypesparquet_part_varchar PARTITION(ds=2011).cint SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:cint, type:int, comment:null), ] |
| POSTHOOK: Lineage: alltypesparquet_part_varchar PARTITION(ds=2011).csmallint SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:csmallint, type:smallint, comment:null), ] |
| POSTHOOK: Lineage: alltypesparquet_part_varchar PARTITION(ds=2011).cstring1 SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:cstring1, type:string, comment:null), ] |
| POSTHOOK: Lineage: alltypesparquet_part_varchar PARTITION(ds=2011).cstring2 SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:cstring2, type:string, comment:null), ] |
| POSTHOOK: Lineage: alltypesparquet_part_varchar PARTITION(ds=2011).ctimestamp1 SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:ctimestamp1, type:timestamp, comment:null), ] |
| POSTHOOK: Lineage: alltypesparquet_part_varchar PARTITION(ds=2011).ctimestamp2 SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:ctimestamp2, type:timestamp, comment:null), ] |
| POSTHOOK: Lineage: alltypesparquet_part_varchar PARTITION(ds=2011).ctinyint SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:ctinyint, type:tinyint, comment:null), ] |
| PREHOOK: query: insert overwrite table alltypesparquet_part_varchar partition (ds='2012') select * from alltypesparquet limit 100 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@alltypesparquet |
| PREHOOK: Output: default@alltypesparquet_part_varchar@ds=2012 |
| POSTHOOK: query: insert overwrite table alltypesparquet_part_varchar partition (ds='2012') select * from alltypesparquet limit 100 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@alltypesparquet |
| POSTHOOK: Output: default@alltypesparquet_part_varchar@ds=2012 |
| POSTHOOK: Lineage: alltypesparquet_part_varchar PARTITION(ds=2012).cbigint SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:cbigint, type:bigint, comment:null), ] |
| POSTHOOK: Lineage: alltypesparquet_part_varchar PARTITION(ds=2012).cboolean1 SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:cboolean1, type:boolean, comment:null), ] |
| POSTHOOK: Lineage: alltypesparquet_part_varchar PARTITION(ds=2012).cboolean2 SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:cboolean2, type:boolean, comment:null), ] |
| POSTHOOK: Lineage: alltypesparquet_part_varchar PARTITION(ds=2012).cdouble SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:cdouble, type:double, comment:null), ] |
| POSTHOOK: Lineage: alltypesparquet_part_varchar PARTITION(ds=2012).cfloat SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:cfloat, type:float, comment:null), ] |
| POSTHOOK: Lineage: alltypesparquet_part_varchar PARTITION(ds=2012).cint SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:cint, type:int, comment:null), ] |
| POSTHOOK: Lineage: alltypesparquet_part_varchar PARTITION(ds=2012).csmallint SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:csmallint, type:smallint, comment:null), ] |
| POSTHOOK: Lineage: alltypesparquet_part_varchar PARTITION(ds=2012).cstring1 SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:cstring1, type:string, comment:null), ] |
| POSTHOOK: Lineage: alltypesparquet_part_varchar PARTITION(ds=2012).cstring2 SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:cstring2, type:string, comment:null), ] |
| POSTHOOK: Lineage: alltypesparquet_part_varchar PARTITION(ds=2012).ctimestamp1 SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:ctimestamp1, type:timestamp, comment:null), ] |
| POSTHOOK: Lineage: alltypesparquet_part_varchar PARTITION(ds=2012).ctimestamp2 SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:ctimestamp2, type:timestamp, comment:null), ] |
| POSTHOOK: Lineage: alltypesparquet_part_varchar PARTITION(ds=2012).ctinyint SIMPLE [(alltypesparquet)alltypesparquet.FieldSchema(name:ctinyint, type:tinyint, comment:null), ] |
| PREHOOK: query: select count(cdouble), cint from alltypesparquet_part_varchar where ds='2011' group by cint limit 10 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@alltypesparquet_part_varchar |
| PREHOOK: Input: default@alltypesparquet_part_varchar@ds=2011 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select count(cdouble), cint from alltypesparquet_part_varchar where ds='2011' group by cint limit 10 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@alltypesparquet_part_varchar |
| POSTHOOK: Input: default@alltypesparquet_part_varchar@ds=2011 |
| #### A masked pattern was here #### |
| 100 528534767 |
| PREHOOK: query: select count(*) from alltypesparquet_part_varchar A join alltypesparquet_part_varchar B on A.ds=B.ds |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@alltypesparquet_part_varchar |
| PREHOOK: Input: default@alltypesparquet_part_varchar@ds=2011 |
| PREHOOK: Input: default@alltypesparquet_part_varchar@ds=2012 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select count(*) from alltypesparquet_part_varchar A join alltypesparquet_part_varchar B on A.ds=B.ds |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@alltypesparquet_part_varchar |
| POSTHOOK: Input: default@alltypesparquet_part_varchar@ds=2011 |
| POSTHOOK: Input: default@alltypesparquet_part_varchar@ds=2012 |
| #### A masked pattern was here #### |
| 20000 |