All Forums Teradata Studio
munik 1 post Joined 04/14
24 Apr 2014
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
 

fgrimmer 553 posts Joined 04/09
24 Apr 2014

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.

You must sign in to leave a comment.