ql/src/test/queries/clientpositive/alter_rename_table.q

--! qt:dataset:srcpart
--! qt:dataset:src1
--! qt:dataset:src
set hive.mapred.mode=nonstrict;
create database source;
create database target;

create table source.src like default.src;
load data local inpath '../../data/files/kv1.txt' overwrite into table source.src;

create table source.srcpart like default.srcpart;
load data local inpath '../../data/files/kv1.txt' overwrite into table source.srcpart partition (ds='2008-04-08', hr='11');
load data local inpath '../../data/files/kv1.txt' overwrite into table source.srcpart partition (ds='2008-04-08', hr='12');
load data local inpath '../../data/files/kv1.txt' overwrite into table source.srcpart partition (ds='2008-04-09', hr='11');
load data local inpath '../../data/files/kv1.txt' overwrite into table source.srcpart partition (ds='2008-04-09', hr='12');

set hive.fetch.task.conversion=more;

select * from source.src tablesample (10 rows);
select * from source.srcpart tablesample (10 rows);

explain
ALTER TABLE source.src RENAME TO target.src;
ALTER TABLE source.src RENAME TO target.src;

select * from target.src tablesample (10 rows);

explain
ALTER TABLE source.srcpart RENAME TO target.srcpart;
ALTER TABLE source.srcpart RENAME TO target.srcpart;

select * from target.srcpart tablesample (10 rows);

create table source.src like default.src;
create table source.src1 like default.src;
load data local inpath '../../data/files/kv1.txt' overwrite into table source.src;

ALTER TABLE source.src RENAME TO target.src1;
select * from target.src1 tablesample (10 rows);

set metastore.rawstore.batch.size=1;
set metastore.try.direct.sql=false;

create table source.src2 like default.src;
load data local inpath '../../data/files/kv1.txt' overwrite into table source.src2;
ANALYZE TABlE source.src2 COMPUTE STATISTICS FOR COLUMNS;
ALTER TABLE source.src2 RENAME TO target.src3;
DESC FORMATTED target.src3;
select * from target.src3 tablesample (10 rows);