The article describe how the view definition is stored in catalog
Environment
Vertica Version 10.1.0-2
Situation
When querying the view_definition table for a view, the view_definition is stored in a different way, the WITH clause is replaced by subquery
dbadmin=> select table_name, view_definition from views where table_name = 'cte';table_name | view_definition------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------cte | SELECT tmptable1.id, tmptable1.name FROM (SELECT t1.id, t1.name FROM public.t1) tmptable1 UNION SELECT tmptable2.id, tmptable2.name FROM (SELECT t2.id, t2.name FROM public.t2) tmptable2
