set hive.mapred.mode=nonstrict;
-- SORT_QUERY_RESULTS;


create table studenttab10k_n0 (age2 int);
insert into studenttab10k_n0 values(1);

create table student_acid (age int, grade int)
 clustered by (age) into 1 buckets;

insert into student_acid(age) select * from studenttab10k_n0;

select * from student_acid;

insert into student_acid(grade, age) select 3 g, * from studenttab10k_n0;

select * from student_acid;

insert into student_acid(grade, age) values(20, 2);

insert into student_acid(age) values(22);

select * from student_acid;


drop table if exists acid_partitioned;
create table acid_partitioned (a int, c string)
  partitioned by (p int)
  clustered by (a) into 1 buckets;

insert into acid_partitioned partition (p) (a,p) values(1,2);

select * from acid_partitioned;