PPI on varchar or char field: Possible?

Database

PPI on varchar or char field: Possible?

Hi,

I was wondering if anyone knows whether we can have a varchar/char field as part of PPI or is that PPI can be bult just on numeric fields?

1 REPLY
Teradata Employee

Re: PPI on varchar or char field: Possible?

Hello,

It can also be done on non-numeric fields such as date but "if the data type for the result of partitioning_expression is not INTEGER, then the system implicitly casts the value to the INTEGER type" (taken from Teradata manual), and it cannot be defined on LOB columns.

Regards,

Adeel