Saving all output to "!!{outputDirectory}!!/alter_view_rename.q.raw". Enter "record" with no arguments to stop it. >>> !run !!{qFileDirectory}!!/alter_view_rename.q >>> CREATE TABLE invites (foo INT, bar STRING) PARTITIONED BY (ds STRING); No rows affected >>> CREATE VIEW view1 as SELECT * FROM invites; 'foo','bar','ds' No rows selected >>> DESCRIBE EXTENDED view1; 'col_name','data_type','comment' 'foo','int','' 'bar','string','' 'ds','string','' '','','' 'Detailed Table Information','Table(tableName:view1, dbName:alter_view_rename, owner:!!{user.name}!!, createTime:!!UNIXTIME!!, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:foo, type:int, comment:null), FieldSchema(name:bar, type:string, comment:null), FieldSchema(name:ds, type:string, comment:null)], location:null, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:null, parameters:{}), bucketCols:[], sortCols:[], parameters:{}, skewedInfo:SkewedInfo(skewedColNames:[], skewedColValues:[], skewedColValueLocationMaps:{})), partitionKeys:[], parameters:{transient_lastDdlTime=!!UNIXTIME!!}, viewOriginalText:SELECT * FROM invites, viewExpandedText:SELECT `invites`.`foo`, `invites`.`bar`, `invites`.`ds` FROM `alter_view_rename`.`invites`, tableType:VIRTUAL_VIEW)','' 5 rows selected >>> >>> ALTER VIEW view1 RENAME TO view2; No rows affected >>> DESCRIBE EXTENDED view2; 'col_name','data_type','comment' 'foo','int','' 'bar','string','' 'ds','string','' '','','' 'Detailed Table Information','Table(tableName:view2, dbName:alter_view_rename, owner:!!{user.name}!!, createTime:!!UNIXTIME!!, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:foo, type:int, comment:null), FieldSchema(name:bar, type:string, comment:null), FieldSchema(name:ds, type:string, comment:null)], location:null, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:null, parameters:{}), bucketCols:[], sortCols:[], parameters:{}, skewedInfo:SkewedInfo(skewedColNames:[], skewedColValues:[], skewedColValueLocationMaps:{})), partitionKeys:[], parameters:{last_modified_by=!!ELIDED!!, last_modified_time=!!UNIXTIME!!, transient_lastDdlTime=!!UNIXTIME!!}, viewOriginalText:SELECT * FROM invites, viewExpandedText:SELECT `invites`.`foo`, `invites`.`bar`, `invites`.`ds` FROM `alter_view_rename`.`invites`, tableType:VIRTUAL_VIEW)','' 5 rows selected >>> SELECT * FROM view2; 'foo','bar','ds' No rows selected >>> >>> DROP TABLE invites; No rows affected >>> DROP VIEW view2; No rows affected >>> !record