PREHOOK: query: drop view v PREHOOK: type: DROPVIEW POSTHOOK: query: drop view v POSTHOOK: type: DROPVIEW PREHOOK: query: create view v as select * from srcpart PREHOOK: type: CREATEVIEW PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-18-48_459_8863944425018360291/-mr-10000 POSTHOOK: query: create view v as select * from srcpart POSTHOOK: type: CREATEVIEW POSTHOOK: Output: default@v POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-18-48_459_8863944425018360291/-mr-10000 PREHOOK: query: describe formatted v PREHOOK: type: DESCTABLE POSTHOOK: query: describe formatted v POSTHOOK: type: DESCTABLE # col_name data_type comment key string None value string None ds string None hr string None # Detailed Table Information Database: default Owner: salbiz CreateTime: Mon Aug 01 13:18:48 PDT 2011 LastAccessTime: UNKNOWN Protect Mode: None Retention: 0 Table Type: VIRTUAL_VIEW Table Parameters: transient_lastDdlTime 1312229928 # Storage Information SerDe Library: null InputFormat: org.apache.hadoop.mapred.SequenceFileInputFormat OutputFormat: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat Compressed: No Num Buckets: -1 Bucket Columns: [] Sort Columns: [] # View Information View Original Text: select * from srcpart View Expanded Text: select `srcpart`.`key`, `srcpart`.`value`, `srcpart`.`ds`, `srcpart`.`hr` from `srcpart` PREHOOK: query: -- modifying definition of unpartitioned view create or replace view v partitioned on (ds, hr) as select * from srcpart PREHOOK: type: CREATEVIEW PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-18-48_577_8276668796293491021/-mr-10000 POSTHOOK: query: -- modifying definition of unpartitioned view create or replace view v partitioned on (ds, hr) as select * from srcpart POSTHOOK: type: CREATEVIEW POSTHOOK: Output: default@v POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-18-48_577_8276668796293491021/-mr-10000 PREHOOK: query: alter view v add partition (ds='2008-04-08',hr='11') PREHOOK: type: ALTERTABLE_ADDPARTS PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 PREHOOK: Input: default@v POSTHOOK: query: alter view v add partition (ds='2008-04-08',hr='11') POSTHOOK: type: ALTERTABLE_ADDPARTS POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 POSTHOOK: Input: default@v POSTHOOK: Output: default@v@ds=2008-04-08/hr=11 PREHOOK: query: alter view v add partition (ds='2008-04-08',hr='12') PREHOOK: type: ALTERTABLE_ADDPARTS PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 PREHOOK: Input: default@v POSTHOOK: query: alter view v add partition (ds='2008-04-08',hr='12') POSTHOOK: type: ALTERTABLE_ADDPARTS POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 POSTHOOK: Input: default@v POSTHOOK: Output: default@v@ds=2008-04-08/hr=12 PREHOOK: query: select * from v where value='val_409' and ds='2008-04-08' and hr='11' PREHOOK: type: QUERY PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-18-48_962_3363144480244368033/-mr-10000 POSTHOOK: query: select * from v where value='val_409' and ds='2008-04-08' and hr='11' POSTHOOK: type: QUERY POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-18-48_962_3363144480244368033/-mr-10000 409 val_409 2008-04-08 11 409 val_409 2008-04-08 11 409 val_409 2008-04-08 11 PREHOOK: query: describe formatted v PREHOOK: type: DESCTABLE POSTHOOK: query: describe formatted v POSTHOOK: type: DESCTABLE # col_name data_type comment key string None value string None # Partition Information # col_name data_type comment ds string None hr string None # Detailed Table Information Database: default Owner: salbiz CreateTime: Mon Aug 01 13:18:48 PDT 2011 LastAccessTime: UNKNOWN Protect Mode: None Retention: 0 Table Type: VIRTUAL_VIEW Table Parameters: transient_lastDdlTime 1312229928 # Storage Information SerDe Library: null InputFormat: org.apache.hadoop.mapred.SequenceFileInputFormat OutputFormat: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat Compressed: No Num Buckets: -1 Bucket Columns: [] Sort Columns: [] # View Information View Original Text: select * from srcpart View Expanded Text: select `srcpart`.`key`, `srcpart`.`value`, `srcpart`.`ds`, `srcpart`.`hr` from `srcpart` PREHOOK: query: show partitions v PREHOOK: type: SHOWPARTITIONS POSTHOOK: query: show partitions v POSTHOOK: type: SHOWPARTITIONS ds=2008-04-08/hr=11 ds=2008-04-08/hr=12 PREHOOK: query: -- altering partitioned view 1 create or replace view v partitioned on (ds, hr) as select value, ds, hr from srcpart PREHOOK: type: CREATEVIEW PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-18-52_062_767516020030392810/-mr-10000 POSTHOOK: query: -- altering partitioned view 1 create or replace view v partitioned on (ds, hr) as select value, ds, hr from srcpart POSTHOOK: type: CREATEVIEW POSTHOOK: Output: default@v POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-18-52_062_767516020030392810/-mr-10000 PREHOOK: query: select * from v where value='val_409' and ds='2008-04-08' and hr='11' PREHOOK: type: QUERY PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-18-52_118_4756632495796303928/-mr-10000 POSTHOOK: query: select * from v where value='val_409' and ds='2008-04-08' and hr='11' POSTHOOK: type: QUERY POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-18-52_118_4756632495796303928/-mr-10000 val_409 2008-04-08 11 val_409 2008-04-08 11 val_409 2008-04-08 11 PREHOOK: query: describe formatted v PREHOOK: type: DESCTABLE POSTHOOK: query: describe formatted v POSTHOOK: type: DESCTABLE # col_name data_type comment value string None # Partition Information # col_name data_type comment ds string None hr string None # Detailed Table Information Database: default Owner: salbiz CreateTime: Mon Aug 01 13:18:48 PDT 2011 LastAccessTime: UNKNOWN Protect Mode: None Retention: 0 Table Type: VIRTUAL_VIEW Table Parameters: transient_lastDdlTime 1312229932 # Storage Information SerDe Library: null InputFormat: org.apache.hadoop.mapred.SequenceFileInputFormat OutputFormat: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat Compressed: No Num Buckets: -1 Bucket Columns: [] Sort Columns: [] # View Information View Original Text: select value, ds, hr from srcpart View Expanded Text: select `srcpart`.`value`, `srcpart`.`ds`, `srcpart`.`hr` from `srcpart` PREHOOK: query: show partitions v PREHOOK: type: SHOWPARTITIONS POSTHOOK: query: show partitions v POSTHOOK: type: SHOWPARTITIONS ds=2008-04-08/hr=11 ds=2008-04-08/hr=12 PREHOOK: query: -- altering partitioned view 2 create or replace view v partitioned on (ds, hr) as select key, value, ds, hr from srcpart PREHOOK: type: CREATEVIEW PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-18-55_240_6937978698463164642/-mr-10000 POSTHOOK: query: -- altering partitioned view 2 create or replace view v partitioned on (ds, hr) as select key, value, ds, hr from srcpart POSTHOOK: type: CREATEVIEW POSTHOOK: Output: default@v POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-18-55_240_6937978698463164642/-mr-10000 PREHOOK: query: select * from v where value='val_409' and ds='2008-04-08' and hr='11' PREHOOK: type: QUERY PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-18-55_292_2125979258209260060/-mr-10000 POSTHOOK: query: select * from v where value='val_409' and ds='2008-04-08' and hr='11' POSTHOOK: type: QUERY POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-18-55_292_2125979258209260060/-mr-10000 409 val_409 2008-04-08 11 409 val_409 2008-04-08 11 409 val_409 2008-04-08 11 PREHOOK: query: describe formatted v PREHOOK: type: DESCTABLE POSTHOOK: query: describe formatted v POSTHOOK: type: DESCTABLE # col_name data_type comment key string None value string None # Partition Information # col_name data_type comment ds string None hr string None # Detailed Table Information Database: default Owner: salbiz CreateTime: Mon Aug 01 13:18:48 PDT 2011 LastAccessTime: UNKNOWN Protect Mode: None Retention: 0 Table Type: VIRTUAL_VIEW Table Parameters: transient_lastDdlTime 1312229935 # Storage Information SerDe Library: null InputFormat: org.apache.hadoop.mapred.SequenceFileInputFormat OutputFormat: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat Compressed: No Num Buckets: -1 Bucket Columns: [] Sort Columns: [] # View Information View Original Text: select key, value, ds, hr from srcpart View Expanded Text: select `srcpart`.`key`, `srcpart`.`value`, `srcpart`.`ds`, `srcpart`.`hr` from `srcpart` PREHOOK: query: show partitions v PREHOOK: type: SHOWPARTITIONS POSTHOOK: query: show partitions v POSTHOOK: type: SHOWPARTITIONS ds=2008-04-08/hr=11 ds=2008-04-08/hr=12 PREHOOK: query: drop view v PREHOOK: type: DROPVIEW PREHOOK: Input: default@v PREHOOK: Output: default@v POSTHOOK: query: drop view v POSTHOOK: type: DROPVIEW POSTHOOK: Input: default@v POSTHOOK: Output: default@v PREHOOK: query: -- updating to fix view with invalid definition create table srcpart_temp like srcpart PREHOOK: type: CREATETABLE POSTHOOK: query: -- updating to fix view with invalid definition create table srcpart_temp like srcpart POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@srcpart_temp PREHOOK: query: create view v partitioned on (ds, hr) as select * from srcpart_temp PREHOOK: type: CREATEVIEW PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-18-58_553_1250088755088975045/-mr-10000 POSTHOOK: query: create view v partitioned on (ds, hr) as select * from srcpart_temp POSTHOOK: type: CREATEVIEW POSTHOOK: Output: default@v POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-18-58_553_1250088755088975045/-mr-10000 PREHOOK: query: drop table srcpart_temp PREHOOK: type: DROPTABLE PREHOOK: Input: default@srcpart_temp PREHOOK: Output: default@srcpart_temp POSTHOOK: query: drop table srcpart_temp POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@srcpart_temp POSTHOOK: Output: default@srcpart_temp PREHOOK: query: -- v is now invalid create or replace view v partitioned on (ds, hr) as select * from srcpart PREHOOK: type: CREATEVIEW PREHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-18-58_663_3867562912120990708/-mr-10000 POSTHOOK: query: -- v is now invalid create or replace view v partitioned on (ds, hr) as select * from srcpart POSTHOOK: type: CREATEVIEW POSTHOOK: Output: default@v POSTHOOK: Output: file:/tmp/salbiz/hive_2011-08-01_13-18-58_663_3867562912120990708/-mr-10000 PREHOOK: query: describe formatted v PREHOOK: type: DESCTABLE POSTHOOK: query: describe formatted v POSTHOOK: type: DESCTABLE # col_name data_type comment key string None value string None # Partition Information # col_name data_type comment ds string None hr string None # Detailed Table Information Database: default Owner: salbiz CreateTime: Mon Aug 01 13:18:58 PDT 2011 LastAccessTime: UNKNOWN Protect Mode: None Retention: 0 Table Type: VIRTUAL_VIEW Table Parameters: transient_lastDdlTime 1312229938 # Storage Information SerDe Library: null InputFormat: org.apache.hadoop.mapred.SequenceFileInputFormat OutputFormat: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat Compressed: No Num Buckets: -1 Bucket Columns: [] Sort Columns: [] # View Information View Original Text: select * from srcpart View Expanded Text: select `srcpart`.`key`, `srcpart`.`value`, `srcpart`.`ds`, `srcpart`.`hr` from `srcpart` PREHOOK: query: drop view v PREHOOK: type: DROPVIEW PREHOOK: Input: default@v PREHOOK: Output: default@v POSTHOOK: query: drop view v POSTHOOK: type: DROPVIEW POSTHOOK: Input: default@v POSTHOOK: Output: default@v