CREATE.. TABLE...LIKE should propagate current owner: -----------------------------------------------------
Key: HIVE-2268 URL: https://issues.apache.org/jira/browse/HIVE-2268 Project: Hive Issue Type: Bug Components: Metastore Affects Versions: 0.7.1, 0.7.0, 0.8.0 Reporter: Esteban Gutierrez -- alice creates table CREATE EXTERNAL TABLE foo(bar double) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' STORED AS TEXTFILE LOCATION '/user/alice/foo'; -- table owner is alice as expected hive> DESCRIBE EXTENDED foo; OK bar double Detailed Table Information Table(tableName:foo, dbName:default, {color:red} owner:alice {color}, createTime:1309996190, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:bar, type:double, comment:null)], location:hdfs://localhost/user/alice/foo, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=,, field.delim=,, line.delim= }), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{EXTERNAL=TRUE, transient_lastDdlTime=1309996190}, viewOriginalText:null, viewExpandedText:null, tableType:EXTERNAL_TABLE) -- bob calls CREATE..TABLE..LIKE CREATE TABLE foo_like LIKE foo; -- bob created a new table using like but the owner stills alice -- but the expected is owner:bob hive> DESCRIBE EXTENDED foo_like; OK bar double Detailed Table Information Table(tableName:foo_like, dbName:default, {color:red} owner:alice {color}, createTime:1309996554, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:bar, type:double, comment:null)], location:hdfs://localhost/user/hive/warehouse/foo_like, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=,, field.delim=,, line.delim= }), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1309996554}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE) -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira