![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Fri, 24 Jun 2011 @ 10:09:39 GMT
Subj: | | Re: MLPPI on date field |
|
From: | | Minakshi Swami |
Hi,
Multiply of both partitions(years and months between 1900-01-01 and current)will exceed teradata limit of total no of partition 65535.
To me extract month of each year as a separate column say year_month. Now give case for each 12 month.
Eg.
PARTITION BY ( RANGE_N(
a BETWEEN DATE '1900-01-01' AND '2011-01-01'
EACH INTERVAL 1 year, NO RANGE)
, CASE_N( year_month = 'jan' , year_month = 'feb',etc
, NO CASE, UNKNOWN) )
| |