set hive.support.concurrency=true;
set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;

create database D1;

alter database D1 set dbproperties('test'='yesthisis');

drop database D1;

create table T1_n50(key string, val string) stored as textfile;

create table T2_n31 like T1_n50;

LOAD DATA LOCAL INPATH '../../data/files/T1.txt' INTO TABLE T1_n50;

select * from T1_n50;

create table T3_n11 as select * from T1_n50;

create table T4_n4 (key char(10), val decimal(5,2), b int)
    partitioned by (ds string)
    clustered by (b) into 10 buckets
    stored as orc;

alter table T3_n11 rename to newT3_n11;

alter table T2_n31 set tblproperties ('test'='thisisatest');

alter table T2_n31 set serde 'org.apache.hadoop.hive.ql.io.orc.OrcSerde';
alter table T2_n31 set serdeproperties ('test'='thisisatest');

alter table T2_n31 clustered by (key) into 32 buckets;

alter table T4_n4 add partition (ds='today'); 

alter table T4_n4 partition (ds='today') rename to partition(ds='yesterday');

alter table T4_n4 drop partition (ds='yesterday');

alter table T4_n4 add partition (ds='tomorrow'); 

create table T5_n1 (a string, b int);
alter table T5_n1 set fileformat orc;

create table T7_n2 (a string, b int);
alter table T7_n2 set location 'file:///tmp';
alter table T4_n4 partition (ds='tomorrow') set location 'file:///tmp';

alter table T2_n31 touch;
alter table T4_n4 touch partition (ds='tomorrow');

create view V1_n5 as select key from T1_n50;
alter view V1_n5 set tblproperties ('test'='thisisatest');
drop view V1_n5;


drop table T1_n50;
drop table T2_n31;
drop table newT3_n11;