views  in hive are similar to those in any rdbms schema

normally a view is created to have a well defined interface over
an inconsistently defined table so that modification in the table
definition does not alter the view definition

another use case would be suppose you have 100 columns in a table and you
just want to give grant to 10 columns for an user. views come in picture.

I am not sure on the speed but I did not notice any difference when I used
them


On Tue, May 7, 2013 at 12:09 AM, Peter Chu <pete....@outlook.com> wrote:

> On Hive, I am using lots of tables that builds other tables, sorts of like
> a funnel, funneling data to get the parts I want.
>
> I am wondering what is the advantage to creating views vs creating tables.
>
> Is it faster to use views as compare to tables?
>
> Peter
>



-- 
Nitin Pawar

Reply via email to