| PREHOOK: query: DROP VIEW vp1 |
| PREHOOK: type: DROPVIEW |
| POSTHOOK: query: DROP VIEW vp1 |
| POSTHOOK: type: DROPVIEW |
| PREHOOK: query: DROP VIEW vp2 |
| PREHOOK: type: DROPVIEW |
| POSTHOOK: query: DROP VIEW vp2 |
| POSTHOOK: type: DROPVIEW |
| PREHOOK: query: DROP VIEW vp3 |
| PREHOOK: type: DROPVIEW |
| POSTHOOK: query: DROP VIEW vp3 |
| POSTHOOK: type: DROPVIEW |
| PREHOOK: query: CREATE VIEW vp1 |
| PARTITIONED ON (value) |
| AS |
| SELECT key, value |
| FROM src |
| WHERE key=86 |
| PREHOOK: type: CREATEVIEW |
| PREHOOK: Input: default@src |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@vp1 |
| POSTHOOK: query: CREATE VIEW vp1 |
| PARTITIONED ON (value) |
| AS |
| SELECT key, value |
| FROM src |
| WHERE key=86 |
| POSTHOOK: type: CREATEVIEW |
| POSTHOOK: Input: default@src |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@vp1 |
| POSTHOOK: Lineage: vp1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] |
| PREHOOK: query: DESCRIBE EXTENDED vp1 |
| PREHOOK: type: DESCTABLE |
| PREHOOK: Input: default@vp1 |
| POSTHOOK: query: DESCRIBE EXTENDED vp1 |
| POSTHOOK: type: DESCTABLE |
| POSTHOOK: Input: default@vp1 |
| key string |
| value string |
| |
| # Partition Information |
| # col_name data_type comment |
| value string |
| |
| #### A masked pattern was here #### |
| PREHOOK: query: DESCRIBE FORMATTED vp1 |
| PREHOOK: type: DESCTABLE |
| PREHOOK: Input: default@vp1 |
| POSTHOOK: query: DESCRIBE FORMATTED vp1 |
| POSTHOOK: type: DESCTABLE |
| POSTHOOK: Input: default@vp1 |
| # col_name data_type comment |
| key string |
| |
| # Partition Information |
| # col_name data_type comment |
| value string |
| |
| # Detailed Table Information |
| Database: default |
| #### A masked pattern was here #### |
| Retention: 0 |
| Table Type: VIRTUAL_VIEW |
| Table Parameters: |
| COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} |
| bucketing_version 2 |
| numFiles 0 |
| numPartitions 0 |
| numRows 0 |
| rawDataSize 0 |
| totalSize 0 |
| #### A masked pattern was here #### |
| |
| # Storage Information |
| SerDe Library: null |
| InputFormat: org.apache.hadoop.mapred.TextInputFormat |
| OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat |
| Compressed: No |
| Num Buckets: -1 |
| Bucket Columns: [] |
| Sort Columns: [] |
| |
| # View Information |
| Original Query: SELECT key, value |
| FROM src |
| WHERE key=86 |
| Expanded Query: SELECT `src`.`key`, `src`.`value` |
| FROM `default`.`src` |
| WHERE `src`.`key`=86 |
| PREHOOK: query: SELECT * FROM vp1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| PREHOOK: Input: default@vp1 |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT * FROM vp1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| POSTHOOK: Input: default@vp1 |
| #### A masked pattern was here #### |
| 86 val_86 |
| PREHOOK: query: SELECT key FROM vp1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| PREHOOK: Input: default@vp1 |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT key FROM vp1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| POSTHOOK: Input: default@vp1 |
| #### A masked pattern was here #### |
| 86 |
| PREHOOK: query: SELECT value FROM vp1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| PREHOOK: Input: default@vp1 |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT value FROM vp1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| POSTHOOK: Input: default@vp1 |
| #### A masked pattern was here #### |
| val_86 |
| PREHOOK: query: ALTER VIEW vp1 |
| ADD PARTITION (value='val_86') PARTITION (value='val_xyz') |
| PREHOOK: type: ALTERTABLE_ADDPARTS |
| PREHOOK: Input: default@src |
| PREHOOK: Input: default@vp1 |
| PREHOOK: Output: default@vp1 |
| POSTHOOK: query: ALTER VIEW vp1 |
| ADD PARTITION (value='val_86') PARTITION (value='val_xyz') |
| POSTHOOK: type: ALTERTABLE_ADDPARTS |
| POSTHOOK: Input: default@src |
| POSTHOOK: Input: default@vp1 |
| POSTHOOK: Output: default@vp1 |
| POSTHOOK: Output: default@vp1@value=val_86 |
| POSTHOOK: Output: default@vp1@value=val_xyz |
| PREHOOK: query: ALTER VIEW vp1 |
| ADD IF NOT EXISTS PARTITION (value='val_xyz') |
| PREHOOK: type: ALTERTABLE_ADDPARTS |
| PREHOOK: Input: default@src |
| PREHOOK: Input: default@vp1 |
| PREHOOK: Output: default@vp1 |
| POSTHOOK: query: ALTER VIEW vp1 |
| ADD IF NOT EXISTS PARTITION (value='val_xyz') |
| POSTHOOK: type: ALTERTABLE_ADDPARTS |
| POSTHOOK: Input: default@src |
| POSTHOOK: Input: default@vp1 |
| POSTHOOK: Output: default@vp1 |
| PREHOOK: query: SHOW PARTITIONS vp1 |
| PREHOOK: type: SHOWPARTITIONS |
| PREHOOK: Input: default@vp1 |
| POSTHOOK: query: SHOW PARTITIONS vp1 |
| POSTHOOK: type: SHOWPARTITIONS |
| POSTHOOK: Input: default@vp1 |
| value=val_86 |
| value=val_xyz |
| PREHOOK: query: SHOW PARTITIONS vp1 PARTITION(value='val_86') |
| PREHOOK: type: SHOWPARTITIONS |
| PREHOOK: Input: default@vp1 |
| POSTHOOK: query: SHOW PARTITIONS vp1 PARTITION(value='val_86') |
| POSTHOOK: type: SHOWPARTITIONS |
| POSTHOOK: Input: default@vp1 |
| value=val_86 |
| PREHOOK: query: SHOW TABLE EXTENDED LIKE vp1 |
| PREHOOK: type: SHOW_TABLESTATUS |
| POSTHOOK: query: SHOW TABLE EXTENDED LIKE vp1 |
| POSTHOOK: type: SHOW_TABLESTATUS |
| tableName:vp1 |
| #### A masked pattern was here #### |
| location:null |
| inputformat:org.apache.hadoop.mapred.TextInputFormat |
| outputformat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat |
| columns:struct columns { string key} |
| partitioned:true |
| partitionColumns:struct partition_columns { string value} |
| |
| PREHOOK: query: SHOW TABLE EXTENDED LIKE vp1 PARTITION(value='val_86') |
| PREHOOK: type: SHOW_TABLESTATUS |
| POSTHOOK: query: SHOW TABLE EXTENDED LIKE vp1 PARTITION(value='val_86') |
| POSTHOOK: type: SHOW_TABLESTATUS |
| tableName:vp1 |
| #### A masked pattern was here #### |
| location:null |
| inputformat:org.apache.hadoop.mapred.TextInputFormat |
| outputformat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat |
| columns:struct columns { string key} |
| partitioned:true |
| partitionColumns:struct partition_columns { string value} |
| |
| PREHOOK: query: ALTER VIEW vp1 |
| DROP PARTITION (value='val_xyz') |
| PREHOOK: type: ALTERTABLE_DROPPARTS |
| PREHOOK: Input: default@vp1 |
| PREHOOK: Output: default@vp1@value=val_xyz |
| POSTHOOK: query: ALTER VIEW vp1 |
| DROP PARTITION (value='val_xyz') |
| POSTHOOK: type: ALTERTABLE_DROPPARTS |
| POSTHOOK: Input: default@vp1 |
| POSTHOOK: Output: default@vp1@value=val_xyz |
| PREHOOK: query: ALTER VIEW vp1 |
| DROP IF EXISTS PARTITION (value='val_xyz') |
| PREHOOK: type: ALTERTABLE_DROPPARTS |
| PREHOOK: Input: default@vp1 |
| POSTHOOK: query: ALTER VIEW vp1 |
| DROP IF EXISTS PARTITION (value='val_xyz') |
| POSTHOOK: type: ALTERTABLE_DROPPARTS |
| POSTHOOK: Input: default@vp1 |
| PREHOOK: query: SHOW PARTITIONS vp1 |
| PREHOOK: type: SHOWPARTITIONS |
| PREHOOK: Input: default@vp1 |
| POSTHOOK: query: SHOW PARTITIONS vp1 |
| POSTHOOK: type: SHOWPARTITIONS |
| POSTHOOK: Input: default@vp1 |
| value=val_86 |
| PREHOOK: query: SELECT * FROM vp1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| PREHOOK: Input: default@vp1 |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT * FROM vp1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| POSTHOOK: Input: default@vp1 |
| #### A masked pattern was here #### |
| 86 val_86 |
| PREHOOK: query: CREATE VIEW vp2 |
| PARTITIONED ON (hr) |
| AS SELECT * FROM srcpart WHERE key < 10 |
| PREHOOK: type: CREATEVIEW |
| PREHOOK: Input: default@srcpart |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@vp2 |
| POSTHOOK: query: CREATE VIEW vp2 |
| PARTITIONED ON (hr) |
| AS SELECT * FROM srcpart WHERE key < 10 |
| POSTHOOK: type: CREATEVIEW |
| POSTHOOK: Input: default@srcpart |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@vp2 |
| POSTHOOK: Lineage: vp2.ds SIMPLE [(srcpart)srcpart.FieldSchema(name:ds, type:string, comment:null), ] |
| POSTHOOK: Lineage: vp2.key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] |
| POSTHOOK: Lineage: vp2.value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] |
| PREHOOK: query: DESCRIBE FORMATTED vp2 |
| PREHOOK: type: DESCTABLE |
| PREHOOK: Input: default@vp2 |
| POSTHOOK: query: DESCRIBE FORMATTED vp2 |
| POSTHOOK: type: DESCTABLE |
| POSTHOOK: Input: default@vp2 |
| # col_name data_type comment |
| key string |
| value string |
| ds string |
| |
| # Partition Information |
| # col_name data_type comment |
| hr string |
| |
| # Detailed Table Information |
| Database: default |
| #### A masked pattern was here #### |
| Retention: 0 |
| Table Type: VIRTUAL_VIEW |
| Table Parameters: |
| COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} |
| bucketing_version 2 |
| numFiles 0 |
| numPartitions 0 |
| numRows 0 |
| rawDataSize 0 |
| totalSize 0 |
| #### A masked pattern was here #### |
| |
| # Storage Information |
| SerDe Library: null |
| InputFormat: org.apache.hadoop.mapred.TextInputFormat |
| OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat |
| Compressed: No |
| Num Buckets: -1 |
| Bucket Columns: [] |
| Sort Columns: [] |
| |
| # View Information |
| Original Query: SELECT * FROM srcpart WHERE key < 10 |
| Expanded Query: SELECT `srcpart`.`key`, `srcpart`.`value`, `srcpart`.`ds`, `srcpart`.`hr` FROM `default`.`srcpart` WHERE `srcpart`.`key` < 10 |
| PREHOOK: query: ALTER VIEW vp2 ADD PARTITION (hr='11') PARTITION (hr='12') |
| PREHOOK: type: ALTERTABLE_ADDPARTS |
| 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: Input: default@vp2 |
| PREHOOK: Output: default@vp2 |
| POSTHOOK: query: ALTER VIEW vp2 ADD PARTITION (hr='11') PARTITION (hr='12') |
| POSTHOOK: type: ALTERTABLE_ADDPARTS |
| 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: Input: default@vp2 |
| POSTHOOK: Output: default@vp2 |
| POSTHOOK: Output: default@vp2@hr=11 |
| POSTHOOK: Output: default@vp2@hr=12 |
| PREHOOK: query: SELECT key FROM vp2 WHERE hr='12' ORDER BY key |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@srcpart |
| PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 |
| PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 |
| PREHOOK: Input: default@vp2 |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT key FROM vp2 WHERE hr='12' ORDER BY key |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@srcpart |
| POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 |
| POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 |
| POSTHOOK: Input: default@vp2 |
| #### A masked pattern was here #### |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| 2 |
| 2 |
| 4 |
| 4 |
| 5 |
| 5 |
| 5 |
| 5 |
| 5 |
| 5 |
| 8 |
| 8 |
| 9 |
| 9 |
| PREHOOK: query: CREATE VIEW vp3(k,v) |
| PARTITIONED ON (v) |
| AS |
| SELECT key, value |
| FROM src |
| WHERE key=86 |
| PREHOOK: type: CREATEVIEW |
| PREHOOK: Input: default@src |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@vp3 |
| POSTHOOK: query: CREATE VIEW vp3(k,v) |
| PARTITIONED ON (v) |
| AS |
| SELECT key, value |
| FROM src |
| WHERE key=86 |
| POSTHOOK: type: CREATEVIEW |
| POSTHOOK: Input: default@src |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@vp3 |
| POSTHOOK: Lineage: vp3.k SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] |
| PREHOOK: query: DESCRIBE FORMATTED vp3 |
| PREHOOK: type: DESCTABLE |
| PREHOOK: Input: default@vp3 |
| POSTHOOK: query: DESCRIBE FORMATTED vp3 |
| POSTHOOK: type: DESCTABLE |
| POSTHOOK: Input: default@vp3 |
| # col_name data_type comment |
| k string |
| |
| # Partition Information |
| # col_name data_type comment |
| v string |
| |
| # Detailed Table Information |
| Database: default |
| #### A masked pattern was here #### |
| Retention: 0 |
| Table Type: VIRTUAL_VIEW |
| Table Parameters: |
| COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} |
| bucketing_version 2 |
| numFiles 0 |
| numPartitions 0 |
| numRows 0 |
| rawDataSize 0 |
| totalSize 0 |
| #### A masked pattern was here #### |
| |
| # Storage Information |
| SerDe Library: null |
| InputFormat: org.apache.hadoop.mapred.TextInputFormat |
| OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat |
| Compressed: No |
| Num Buckets: -1 |
| Bucket Columns: [] |
| Sort Columns: [] |
| |
| # View Information |
| Original Query: SELECT key, value |
| FROM src |
| WHERE key=86 |
| Expanded Query: SELECT `key` AS `k`, `value` AS `v` FROM (SELECT `src`.`key`, `src`.`value` |
| FROM `default`.`src` |
| WHERE `src`.`key`=86) `vp3` |
| PREHOOK: query: ALTER VIEW vp3 |
| ADD PARTITION (v='val_86') |
| PREHOOK: type: ALTERTABLE_ADDPARTS |
| PREHOOK: Input: default@src |
| PREHOOK: Input: default@vp3 |
| PREHOOK: Output: default@vp3 |
| POSTHOOK: query: ALTER VIEW vp3 |
| ADD PARTITION (v='val_86') |
| POSTHOOK: type: ALTERTABLE_ADDPARTS |
| POSTHOOK: Input: default@src |
| POSTHOOK: Input: default@vp3 |
| POSTHOOK: Output: default@vp3 |
| POSTHOOK: Output: default@vp3@v=val_86 |
| PREHOOK: query: DROP VIEW vp1 |
| PREHOOK: type: DROPVIEW |
| PREHOOK: Input: default@vp1 |
| PREHOOK: Output: default@vp1 |
| POSTHOOK: query: DROP VIEW vp1 |
| POSTHOOK: type: DROPVIEW |
| POSTHOOK: Input: default@vp1 |
| POSTHOOK: Output: default@vp1 |
| PREHOOK: query: DROP VIEW vp2 |
| PREHOOK: type: DROPVIEW |
| PREHOOK: Input: default@vp2 |
| PREHOOK: Output: default@vp2 |
| POSTHOOK: query: DROP VIEW vp2 |
| POSTHOOK: type: DROPVIEW |
| POSTHOOK: Input: default@vp2 |
| POSTHOOK: Output: default@vp2 |
| PREHOOK: query: DROP VIEW vp3 |
| PREHOOK: type: DROPVIEW |
| PREHOOK: Input: default@vp3 |
| PREHOOK: Output: default@vp3 |
| POSTHOOK: query: DROP VIEW vp3 |
| POSTHOOK: type: DROPVIEW |
| POSTHOOK: Input: default@vp3 |
| POSTHOOK: Output: default@vp3 |
| PREHOOK: query: CREATE TABLE table1_n12 (id int) PARTITIONED BY (year int) |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@table1_n12 |
| POSTHOOK: query: CREATE TABLE table1_n12 (id int) PARTITIONED BY (year int) |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@table1_n12 |
| PREHOOK: query: CREATE VIEW view1_n0 partitioned on (year) as select id, year from table1_n12 |
| PREHOOK: type: CREATEVIEW |
| PREHOOK: Input: default@table1_n12 |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@view1_n0 |
| POSTHOOK: query: CREATE VIEW view1_n0 partitioned on (year) as select id, year from table1_n12 |
| POSTHOOK: type: CREATEVIEW |
| POSTHOOK: Input: default@table1_n12 |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@view1_n0 |
| POSTHOOK: Lineage: view1_n0.id SIMPLE [(table1_n12)table1_n12.FieldSchema(name:id, type:int, comment:null), ] |
| PREHOOK: query: select year from view1_n0 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@table1_n12 |
| PREHOOK: Input: default@view1_n0 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select year from view1_n0 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@table1_n12 |
| POSTHOOK: Input: default@view1_n0 |
| #### A masked pattern was here #### |
| PREHOOK: query: Drop view view1_n0 |
| PREHOOK: type: DROPVIEW |
| PREHOOK: Input: default@view1_n0 |
| PREHOOK: Output: default@view1_n0 |
| POSTHOOK: query: Drop view view1_n0 |
| POSTHOOK: type: DROPVIEW |
| POSTHOOK: Input: default@view1_n0 |
| POSTHOOK: Output: default@view1_n0 |
| PREHOOK: query: drop table table1_n12 |
| PREHOOK: type: DROPTABLE |
| PREHOOK: Input: default@table1_n12 |
| PREHOOK: Output: default@table1_n12 |
| POSTHOOK: query: drop table table1_n12 |
| POSTHOOK: type: DROPTABLE |
| POSTHOOK: Input: default@table1_n12 |
| POSTHOOK: Output: default@table1_n12 |