Create Partitioned Table As the Result of a Query
create table MY_TABLE
PARTITION BY RANGE(D_TIME_CODE)
(PARTITION D_TIME_CODE VALUES LESS THAN ('20100901'),
PARTITION D_TIME_CODE_2 VALUES LESS THAN ('20150901'))
as select * from myQuery;