![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Wed, 27 Mar 2013 @ 10:18:04 GMT
Subj: | | Fields on which Partitioned is collected |
|
From: | | Mani, Vijay |
Hi,
Below is my table layout.
CREATE MULTISET TABLE Table1 ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT,
DEFAULT MERGEBLOCKRATIO
(
Field1 DATE FORMAT 'yyyy-mm-dd' NOT NULL,
Field2 DECIMAL(18,0) NOT NULL)
PRIMARY INDEX pi1(Field2)
PARTITION BY RANGE_N(Field1 BETWEEN '2011-06-01' AND '2013-12-31' EACH INTERVAL '1' DAY );
Is there any dbc tables from which I can get the field (Field1) on which the partition range is defined ?
Thanks,
Vijay Mani
| |