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
質問済み 5年前207ビュー
5回答
0
承認された回答

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.

回答済み 5年前
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
回答済み 5年前
0

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

cpl928
回答済み 5年前
0

Yes.

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

Toebs2
回答済み 5年前
0

DISTSTYLE AUTO is now fully enabled in all regions.

回答済み 5年前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ