Cannot use meta function or non-deterministic function in SEGMENTED BY expression
Hi,
Im trying to create a table from a view with CTAS syntax but it gives me the following error "Cannot use meta function or non-deterministic function in SEGMENTED BY expression"
CREATE OR REPLACE VIEW business_facts.vw_adjustSignups AS
select A.*
, DENSE_RANK() OVER(PARTITION BY USERID, DECODE(UPPER (s.shopCountry), 'AT', 'DE', UPPER (s.shopCountry)) ORDER BY S.TIME) SIGNUPIX
FROM raw.s3_events_signup_all s
WHERE USERID IS NOT NULL;
create table adjustSignups as
select some_seq.nextval id, a.* from vw_adjustSignups a;
My vertica version is Vertica Analytic Database v7.0.2-1
the error is on the analytic function and I tried ti changed the function to rank() and row_number() but the same error happens.
Now when i create the table before and just make an insert statment then it's ok
insert into business_facts.adjustSignups
SELECT business_facts.s3_signupid_seq.nextval signupID
, i.*
FROM business_facts.vw_adjustSignups i ;
I was wandering why is giving me that error?
Regards
Sokol
0