PREHOOK: query: DROP TABLE IF EXISTS symlink_text_input_format PREHOOK: type: DROPTABLE POSTHOOK: query: DROP TABLE IF EXISTS symlink_text_input_format POSTHOOK: type: DROPTABLE PREHOOK: query: EXPLAIN CREATE TABLE symlink_text_input_format (key STRING, value STRING) STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.SymlinkTextInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat' PREHOOK: type: CREATETABLE POSTHOOK: query: EXPLAIN CREATE TABLE symlink_text_input_format (key STRING, value STRING) STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.SymlinkTextInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat' POSTHOOK: type: CREATETABLE STAGE DEPENDENCIES: Stage-0 is a root stage STAGE PLANS: Stage: Stage-0 Create Table Operator: Create Table columns: key string, value string input format: org.apache.hadoop.hive.ql.io.SymlinkTextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat name: default.symlink_text_input_format PREHOOK: query: CREATE TABLE symlink_text_input_format (key STRING, value STRING) STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.SymlinkTextInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat' PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@symlink_text_input_format POSTHOOK: query: CREATE TABLE symlink_text_input_format (key STRING, value STRING) STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.SymlinkTextInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat' POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@symlink_text_input_format PREHOOK: query: EXPLAIN SELECT * FROM symlink_text_input_format order by key, value PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT * FROM symlink_text_input_format order by key, value POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 STAGE PLANS: Stage: Stage-1 Map Reduce Map Operator Tree: TableScan alias: symlink_text_input_format Statistics: Num rows: 0 Data size: 72 Basic stats: PARTIAL Column stats: NONE Select Operator expressions: key (type: string), value (type: string) outputColumnNames: _col0, _col1 Statistics: Num rows: 0 Data size: 72 Basic stats: PARTIAL Column stats: NONE Reduce Output Operator key expressions: _col0 (type: string), _col1 (type: string) sort order: ++ Statistics: Num rows: 0 Data size: 72 Basic stats: PARTIAL Column stats: NONE Reduce Operator Tree: Select Operator expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string) outputColumnNames: _col0, _col1 Statistics: Num rows: 0 Data size: 72 Basic stats: PARTIAL Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 0 Data size: 72 Basic stats: PARTIAL 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 Stage: Stage-0 Fetch Operator limit: -1 Processor Tree: ListSink PREHOOK: query: SELECT * FROM symlink_text_input_format order by key, value PREHOOK: type: QUERY PREHOOK: Input: default@symlink_text_input_format #### A masked pattern was here #### POSTHOOK: query: SELECT * FROM symlink_text_input_format order by key, value POSTHOOK: type: QUERY POSTHOOK: Input: default@symlink_text_input_format #### A masked pattern was here #### 1 11 2 12 2 12 2 22 3 13 3 13 4 14 4 14 5 15 6 16 7 17 7 17 8 18 8 18 8 18 8 28 PREHOOK: query: EXPLAIN SELECT value FROM symlink_text_input_format order by value PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT value FROM symlink_text_input_format order by value POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 STAGE PLANS: Stage: Stage-1 Map Reduce Map Operator Tree: TableScan alias: symlink_text_input_format Statistics: Num rows: 0 Data size: 72 Basic stats: PARTIAL Column stats: NONE Select Operator expressions: value (type: string) outputColumnNames: _col0 Statistics: Num rows: 0 Data size: 72 Basic stats: PARTIAL Column stats: NONE Reduce Output Operator key expressions: _col0 (type: string) sort order: + Statistics: Num rows: 0 Data size: 72 Basic stats: PARTIAL Column stats: NONE Reduce Operator Tree: Select Operator expressions: KEY.reducesinkkey0 (type: string) outputColumnNames: _col0 Statistics: Num rows: 0 Data size: 72 Basic stats: PARTIAL Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 0 Data size: 72 Basic stats: PARTIAL 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 Stage: Stage-0 Fetch Operator limit: -1 Processor Tree: ListSink PREHOOK: query: SELECT value FROM symlink_text_input_format order by value PREHOOK: type: QUERY PREHOOK: Input: default@symlink_text_input_format #### A masked pattern was here #### POSTHOOK: query: SELECT value FROM symlink_text_input_format order by value POSTHOOK: type: QUERY POSTHOOK: Input: default@symlink_text_input_format #### A masked pattern was here #### 11 12 12 13 13 14 14 15 16 17 17 18 18 18 22 28 PREHOOK: query: EXPLAIN SELECT count(1) FROM symlink_text_input_format PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT count(1) FROM symlink_text_input_format POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 STAGE PLANS: Stage: Stage-1 Map Reduce Map Operator Tree: TableScan alias: symlink_text_input_format Statistics: Num rows: 0 Data size: 72 Basic stats: PARTIAL Column stats: COMPLETE Select Operator Statistics: Num rows: 0 Data size: 72 Basic stats: PARTIAL Column stats: COMPLETE Group By Operator aggregations: count(1) mode: hash outputColumnNames: _col0 Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE Reduce Output Operator sort order: Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE value expressions: _col0 (type: bigint) Reduce Operator Tree: Group By Operator aggregations: count(VALUE._col0) mode: mergepartial outputColumnNames: _col0 Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE Select Operator expressions: _col0 (type: bigint) outputColumnNames: _col0 Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE File Output Operator compressed: false Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE 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 Stage: Stage-0 Fetch Operator limit: -1 Processor Tree: ListSink PREHOOK: query: SELECT count(1) FROM symlink_text_input_format PREHOOK: type: QUERY PREHOOK: Input: default@symlink_text_input_format #### A masked pattern was here #### POSTHOOK: query: SELECT count(1) FROM symlink_text_input_format POSTHOOK: type: QUERY POSTHOOK: Input: default@symlink_text_input_format #### A masked pattern was here #### 16 PREHOOK: query: DROP TABLE symlink_text_input_format PREHOOK: type: DROPTABLE PREHOOK: Input: default@symlink_text_input_format PREHOOK: Output: default@symlink_text_input_format POSTHOOK: query: DROP TABLE symlink_text_input_format POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@symlink_text_input_format POSTHOOK: Output: default@symlink_text_input_format