Archives of the TeradataForum
Message Posted: Mon, 13 Sep 2010 @ 21:37:21 GMT
| Subj: | | Re: Table partitioning on TIMESTAMP(3) in Teradata 13 |
| |
| From: | | De pons, Paul |
In TD12 this functionality was explicitly turned off (through DBS control parameters) due to potential issues (errant results) when using
different time zones. We had to open a ticket and have CS turn it back on. You might want to try there.
With it turned on your below queries would work but the Partition elimination is limited in functionality: Only being used for static
elimination directly on the column (no joins even if static and no Dynamic elimination through joins or sub-queries). We have requested an effort
to produce enhanced functionality on this, but I agree with another post to avoid Timestamp partitions if possible. Dates work much better. I
believe though that 13.1 has additional Timestamp support for partitioning, though I don't know the details.
Hope this helps, good luck
Paul De Pons
| 
