Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
split rows bug
CREATE TABLE rank_exc(
id int,
year int,
gender char(1)
)
DISTRIBUTED BY (id)
PARTITION BY LIST (gender)
SUBPARTITION BY RANGE (year)
SUBPARTITION TEMPLATE (
SUBPARTITION year1 START (2001),
SUBPARTITION year6 START (2006) END (2007) )
(PARTITION girls VALUES ('F'),
PARTITION boys VALUES ('M')
);
alter table rank_exc alter partition boys add default partition bfuture;
insert into rank_exc values(2, 2, 2008, 'M', 3);
alter table rank_exc alter partition boys split default partition start ('2007')
end ('2008') into (partition bfuture, partition year7);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment