ERROR: Dist auto table is not supported.

Question

When I issue a CREATE TABLE with DISTSTYLE AUTO, I receive the error message "ERROR: Dist auto table is not supported." EVEN, KEY, and ALL work as expected. We are on Version 1.0.6145 in us-east-1. How can I use AUTO?

Accepted Answer

It is not yet available in your region but you can try your test again after your next maintenance window to see if it has been enabled for you.   
  
Sorry for the confusion around this, but the feature has been enabled per region separately from the version upgrade to ensure that it can be closely monitored.  
  
We expect the feature to be fully deployed soon and we will add a note in the announcement when it is available in all regions.

Answer

The docs indicate AUTO should work, so you appear to have uncovered a bug.  
  
You can still use AUTO by not specifying a diststyle at all.  The default style, in the absence of a user-specified style, is AUTO.

Answer

If I don't specify a style, the database sets it to EVEN.

Answer

Yes.  
  
This is because (see Joe's post) this functionality is not yet active in your region.

Answer

DISTSTYLE AUTO is now fully enabled in all regions.

ERROR: Dist auto table is not supported.

Contenus pertinents