[Hive] Creating Multiple Tables from Another Table

less than 1 minute read

Creating Multiple Tables from Another Table

-- multiinsert(from one table to more than 2 tables)
create table if not exists england (
	col1 int, 
	col3 string,
	col4 int
);

create table if not exists wales (
	col1 int, 
	col3 string,
	col4 int
);


from table2 
insert into table england select col1, col3, col4 where col3='England' 
insert into table wales select col1,col3,col4 where col3='Wales';