#DateWhereItemComment
3922 Jan 2016 @ 11:11 PSTPaul Sinclair's Blog on PartitioningTeradata ColumnarCPPA and CPPI require Teradata 15.10. CPNoPI was available starting in Teradata 14.0. CP may require a license and to be enabled by a support representative in order to use it. If you...
3818 Jan 2016 @ 04:32 PSTPaul Sinclair's Blog on PartitioningTeradata ColumnarFrom a user point of view, either way ends up doing the same thing. The differences are subtle differences in performance due to the way the values are ordered in combination with how data is ...
3718 Jan 2016 @ 12:23 PSTPaul Sinclair's Blog on PartitioningTeradata ColumnarTable rows are not sorted by rowid since when dealing with rowids in a CP table, we are talking about the ordering of column partition values by rowid (or in your case with single-column ...
3618 Jan 2016 @ 09:56 PSTPaul Sinclair's Blog on PartitioningTeradata Columnarselect * from CPPA table where PA_COLUMN='x';   For a row-partitioned or non-row-partitioned CPPA table (assuming PA_COLUMN is not also a partitioning column), Teradata performs...
3517 Jan 2016 @ 06:31 PSTPaul Sinclair's Blog on PartitioningTeradata Columnar1. Does this mean that if there are 2 table rows with the same PA value and the table is column partitioned on the PA column alone with column format, the 2 values may not necessarily share consecu...
3415 Jan 2016 @ 07:10 PSTPaul Sinclair's Blog on PartitioningTeradata ColumnarSuhail, glad to hear from you again and your interest in CPPA. I'll try to answer your questions (plus a little bit more) in the following: 1. If we have a CPPA table, how are the rows on...
3315 Jan 2016 @ 04:34 PSTPaul Sinclair's Blog on PartitioningTeradata ColumnarTeradata 15.10 introduces column partitioning with a primary index (CPPI) and with a primary AMP index (CPPA). A primary AMP index can be thought of as being halfway between a PI and NoPI -- r...
3212 Apr 2015 @ 08:41 PDTPaul Sinclair's Blog on PartitioningTD 14.0 - The other partitioning enhancementsI submitted a DR (defect report) for this.  If you submit an incident on above, please refer to DR 176856 "Incorrect information in DBC.TableConstraints table for partitioning."
3112 Apr 2015 @ 08:19 PDTPaul Sinclair's Blog on PartitioningTD 14.0 - The other partitioning enhancementsI think you found a defect. It should be 132 (not 144 or 65535) since eleven months were added (or if you actually altered to 31-12-2016 instead of 31-12-2015, then 144). Also, when I checked on 14...
3005 Dec 2014 @ 02:37 PSTPaul Sinclair's Blog on PartitioningTD 14.0 - The other partitioning enhancements1. Does anyone have an explanation about this behaviour? In order to get static partition elimination, there needs to be constant conditions on the partitioning columns. This could be explicit ...
2915 Oct 2014 @ 12:02 PDTPaul Sinclair's Blog on PartitioningWhy no primary index (NoPI) for a Column-Partitioned Table?Hope to see you at Partners Conference next week!
2815 Oct 2014 @ 12:00 PDTPaul Sinclair's Blog on PartitioningWhy no primary index (NoPI) for a Column-Partitioned Table?Good question. This can benefit from some clarification. I was using join method to mean the method used in a join step (for example, merge join, nested join, sliding-window join, hash join, produ...
2730 Aug 2014 @ 03:28 PDTPaul Sinclair's Blog on PartitioningTD 14.0 - The other partitioning enhancementsI wish I could provide such information but until there is an officical announcement of a release and its content and since release content is subject to change, I am unable to provide th...
2625 Aug 2014 @ 03:10 PDTPaul Sinclair's Blog on PartitioningTD 14.0 - The other partitioning enhancementsTimestamp partitioning works with nonequality conditions in 14.0 with constants but not with CURRENT_TIMESTAMP. Prior to Teradaata 12.0, this was also true for date partitioning and the CURRENT_DAT...
2514 Apr 2014 @ 12:22 PDTPaul Sinclair's Blog on PartitioningWhy no primary index (NoPI) for a Column-Partitioned Table?1. Is my table going to be skewed?   Probably (after you fix the syntax errors) but depends on your system's setting for PrimaryIndexDefault.   2. So will my table2 have no issu...
2411 Dec 2013 @ 12:31 PSTPaul Sinclair's Blog on Partitioning9.2 Quintillion? What's that all about?For more about the ADD option, see my blog entry http://developer.teradata.com/blog/paulsinclair/2012/07/td-14-0-the-other-partitioning-enhancements
2310 Dec 2013 @ 09:58 PSTPaul Sinclair's Blog on Partitioning9.2 Quintillion? What's that all about?Dear Suhail, You are correct when the table is not empty (which is normally the case). But note that if the table is empty you can alter it. Also, note that if you define a table with a number pa...
2208 Oct 2013 @ 12:45 PDTPaul Sinclair's Blog on PartitioningTD 14.0 - The other partitioning enhancementsIf all the values are unique for the column (or set of columns), you can create a USI on the NUPI column (or the columns of the NUPI) even if the column (or set of columns) is defined as ...
2123 Sep 2013 @ 05:23 PDTPaul Sinclair's Blog on PartitioningTeradata ColumnarSuhail, thanks for the questions. I'll try to answer them: 1. Why do we achieve better compression if we have the column partition in COLUMN format vs. storing it in ROW format? Whether bette...
2028 Jul 2013 @ 05:49 PDTPaul Sinclair's Blog on PartitioningTeradata ColumnarHow is TD14 columnar storage configured? Is it something available intrinsically or do we need to get special hardware from Teradata to make use of this feature? This is a software feature of Tera...
1907 Jun 2013 @ 10:33 PDTPaul Sinclair's Blog on PartitioningTD 14.0 - The other partitioning enhancementsStored procedure question: I would suggest that you please post this type of question in the Database forum -- http://forums.teradata.com/forum/database -- where the question and answers may g...
1814 May 2013 @ 11:35 PDTPaul Sinclair's Blog on PartitioningTD 14.0 - The other partitioning enhancementsIn order to ensure consistent evaluation of character partitioning expressions, the internal DBSControl field AcceptReplacementCharacters must be FALSE when doing character partition elimination.&n...
1714 May 2013 @ 09:19 PDTPaul Sinclair's Blog on PartitioningTeradata ColumnarWhy the columnar is not allowed on PI tables? What is the reason/logic behind this? There is a discussion about this in the blog entry http://developer.teradata.com/blog/paulsinclair/2011/10/...
1624 Apr 2013 @ 10:32 PDTPaul Sinclair's Blog on PartitioningTD 14.0 - The other partitioning enhancementsYou also may want to check if DBS Control internal flag AcceptReplacementCharacters has been turned on; if it is turned on, this disables character partition elimination. The Ch...
1524 Apr 2013 @ 04:27 PDTPaul Sinclair's Blog on PartitioningTD 14.0 - The other partitioning enhancementsYou also want to check with your system administrators if CharPE has been disabled on your system via the DBS Control internal flag:   157.  DisableCharPE

Pages