ALTER TABLE Failed [9478] Table must be column partitioned

Database

ALTER TABLE Failed [9478] Table must be column partitioned

Hello everyone, I am trying to change the datatype of a column.

My statment: 

ALTER TABLE DWBATCHDEV.DBQLSTEPTBL_HST

ADD COLUMN  (StepStartTime TIMESTAMP(6) FORMAT 'YYYY-MM-DDBHH:MI:SS.S(F)Z');

Not sure how teradata works when it comes to chagning the datatype, but I get the error "ALTER TABLE Failed [9478] Table must be column partitioned "

I am going to create a new table.

1 REPLY
Junior Contributor

Re: ALTER TABLE Failed [9478] Table must be column partitioned

Remove the COLUMN, your query is trying to add a column to a columnar table.

Dieter