CREATE TABLE Fasiled 3706: syntax error: expected something between the word 'a' and '.'.

Analytics
Enthusiast

CREATE TABLE Fasiled 3706: syntax error: expected something between the word 'a' and '.'.

Hi All,

 

Trying to run the sql code below -

Format:HTML Format Version:1.0 StartHTML: 165 EndHTML: 5554 StartFragment: 314 EndFragment: 5522 StartSelection: 314 EndSelection: 314SyntaxEditor Code Snippet

CREATE MULTISET TABLE NRR_XBUY_4 AS(SELECT a.Delv_Month, a.alloc_id, CAST(b.Total_Bookings AS DEC(15,6)) / CAST(a.Total_Dlv AS DEC(15,6)) * 100 *100 AS NRR_XBUY
FROM
Total_Delivered a
Inner Join
Total_Bookings b
ON a.alloc_id = b.booking_lob
and a.Delv_Month = b.Delv_Month
Group by 1,2) WITH DATA PRIMARY INDEX(a.Delv_Month);

Error Message: CREATE TABLE Fasiled 3706: syntax error: expected something between the word 'a' and '.'.
1 REPLY
Teradata Employee

Re: CREATE TABLE Fasiled 3706: syntax error: expected something between the word 'a' and '.'.

A table name is not allowed on the column name in the INDEX definition. Only the column name.