PREHOOK: query: -- test analyze table compute statistiscs [noscan] on external table -- 1 test table #### A masked pattern was here #### PREHOOK: type: CREATETABLE #### A masked pattern was here #### PREHOOK: Output: database:default PREHOOK: Output: default@anaylyze_external POSTHOOK: query: -- test analyze table compute statistiscs [noscan] on external table -- 1 test table #### A masked pattern was here #### POSTHOOK: type: CREATETABLE #### A masked pattern was here #### POSTHOOK: Output: database:default POSTHOOK: Output: default@anaylyze_external PREHOOK: query: SELECT * FROM anaylyze_external PREHOOK: type: QUERY PREHOOK: Input: default@anaylyze_external #### A masked pattern was here #### POSTHOOK: query: SELECT * FROM anaylyze_external POSTHOOK: type: QUERY POSTHOOK: Input: default@anaylyze_external #### A masked pattern was here #### 1 2 3 4 5 6 PREHOOK: query: analyze table anaylyze_external compute statistics noscan PREHOOK: type: QUERY PREHOOK: Input: default@anaylyze_external PREHOOK: Output: default@anaylyze_external POSTHOOK: query: analyze table anaylyze_external compute statistics noscan POSTHOOK: type: QUERY POSTHOOK: Input: default@anaylyze_external POSTHOOK: Output: default@anaylyze_external PREHOOK: query: describe formatted anaylyze_external PREHOOK: type: DESCTABLE PREHOOK: Input: default@anaylyze_external POSTHOOK: query: describe formatted anaylyze_external POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@anaylyze_external # col_name data_type comment a int # Detailed Table Information Database: default #### A masked pattern was here #### Protect Mode: None Retention: 0 #### A masked pattern was here #### Table Type: EXTERNAL_TABLE Table Parameters: COLUMN_STATS_ACCURATE true EXTERNAL TRUE numFiles 0 numRows -1 rawDataSize -1 totalSize 0 #### 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: analyze table anaylyze_external compute statistics PREHOOK: type: QUERY PREHOOK: Input: default@anaylyze_external PREHOOK: Output: default@anaylyze_external POSTHOOK: query: analyze table anaylyze_external compute statistics POSTHOOK: type: QUERY POSTHOOK: Input: default@anaylyze_external POSTHOOK: Output: default@anaylyze_external PREHOOK: query: describe formatted anaylyze_external PREHOOK: type: DESCTABLE PREHOOK: Input: default@anaylyze_external POSTHOOK: query: describe formatted anaylyze_external POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@anaylyze_external # col_name data_type comment a int # Detailed Table Information Database: default #### A masked pattern was here #### Protect Mode: None Retention: 0 #### A masked pattern was here #### Table Type: EXTERNAL_TABLE Table Parameters: COLUMN_STATS_ACCURATE true EXTERNAL TRUE numFiles 0 numRows 6 rawDataSize 6 totalSize 0 #### 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: drop table anaylyze_external PREHOOK: type: DROPTABLE PREHOOK: Input: default@anaylyze_external PREHOOK: Output: default@anaylyze_external POSTHOOK: query: drop table anaylyze_external POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@anaylyze_external POSTHOOK: Output: default@anaylyze_external PREHOOK: query: -- 2 test partition -- prepare data create table texternal(key string, val string) partitioned by (insertdate string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@texternal POSTHOOK: query: -- 2 test partition -- prepare data create table texternal(key string, val string) partitioned by (insertdate string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@texternal #### A masked pattern was here #### PREHOOK: type: ALTERTABLE_ADDPARTS #### A masked pattern was here #### PREHOOK: Output: default@texternal #### A masked pattern was here #### POSTHOOK: type: ALTERTABLE_ADDPARTS #### A masked pattern was here #### POSTHOOK: Output: default@texternal POSTHOOK: Output: default@texternal@insertdate=2008-01-01 PREHOOK: query: from src insert overwrite table texternal partition (insertdate='2008-01-01') select * PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@texternal@insertdate=2008-01-01 POSTHOOK: query: from src insert overwrite table texternal partition (insertdate='2008-01-01') select * POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: default@texternal@insertdate=2008-01-01 POSTHOOK: Lineage: texternal PARTITION(insertdate=2008-01-01).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: texternal PARTITION(insertdate=2008-01-01).val SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] PREHOOK: query: select count(*) from texternal where insertdate='2008-01-01' PREHOOK: type: QUERY PREHOOK: Input: default@texternal PREHOOK: Input: default@texternal@insertdate=2008-01-01 #### A masked pattern was here #### POSTHOOK: query: select count(*) from texternal where insertdate='2008-01-01' POSTHOOK: type: QUERY POSTHOOK: Input: default@texternal POSTHOOK: Input: default@texternal@insertdate=2008-01-01 #### A masked pattern was here #### 500 PREHOOK: query: -- create external table #### A masked pattern was here #### PREHOOK: type: CREATETABLE #### A masked pattern was here #### PREHOOK: Output: database:default PREHOOK: Output: default@anaylyze_external POSTHOOK: query: -- create external table #### A masked pattern was here #### POSTHOOK: type: CREATETABLE #### A masked pattern was here #### POSTHOOK: Output: database:default POSTHOOK: Output: default@anaylyze_external #### A masked pattern was here #### PREHOOK: type: ALTERTABLE_ADDPARTS #### A masked pattern was here #### PREHOOK: Output: default@anaylyze_external #### A masked pattern was here #### POSTHOOK: type: ALTERTABLE_ADDPARTS #### A masked pattern was here #### POSTHOOK: Output: default@anaylyze_external POSTHOOK: Output: default@anaylyze_external@insertdate=2008-01-01 PREHOOK: query: select count(*) from anaylyze_external where insertdate='2008-01-01' PREHOOK: type: QUERY PREHOOK: Input: default@anaylyze_external PREHOOK: Input: default@anaylyze_external@insertdate=2008-01-01 #### A masked pattern was here #### POSTHOOK: query: select count(*) from anaylyze_external where insertdate='2008-01-01' POSTHOOK: type: QUERY POSTHOOK: Input: default@anaylyze_external POSTHOOK: Input: default@anaylyze_external@insertdate=2008-01-01 #### A masked pattern was here #### 500 PREHOOK: query: -- analyze analyze table anaylyze_external PARTITION (insertdate='2008-01-01') compute statistics noscan PREHOOK: type: QUERY PREHOOK: Input: default@anaylyze_external PREHOOK: Input: default@anaylyze_external@insertdate=2008-01-01 PREHOOK: Output: default@anaylyze_external PREHOOK: Output: default@anaylyze_external@insertdate=2008-01-01 POSTHOOK: query: -- analyze analyze table anaylyze_external PARTITION (insertdate='2008-01-01') compute statistics noscan POSTHOOK: type: QUERY POSTHOOK: Input: default@anaylyze_external POSTHOOK: Input: default@anaylyze_external@insertdate=2008-01-01 POSTHOOK: Output: default@anaylyze_external POSTHOOK: Output: default@anaylyze_external@insertdate=2008-01-01 PREHOOK: query: describe formatted anaylyze_external PARTITION (insertdate='2008-01-01') PREHOOK: type: DESCTABLE PREHOOK: Input: default@anaylyze_external POSTHOOK: query: describe formatted anaylyze_external PARTITION (insertdate='2008-01-01') POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@anaylyze_external # col_name data_type comment key string val string # Partition Information # col_name data_type comment insertdate string # Detailed Partition Information Partition Value: [2008-01-01] Database: default Table: anaylyze_external #### A masked pattern was here #### Protect Mode: None #### A masked pattern was here #### Partition Parameters: COLUMN_STATS_ACCURATE true numFiles 1 numRows -1 rawDataSize -1 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: analyze table anaylyze_external PARTITION (insertdate='2008-01-01') compute statistics PREHOOK: type: QUERY PREHOOK: Input: default@anaylyze_external PREHOOK: Input: default@anaylyze_external@insertdate=2008-01-01 PREHOOK: Output: default@anaylyze_external PREHOOK: Output: default@anaylyze_external@insertdate=2008-01-01 POSTHOOK: query: analyze table anaylyze_external PARTITION (insertdate='2008-01-01') compute statistics POSTHOOK: type: QUERY POSTHOOK: Input: default@anaylyze_external POSTHOOK: Input: default@anaylyze_external@insertdate=2008-01-01 POSTHOOK: Output: default@anaylyze_external POSTHOOK: Output: default@anaylyze_external@insertdate=2008-01-01 PREHOOK: query: describe formatted anaylyze_external PARTITION (insertdate='2008-01-01') PREHOOK: type: DESCTABLE PREHOOK: Input: default@anaylyze_external POSTHOOK: query: describe formatted anaylyze_external PARTITION (insertdate='2008-01-01') POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@anaylyze_external # col_name data_type comment key string val string # Partition Information # col_name data_type comment insertdate string # Detailed Partition Information Partition Value: [2008-01-01] Database: default Table: anaylyze_external #### A masked pattern was here #### Protect Mode: None #### A masked pattern was here #### Partition Parameters: COLUMN_STATS_ACCURATE 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 #### A masked pattern was here #### PREHOOK: query: drop table anaylyze_external PREHOOK: type: DROPTABLE PREHOOK: Input: default@anaylyze_external PREHOOK: Output: default@anaylyze_external POSTHOOK: query: drop table anaylyze_external POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@anaylyze_external POSTHOOK: Output: default@anaylyze_external