CODEWITHSUNDEEP
teradata
Rajat Sharma
Rajat Sharma

Reputation: 19

Can NOPI/Volatile tables in teradata be partitioned on basis of a column?

I wanted to ask if NOPI tables can be portioned on a column in Teradata or not. Also I am assuming that we can partition volatile table as well can anyone conform on both?

Upvotes: 0

Views: 464

Answers (2)

dnoeth
dnoeth

Reputation: 60482

Columnar partitioning is implemented since Teradata 14 and before TD15.10 a Columnar Table must have no Primary Index (i.e. NoPI).

Volatile (& Global Temporary) Tables can be row-partitioned (iirc since TD14), but not Columnar.

But why didn't you simply try it on your own?

Upvotes: 1

L. Kosina
L. Kosina

Reputation: 21

Partitioning means in Teradata Partitioned Primary Index (alias PPI), so when you create table with No Primary Index, it cannot be partitioned. Also I think, it does not make sense to do it. Volatile tablle and Global Temporary tables cannot have PPI.

Upvotes: 0

Related Questions