The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

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

 

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.