Teradata "Period" data type triggering error

Asked Aug 15 '16 at 20:06

Active Aug 16 '16 at 16:09

Viewed 111 times

I just downloaded the TDExpress VM, and when I try to create tables with a column that has a period data type (for example period(date)), I get an error that says "an index is not supported by the period column"...however according to this link it is supported, and the correct syntax.

I get the same error if i include the precision or not (in the case of period(time)).

edit : DDL-

CREATE TABLE test ( value1 int null, timePer period(date) null );

edited Aug 16 '16 at 16:09

asked Aug 15 '16 at 20:06

Jacob Alley

Please post your DDL. – Andrew Aug 15 '16 at 20:38
Did you create a table with a Period as first column and didn't specify the Primary Index? Then it defaults to the first column and Period's can't be indexed. – dnoeth Aug 15 '16 at 21:05
I didnt specify a primary index but it was after an int. It was something like: CREATE TABLE test ( value1 integer null, timePer period(date) null ) – Jacob Alley Aug 16 '16 at 14:10
Your Create looks fine, this should run without error. – dnoeth Aug 16 '16 at 16:17

Teradata "Period" data type triggering error

0 Answers0