1 個回答
- 最新
- 最多得票
- 最多評論
0
I just repro'd this on a dc2 cluster with the following and it worked fine:
create table customer_interleaved (
c_custkey integer not null,
c_name varchar(25) not null,
c_address varchar(25) not null,
c_city varchar(10) not null,
c_nation varchar(15) not null,
c_region varchar(12) not null,
c_phone varchar(15) not null,
c_mktsegment varchar(10) not null)
diststyle all
interleaved sortkey (c_custkey, c_city, c_mktsegment);
insert into customer_interleaved values
(1, 'a','b','c','d','e','f','g');
insert into customer_interleaved values
(2, 'h','i','j','k','l','m','n');
insert into customer_interleaved values
(3, 'o','p','q','r','s','t','u');
vacuum reindex customer_interleaved;
create view interleaver_view as select * from customer_interleaved;
select * from interleaver_view;
can you share the error you're getting when query'ing the view?
已回答 10 個月前
相關內容
- AWS 官方已更新 5 個月前
- AWS 官方已更新 2 年前
- AWS 官方已更新 1 年前
Thanks for the inputs! The script you shared works fine when I create the view in same database. In my case, I have the table in db1 and view in db2 in the same cluster, view creation is successful, but when I try to select * from view, it gives me below error:
SQL Error [XX000]: ERROR: Accessing relation 'customer_interleaved' with interleaved sort keys is not supported.
The node type I am using is ra3.xlplus