Options

Updated Views

miiclaudiamiiclaudia Community Edition User
in General Discussion

Hi All
I have an issue in the views when i trying to do an updated in one view. My wish is include two columns more in one view but is too impossible and the data point send me error.


Thanks in advanced

Tagged:

Answers

  • Options
    SruthiASruthiA Vertica Employee Administrator

    @miiclaudia : you cannot update the view. you need to drop it and recreate view by adding 2 columns that you want to add.

  • Options
    Jim_KnicelyJim_Knicely - Select Field - Administrator

    Can't you do a CREATE OR REPLACE VIEW?

  • Options
    miiclaudiamiiclaudia Community Edition User

    Dear Jim, the case is not permit include the new two fields in Create or replace view. =(

  • Options
    Jim_KnicelyJim_Knicely - Select Field - Administrator
    edited July 2021

    @miiclaudia - Not sure what you mean. Do you not have the database privileges to run a CREATE OR REPLACE VIEW?

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...