set hive.cbo.enable=true;

DROP TABLE insert_into1;
DROP TABLE ctas_table;
DROP TABLE ctas_part;

CREATE TABLE insert_into1 (key int, value string);

INSERT OVERWRITE TABLE insert_into1 SELECT * from src ORDER BY key LIMIT 10;

select * from insert_into1 order by key;

INSERT INTO TABLE insert_into1 SELECT * from src ORDER BY key DESC LIMIT 10;

select * from insert_into1 order by key;

create table ctas_table as SELECT key, count(value) as foo from src GROUP BY key LIMIT 10;

describe extended ctas_table;

select * from ctas_table order by key;


set hive.exec.dynamic.partition=true;
SET hive.exec.dynamic.partition.mode=nonstrict;

create table ctas_part (key int, value string) partitioned by (modkey bigint);

insert overwrite table ctas_part partition (modkey) 
select key, value, ceil(key / 100) from src where key is not null limit 10;

select * from ctas_part order by key;



DROP TABLE insert_into1;
DROP TABLE ctas_table;
DROP TABLE ctas_part;