How To replace view : too long view_definition

yamakawayamakawa Vertica Customer

Please tell me how to fix it.
1. Create View
CREATE VIEW public.VIEW_A AS SELET col1 as COLUMN1, ,,, col1000 AS COLUMN1000 FROM public.TABLE_A WHERE col1='20200801';
2. select views
SELECT * FROM v_catalog.views where table_name='VIEW_A';
-> The definition is too long and is interrupted in the middle.

To replace view, I want to get view_definition from views.(And replace where condition)
But can't.

We await answers from the experts.

Best Answer

Leave a Comment

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