Good Day This is Cazen
Is there a good way to write dynamic-skewed table?
For example, skewed table has to be set keys properties when create table
CREATE TABLE <T> (SCHEMA) SKEWED BY (keys) ON ('c1', 'c2') [STORED AS
DIRECTORIES];
But, when I need recent 1week data to partitions, and others go ‘etc’ partition
there is no way to write create statement
today=20150906, yymmdd=20150901, 20150902, 20150903, 20150904, 20150905,
20150906, etc
today=20150907, yymmdd=20150902, 20150903, 20150904, 20150905, 20150906,
20150907, etc
I’ve write insert statement like below, but it forked 2stages and using mapper
* 2..so I think it’s not a good idea
FROM table
INSERT - partition(today=‘20150906’, yymmdd) WHERE yummy BETWEEN
‘20150901’ AND ‘20150906'
INSERT - partition(today=‘20150906’, yymmdd=‘etc') WHERE yummy BETWEEN
‘20150901’ AND ‘20150906'
Does any body have a good idea?
Thank you very much.
--
[email protected]
[email protected]
http://www.Cazen.co.kr
