Cannot use meta function or non-deterministic function
I'm trying to create table using a select query which has ROW_NUMBER function used to remove duplicate data to load into the new table. However I'm getting below error while table creation-
SQL Error  [0A000]: [Vertica]VJDBC ERROR: Cannot use meta function or non-deterministic function in SEGMENTED BY expression
The issue is occurring only when I'm trying to create the table using the select query however the standalone select query is giving the output, something strange.
Can you guys guide me what I'm missing here? I didn't find much information regarding this error, also there is no timestamp column as well.