| PREHOOK: query: create table analyze_srcpart_n4 like srcpart |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@analyze_srcpart_n4 |
| POSTHOOK: query: create table analyze_srcpart_n4 like srcpart |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@analyze_srcpart_n4 |
| PREHOOK: query: insert overwrite table analyze_srcpart_n4 partition (ds, hr) select * from srcpart where ds is not null |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@srcpart |
| PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 |
| PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 |
| PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11 |
| PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 |
| PREHOOK: Output: default@analyze_srcpart_n4 |
| POSTHOOK: query: insert overwrite table analyze_srcpart_n4 partition (ds, hr) select * from srcpart where ds is not null |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@srcpart |
| POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 |
| POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 |
| POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11 |
| POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 |
| POSTHOOK: Output: default@analyze_srcpart_n4 |
| POSTHOOK: Output: default@analyze_srcpart_n4@ds=2008-04-08/hr=11 |
| POSTHOOK: Output: default@analyze_srcpart_n4@ds=2008-04-08/hr=12 |
| POSTHOOK: Output: default@analyze_srcpart_n4@ds=2008-04-09/hr=11 |
| POSTHOOK: Output: default@analyze_srcpart_n4@ds=2008-04-09/hr=12 |
| POSTHOOK: Lineage: analyze_srcpart_n4 PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] |
| POSTHOOK: Lineage: analyze_srcpart_n4 PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] |
| POSTHOOK: Lineage: analyze_srcpart_n4 PARTITION(ds=2008-04-08,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] |
| POSTHOOK: Lineage: analyze_srcpart_n4 PARTITION(ds=2008-04-08,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] |
| POSTHOOK: Lineage: analyze_srcpart_n4 PARTITION(ds=2008-04-09,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] |
| POSTHOOK: Lineage: analyze_srcpart_n4 PARTITION(ds=2008-04-09,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] |
| POSTHOOK: Lineage: analyze_srcpart_n4 PARTITION(ds=2008-04-09,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] |
| POSTHOOK: Lineage: analyze_srcpart_n4 PARTITION(ds=2008-04-09,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] |
| PREHOOK: query: explain analyze table analyze_srcpart_n4 PARTITION(ds='2008-04-08',hr) compute statistics |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@analyze_srcpart_n4 |
| PREHOOK: Input: default@analyze_srcpart_n4@ds=2008-04-08/hr=11 |
| PREHOOK: Input: default@analyze_srcpart_n4@ds=2008-04-08/hr=12 |
| PREHOOK: Output: default@analyze_srcpart_n4 |
| PREHOOK: Output: default@analyze_srcpart_n4@ds=2008-04-08/hr=11 |
| PREHOOK: Output: default@analyze_srcpart_n4@ds=2008-04-08/hr=12 |
| POSTHOOK: query: explain analyze table analyze_srcpart_n4 PARTITION(ds='2008-04-08',hr) compute statistics |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@analyze_srcpart_n4 |
| POSTHOOK: Input: default@analyze_srcpart_n4@ds=2008-04-08/hr=11 |
| POSTHOOK: Input: default@analyze_srcpart_n4@ds=2008-04-08/hr=12 |
| POSTHOOK: Output: default@analyze_srcpart_n4 |
| POSTHOOK: Output: default@analyze_srcpart_n4@ds=2008-04-08/hr=11 |
| POSTHOOK: Output: default@analyze_srcpart_n4@ds=2008-04-08/hr=12 |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| Stage-2 depends on stages: Stage-0 |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Tez |
| #### A masked pattern was here #### |
| Vertices: |
| Map 1 |
| Map Operator Tree: |
| TableScan |
| alias: analyze_srcpart_n4 |
| Execution mode: llap |
| LLAP IO: all inputs |
| |
| Stage: Stage-2 |
| Stats Work |
| Basic Stats Work: |
| |
| PREHOOK: query: analyze table analyze_srcpart_n4 PARTITION(ds='2008-04-08',hr) compute statistics |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@analyze_srcpart_n4 |
| PREHOOK: Input: default@analyze_srcpart_n4@ds=2008-04-08/hr=11 |
| PREHOOK: Input: default@analyze_srcpart_n4@ds=2008-04-08/hr=12 |
| PREHOOK: Output: default@analyze_srcpart_n4 |
| PREHOOK: Output: default@analyze_srcpart_n4@ds=2008-04-08/hr=11 |
| PREHOOK: Output: default@analyze_srcpart_n4@ds=2008-04-08/hr=12 |
| POSTHOOK: query: analyze table analyze_srcpart_n4 PARTITION(ds='2008-04-08',hr) compute statistics |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@analyze_srcpart_n4 |
| POSTHOOK: Input: default@analyze_srcpart_n4@ds=2008-04-08/hr=11 |
| POSTHOOK: Input: default@analyze_srcpart_n4@ds=2008-04-08/hr=12 |
| POSTHOOK: Output: default@analyze_srcpart_n4 |
| POSTHOOK: Output: default@analyze_srcpart_n4@ds=2008-04-08/hr=11 |
| POSTHOOK: Output: default@analyze_srcpart_n4@ds=2008-04-08/hr=12 |
| PREHOOK: query: describe formatted analyze_srcpart_n4 PARTITION(ds='2008-04-08',hr=11) |
| PREHOOK: type: DESCTABLE |
| PREHOOK: Input: default@analyze_srcpart_n4 |
| POSTHOOK: query: describe formatted analyze_srcpart_n4 PARTITION(ds='2008-04-08',hr=11) |
| POSTHOOK: type: DESCTABLE |
| POSTHOOK: Input: default@analyze_srcpart_n4 |
| # col_name data_type comment |
| key string default |
| value string default |
| |
| # Partition Information |
| # col_name data_type comment |
| ds string |
| hr string |
| |
| # Detailed Partition Information |
| Partition Value: [2008-04-08, 11] |
| Database: default |
| Table: analyze_srcpart_n4 |
| #### A masked pattern was here #### |
| Partition Parameters: |
| COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} |
| numFiles 1 |
| numRows 500 |
| rawDataSize 5312 |
| totalSize 5812 |
| #### A masked pattern was here #### |
| |
| # Storage Information |
| SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| InputFormat: org.apache.hadoop.mapred.TextInputFormat |
| OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat |
| Compressed: No |
| Num Buckets: -1 |
| Bucket Columns: [] |
| Sort Columns: [] |
| Storage Desc Params: |
| serialization.format 1 |
| PREHOOK: query: describe formatted analyze_srcpart_n4 PARTITION(ds='2008-04-08',hr=12) |
| PREHOOK: type: DESCTABLE |
| PREHOOK: Input: default@analyze_srcpart_n4 |
| POSTHOOK: query: describe formatted analyze_srcpart_n4 PARTITION(ds='2008-04-08',hr=12) |
| POSTHOOK: type: DESCTABLE |
| POSTHOOK: Input: default@analyze_srcpart_n4 |
| # col_name data_type comment |
| key string default |
| value string default |
| |
| # Partition Information |
| # col_name data_type comment |
| ds string |
| hr string |
| |
| # Detailed Partition Information |
| Partition Value: [2008-04-08, 12] |
| Database: default |
| Table: analyze_srcpart_n4 |
| #### A masked pattern was here #### |
| Partition Parameters: |
| COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} |
| numFiles 1 |
| numRows 500 |
| rawDataSize 5312 |
| totalSize 5812 |
| #### A masked pattern was here #### |
| |
| # Storage Information |
| SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| InputFormat: org.apache.hadoop.mapred.TextInputFormat |
| OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat |
| Compressed: No |
| Num Buckets: -1 |
| Bucket Columns: [] |
| Sort Columns: [] |
| Storage Desc Params: |
| serialization.format 1 |
| PREHOOK: query: describe formatted analyze_srcpart_n4 |
| PREHOOK: type: DESCTABLE |
| PREHOOK: Input: default@analyze_srcpart_n4 |
| POSTHOOK: query: describe formatted analyze_srcpart_n4 |
| POSTHOOK: type: DESCTABLE |
| POSTHOOK: Input: default@analyze_srcpart_n4 |
| # col_name data_type comment |
| key string default |
| value string default |
| |
| # Partition Information |
| # col_name data_type comment |
| ds string |
| hr string |
| |
| # Detailed Table Information |
| Database: default |
| #### A masked pattern was here #### |
| Retention: 0 |
| #### A masked pattern was here #### |
| Table Type: MANAGED_TABLE |
| Table Parameters: |
| bucketing_version 2 |
| numFiles 4 |
| numPartitions 4 |
| numRows 1000 |
| rawDataSize 10624 |
| totalSize 23248 |
| #### A masked pattern was here #### |
| |
| # Storage Information |
| SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| InputFormat: org.apache.hadoop.mapred.TextInputFormat |
| OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat |
| Compressed: No |
| Num Buckets: -1 |
| Bucket Columns: [] |
| Sort Columns: [] |
| Storage Desc Params: |
| serialization.format 1 |