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달 전
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