All Forums General
bmani 6 posts Joined 10/13
10 May 2014
Column partitioning in Teradata 13.10

Does Teradata 13.10 support column partitioning? I ran the following test table and it failed. If it doesnt support is there an alternative?
 

CREATE TABLE Sales_CP (

    TxnNo INTEGER,

    TxnDate DATE,

    ItemNo INTEGER,

    Quantity INTEGER )

  PARTITION BY COLUMN,

  UNIQUE INDEX (TxnNo);

Raja_KT 1246 posts Joined 07/09
11 May 2014

Teradata columnar is introduced in  TD DB 14.0. So you need TD  DB 14.0.

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.