1 réponse
- Le plus récent
- Le plus de votes
- La plupart des commentaires
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?
répondu il y a 10 mois
Contenus pertinents
- demandé il y a 2 mois
- demandé il y a un an
- demandé il y a 7 mois
- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a un an
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