create table tb_usa_covid(
count_date date,
country string,
state string,
flips string,
cases int,
deaths int
)row format delimited
fields terminated by ',';
select * from tb_usa_covid;
set hive.enforce.bucketing = true;
set mapreduce.job.reduces = 5;
create table tb_usa_covid_buckets(
count_date date,
country string,
state string,
flips string,
cases int,
deaths int
)clustered by (state) into 5 buckets
row format delimited
fields terminated by ',';
insert into tb_usa_covid_buckets select * from tb_usa_covid;