ERROR: insufficient information to determine the distribution key

Teradata Studio
N/A

ERROR: insufficient information to determine the distribution key

Hi,

i am facing below error while creating a table using "create table" statement.

Executed as Single statement.  Failed [34 : HY000] [AsterData][ASTERJDBCDSII](34) ERROR: insufficient information to determine the distribution key ()

Please help in resolving the error.

i am using teradata studio 14.10.

Regards,

kk

1 REPLY
Teradata Employee

Re: ERROR: insufficient information to determine the distribution key

kk, What type of table are you creating, FACT or DIMENSION? Please refer to the Aster Database User Guide, section Distribution Keys and Rules for distribution keys that might help. The document is on the Teradata Information Products web site (http://www.info.teradata.com/AsterData/eBrowseBy.cfm). You could also post your question to the Aster Forum.