Why run compute_flextable_keys_and_build_view()?

Moderator: NorbertKrupa

Post Reply
Brett
Beginner
Beginner
Posts: 49
Joined: Fri Oct 11, 2013 1:19 am

Why run compute_flextable_keys_and_build_view()?

Post by Brett » Mon Jan 13, 2014 3:00 pm

What does this message mean when I try to select from a flex table I created?

Code: Select all

dbadmin=> select * from flex_test_view;
                                                            status
------------------------------------------------------------------------------------------------------------------------------
 Please run compute_flextable_keys_and_build_view() to update this view to reflect real and virtual columns in the flex table
(1 row)
Do I need to run this all the time? I thought a view was just a select statement that was executed at run time? Why does it need refreshed?

Post Reply

Return to “New to Vertica”