ERROR: Dist auto table is not supported.

0

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?

cpl928
asked 5 years ago190 views
5 Answers
0
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.

answered 5 years ago
0

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.

Toebs2
answered 5 years ago
0

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

cpl928
answered 5 years ago
0

Yes.

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

Toebs2
answered 5 years ago
0

DISTSTYLE AUTO is now fully enabled in all regions.

answered 5 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions