PREHOOK: query: create table src5 (key string, value string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@src5 POSTHOOK: query: create table src5 (key string, value string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@src5 PREHOOK: query: load data local inpath '../../data/files/kv5.txt' into table src5 PREHOOK: type: LOAD #### A masked pattern was here #### PREHOOK: Output: default@src5 POSTHOOK: query: load data local inpath '../../data/files/kv5.txt' into table src5 POSTHOOK: type: LOAD #### A masked pattern was here #### POSTHOOK: Output: default@src5 PREHOOK: query: load data local inpath '../../data/files/kv5.txt' into table src5 PREHOOK: type: LOAD #### A masked pattern was here #### PREHOOK: Output: default@src5 POSTHOOK: query: load data local inpath '../../data/files/kv5.txt' into table src5 POSTHOOK: type: LOAD #### A masked pattern was here #### POSTHOOK: Output: default@src5 PREHOOK: query: explain create table total_ordered as select * from src5 order by key, value PREHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: query: explain create table total_ordered as select * from src5 order by key, value POSTHOOK: type: CREATETABLE_AS_SELECT STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 Stage-3 depends on stages: Stage-0 Stage-2 depends on stages: Stage-3 STAGE PLANS: Stage: Stage-1 Map Reduce Map Operator Tree: TableScan alias: src5 Statistics: Num rows: 2 Data size: 560 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: string), value (type: string) outputColumnNames: _col0, _col1 Statistics: Num rows: 2 Data size: 560 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: string), _col1 (type: string) sort order: ++ Statistics: Num rows: 2 Data size: 560 Basic stats: COMPLETE Column stats: NONE Reduce Operator Tree: Select Operator expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string) outputColumnNames: _col0, _col1 Statistics: Num rows: 2 Data size: 560 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 2 Data size: 560 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: default.total_ordered Stage: Stage-0 Move Operator files: hdfs directory: true #### A masked pattern was here #### Stage: Stage-3 Create Table Operator: Create Table columns: key string, value string input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: default.total_ordered Stage: Stage-2 Stats-Aggr Operator PREHOOK: query: create table total_ordered as select * from src5 order by key, value PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src5 PREHOOK: Output: database:default PREHOOK: Output: default@total_ordered POSTHOOK: query: create table total_ordered as select * from src5 order by key, value POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src5 POSTHOOK: Output: database:default POSTHOOK: Output: default@total_ordered PREHOOK: query: desc formatted total_ordered PREHOOK: type: DESCTABLE PREHOOK: Input: default@total_ordered POSTHOOK: query: desc formatted total_ordered POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@total_ordered # col_name data_type comment key string value string # Detailed Table Information Database: default #### A masked pattern was here #### Protect Mode: None Retention: 0 #### A masked pattern was here #### Table Type: MANAGED_TABLE Table Parameters: COLUMN_STATS_ACCURATE true numFiles 4 numRows 0 rawDataSize 0 totalSize 560 #### 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: select * from total_ordered PREHOOK: type: QUERY PREHOOK: Input: default@total_ordered #### A masked pattern was here #### POSTHOOK: query: select * from total_ordered POSTHOOK: type: QUERY POSTHOOK: Input: default@total_ordered #### A masked pattern was here #### 128 val_128 128 val_128 150 val_150 150 val_150 165 val_165 165 val_165 193 val_193 193 val_193 213 val_213 213 val_213 213 val_213 213 val_213 213 val_214 213 val_214 224 val_224 224 val_224 238 val_238 238 val_238 238 val_239 238 val_239 238 val_240 238 val_240 255 val_255 255 val_255 265 val_265 265 val_265 27 val_27 27 val_27 273 val_273 273 val_273 278 val_278 278 val_278 311 val_311 311 val_311 369 val_369 369 val_369 401 val_401 401 val_401 409 val_409 409 val_409 484 val_484 484 val_484 66 val_66 66 val_66 86 val_86 86 val_86 98 val_98 98 val_98 PREHOOK: query: -- rolling back to single task in case that the number of sample is not enough drop table total_ordered PREHOOK: type: DROPTABLE PREHOOK: Input: default@total_ordered PREHOOK: Output: default@total_ordered POSTHOOK: query: -- rolling back to single task in case that the number of sample is not enough drop table total_ordered POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@total_ordered POSTHOOK: Output: default@total_ordered PREHOOK: query: create table total_ordered as select * from src5 order by key, value PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src5 PREHOOK: Output: database:default PREHOOK: Output: default@total_ordered POSTHOOK: query: create table total_ordered as select * from src5 order by key, value POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src5 POSTHOOK: Output: database:default POSTHOOK: Output: default@total_ordered PREHOOK: query: desc formatted total_ordered PREHOOK: type: DESCTABLE PREHOOK: Input: default@total_ordered POSTHOOK: query: desc formatted total_ordered POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@total_ordered # col_name data_type comment key string value string # Detailed Table Information Database: default #### A masked pattern was here #### Protect Mode: None Retention: 0 #### A masked pattern was here #### Table Type: MANAGED_TABLE Table Parameters: COLUMN_STATS_ACCURATE true numFiles 1 numRows 0 rawDataSize 0 totalSize 560 #### 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: select * from total_ordered PREHOOK: type: QUERY PREHOOK: Input: default@total_ordered #### A masked pattern was here #### POSTHOOK: query: select * from total_ordered POSTHOOK: type: QUERY POSTHOOK: Input: default@total_ordered #### A masked pattern was here #### 128 val_128 128 val_128 150 val_150 150 val_150 165 val_165 165 val_165 193 val_193 193 val_193 213 val_213 213 val_213 213 val_213 213 val_213 213 val_214 213 val_214 224 val_224 224 val_224 238 val_238 238 val_238 238 val_239 238 val_239 238 val_240 238 val_240 255 val_255 255 val_255 265 val_265 265 val_265 27 val_27 27 val_27 273 val_273 273 val_273 278 val_278 278 val_278 311 val_311 311 val_311 369 val_369 369 val_369 401 val_401 401 val_401 409 val_409 409 val_409 484 val_484 484 val_484 66 val_66 66 val_66 86 val_86 86 val_86 98 val_98 98 val_98