Unable to Create a Columnar Table after upgrading to 14

Database
Enthusiast

Unable to Create a Columnar Table after upgrading to 14

We just upgraded one of our environments from Teradata 13.10 to 14 and not able to create a columnar table. when I try to create one, i get the following error "Column Partitioning is not SUpported on this System". Below is the DDL I am using

Note: Below is a sample SQL that i extracted from one of the posts explaining columnar

CREATE MULTISET TABLE SALES ( TxnNo INTEGER,

TxnDate DATE,

ItemNo INTEGER,

Quantity INTEGER

)

PARTITION BY COLUMN, UNIQUE INDEX (TxnNo);

3 REPLIES
Enthusiast

Re: Unable to Create a Columnar Table after upgrading to 14

Hi,

I  think it is because of licenses, since it is not enabled. There are few features like Temporal, Virtual Storage etc, that need licenses. I am not pretty sure. Maybe you can double check.

Cheers,

Raja

Enthusiast

Re: Unable to Create a Columnar Table after upgrading to 14

Greetings,

You need to have your Teradata CS team turn on columnar.

Enthusiast

Re: Unable to Create a Columnar Table after upgrading to 14

Hi,

I beleive the default DBS control parameter setting for Default Primary Index  is D or P which means the table will be created with first column as NUPI. To have a columnar defined you need to change this setting at session level, or define the table as NOPI explicitly. as the Column partition is allowed only with NOPI table.

Khurram