CPPI question

Database

CPPI question

Hello,

I am trying to add a range to my CPPI column but get this error when I run the alter table statement:

 'Executed as Single statement.  Failed [5731 : HY000] TBL_ADD_PARTITIONS_FOR_PERIOD:DROP RANGE and ADD RANGE for level 1 are not allowed; partitioning expression, if any, at that level is not a RANGE_N function or involves comparison of character or graphic data'

Below are my statements:

CREATE MULTISET TABLE TestTable 

(Column1 varchar(50),

Column2 varchar(250))

PRIMARY INDEX TestTable (Column1)

partition by (range_n(Column2 between 'a' and 'b', NO RANGE ));

Alter Table TestTable Modify PRIMARY INDEX ADD RANGE BETWEEN 'c' and 'd'

I am using version 13.10.

Do you know how I can resolve the above error?

Thanks

Cenk

Tags (1)
1 REPLY
Teradata Employee

Re: CPPI question

Making this change via ALTER is not supported for character PPI.

Create a new table and copy the data.