DROP TABLE IF EXISTS nation;
DROP TABLE IF EXISTS u1_gby;

-- create tables and load data
create external table nation (N_NATIONKEY INT, N_NAME STRING, N_REGIONKEY INT, N_COMMENT STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' STORED AS TEXTFILE LOCATION '/tpch/nation';
create table u1_gby(col1 INT, col2 INT);

insert overwrite table u1_gby select N_REGIONKEY, count(1)
from nation
group by N_REGIONKEY
order by N_REGIONKEY;