PREHOOK: query: drop table hive_test_src PREHOOK: type: DROPTABLE POSTHOOK: query: drop table hive_test_src POSTHOOK: type: DROPTABLE PREHOOK: query: drop table hive_test_dst PREHOOK: type: DROPTABLE POSTHOOK: query: drop table hive_test_dst POSTHOOK: type: DROPTABLE PREHOOK: query: create table hive_test_src ( col1 string ) stored as textfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@hive_test_src POSTHOOK: query: create table hive_test_src ( col1 string ) stored as textfile POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@hive_test_src PREHOOK: query: explain extended load data local inpath '../../data/files/test.dat' overwrite into table hive_test_src PREHOOK: type: LOAD POSTHOOK: query: explain extended load data local inpath '../../data/files/test.dat' overwrite into table hive_test_src POSTHOOK: type: LOAD ABSTRACT SYNTAX TREE: TOK_LOAD '../../data/files/test.dat' TOK_TAB TOK_TABNAME hive_test_src local overwrite STAGE DEPENDENCIES: Stage-0 is a root stage Stage-1 depends on stages: Stage-0 STAGE PLANS: Stage: Stage-0 Move Operator tables: replace: true #### A masked pattern was here #### table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: bucket_count -1 columns col1 columns.comments columns.types string #### A masked pattern was here #### name default.hive_test_src serialization.ddl struct hive_test_src { string col1} serialization.format 1 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe #### A masked pattern was here #### serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe name: default.hive_test_src Stage: Stage-1 Stats-Aggr Operator PREHOOK: query: load data local inpath '../../data/files/test.dat' overwrite into table hive_test_src PREHOOK: type: LOAD #### A masked pattern was here #### PREHOOK: Output: default@hive_test_src POSTHOOK: query: load data local inpath '../../data/files/test.dat' overwrite into table hive_test_src POSTHOOK: type: LOAD #### A masked pattern was here #### POSTHOOK: Output: default@hive_test_src PREHOOK: query: desc formatted hive_test_src PREHOOK: type: DESCTABLE PREHOOK: Input: default@hive_test_src POSTHOOK: query: desc formatted hive_test_src POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@hive_test_src # col_name data_type comment col1 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 11 #### 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: create table hive_test_dst ( col1 string ) partitioned by ( pcol1 string , pcol2 string) stored as sequencefile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@hive_test_dst POSTHOOK: query: create table hive_test_dst ( col1 string ) partitioned by ( pcol1 string , pcol2 string) stored as sequencefile POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@hive_test_dst PREHOOK: query: insert overwrite table hive_test_dst partition ( pcol1='test_part', pCol2='test_Part') select col1 from hive_test_src PREHOOK: type: QUERY PREHOOK: Input: default@hive_test_src PREHOOK: Output: default@hive_test_dst@pcol1=test_part/pcol2=test_Part POSTHOOK: query: insert overwrite table hive_test_dst partition ( pcol1='test_part', pCol2='test_Part') select col1 from hive_test_src POSTHOOK: type: QUERY POSTHOOK: Input: default@hive_test_src POSTHOOK: Output: default@hive_test_dst@pcol1=test_part/pcol2=test_Part POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ] PREHOOK: query: select * from hive_test_dst where pcol1='test_part' and pcol2='test_Part' PREHOOK: type: QUERY PREHOOK: Input: default@hive_test_dst PREHOOK: Input: default@hive_test_dst@pcol1=test_part/pcol2=test_Part #### A masked pattern was here #### POSTHOOK: query: select * from hive_test_dst where pcol1='test_part' and pcol2='test_Part' POSTHOOK: type: QUERY POSTHOOK: Input: default@hive_test_dst POSTHOOK: Input: default@hive_test_dst@pcol1=test_part/pcol2=test_Part #### A masked pattern was here #### 1 test_part test_Part 2 test_part test_Part 3 test_part test_Part 4 test_part test_Part 5 test_part test_Part 6 test_part test_Part PREHOOK: query: select count(1) from hive_test_dst PREHOOK: type: QUERY PREHOOK: Input: default@hive_test_dst PREHOOK: Input: default@hive_test_dst@pcol1=test_part/pcol2=test_Part #### A masked pattern was here #### POSTHOOK: query: select count(1) from hive_test_dst POSTHOOK: type: QUERY POSTHOOK: Input: default@hive_test_dst POSTHOOK: Input: default@hive_test_dst@pcol1=test_part/pcol2=test_Part #### A masked pattern was here #### 6 PREHOOK: query: insert overwrite table hive_test_dst partition ( pCol1='test_part', pcol2='test_Part') select col1 from hive_test_src PREHOOK: type: QUERY PREHOOK: Input: default@hive_test_src PREHOOK: Output: default@hive_test_dst@pcol1=test_part/pcol2=test_Part POSTHOOK: query: insert overwrite table hive_test_dst partition ( pCol1='test_part', pcol2='test_Part') select col1 from hive_test_src POSTHOOK: type: QUERY POSTHOOK: Input: default@hive_test_src POSTHOOK: Output: default@hive_test_dst@pcol1=test_part/pcol2=test_Part POSTHOOK: Lineage: hive_test_dst PARTITION(pcol1=test_part,pcol2=test_Part).col1 SIMPLE [(hive_test_src)hive_test_src.FieldSchema(name:col1, type:string, comment:null), ] PREHOOK: query: select * from hive_test_dst where pcol1='test_part' and pcol2='test_part' PREHOOK: type: QUERY PREHOOK: Input: default@hive_test_dst #### A masked pattern was here #### POSTHOOK: query: select * from hive_test_dst where pcol1='test_part' and pcol2='test_part' POSTHOOK: type: QUERY POSTHOOK: Input: default@hive_test_dst #### A masked pattern was here #### PREHOOK: query: select count(1) from hive_test_dst PREHOOK: type: QUERY PREHOOK: Input: default@hive_test_dst PREHOOK: Input: default@hive_test_dst@pcol1=test_part/pcol2=test_Part #### A masked pattern was here #### POSTHOOK: query: select count(1) from hive_test_dst POSTHOOK: type: QUERY POSTHOOK: Input: default@hive_test_dst POSTHOOK: Input: default@hive_test_dst@pcol1=test_part/pcol2=test_Part #### A masked pattern was here #### 6 PREHOOK: query: select * from hive_test_dst where pcol1='test_part' PREHOOK: type: QUERY PREHOOK: Input: default@hive_test_dst PREHOOK: Input: default@hive_test_dst@pcol1=test_part/pcol2=test_Part #### A masked pattern was here #### POSTHOOK: query: select * from hive_test_dst where pcol1='test_part' POSTHOOK: type: QUERY POSTHOOK: Input: default@hive_test_dst POSTHOOK: Input: default@hive_test_dst@pcol1=test_part/pcol2=test_Part #### A masked pattern was here #### 1 test_part test_Part 2 test_part test_Part 3 test_part test_Part 4 test_part test_Part 5 test_part test_Part 6 test_part test_Part PREHOOK: query: select * from hive_test_dst where pcol1='test_part' and pcol2='test_part' PREHOOK: type: QUERY PREHOOK: Input: default@hive_test_dst #### A masked pattern was here #### POSTHOOK: query: select * from hive_test_dst where pcol1='test_part' and pcol2='test_part' POSTHOOK: type: QUERY POSTHOOK: Input: default@hive_test_dst #### A masked pattern was here #### PREHOOK: query: select * from hive_test_dst where pcol1='test_Part' PREHOOK: type: QUERY PREHOOK: Input: default@hive_test_dst #### A masked pattern was here #### POSTHOOK: query: select * from hive_test_dst where pcol1='test_Part' POSTHOOK: type: QUERY POSTHOOK: Input: default@hive_test_dst #### A masked pattern was here #### PREHOOK: query: describe formatted hive_test_dst PREHOOK: type: DESCTABLE PREHOOK: Input: default@hive_test_dst POSTHOOK: query: describe formatted hive_test_dst POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@hive_test_dst # col_name data_type comment col1 string # Partition Information # col_name data_type comment pcol1 string pcol2 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: #### A masked pattern was here #### # Storage Information SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe InputFormat: org.apache.hadoop.mapred.SequenceFileInputFormat OutputFormat: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat Compressed: No Num Buckets: -1 Bucket Columns: [] Sort Columns: [] Storage Desc Params: serialization.format 1 PREHOOK: query: drop table hive_test_src PREHOOK: type: DROPTABLE PREHOOK: Input: default@hive_test_src PREHOOK: Output: default@hive_test_src POSTHOOK: query: drop table hive_test_src POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@hive_test_src POSTHOOK: Output: default@hive_test_src PREHOOK: query: drop table hive_test_dst PREHOOK: type: DROPTABLE PREHOOK: Input: default@hive_test_dst PREHOOK: Output: default@hive_test_dst POSTHOOK: query: drop table hive_test_dst POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@hive_test_dst POSTHOOK: Output: default@hive_test_dst