question Re: Hive view definition update in Support Questions

Hive view definition update

HarishS — Fri, 16 Sep 2022 10:56:29 GMT

some of our views are created as "create view {view_name} as select * from {base_table}"

Now, if the base table definition gets updated (by adding new attributes), does hive view definition gets auto updated? Or do we need to recreate the view?

As per documentation from https://cwiki.apache.org/confluence/display/Hive/ViewDev, hive uses Stored view definition. Is this true for Hive version 1.1 as well?

Re: Hive view definition update

saranvisa — Tue, 24 Jan 2017 21:29:53 GMT

@HarishS

Any DML changes will be reflected automatically. But you need to run the below replace command to reflect DDL changes in view

CREATE OR REPLACE VIEW View_Name as query;

Re: Hive view definition update

rajak — Sun, 22 Oct 2017 16:28:57 GMT

If I have 50 users. 10 users are updating and inserting the same base table simultaneusly and 40 users are just querying simultaneously, will there be any locking? How is the concurrency working?

I do not want to turn on the transactional or ACID features. Please let me know.

Thanks,

Raja