-Re: Table vs View
Nitin Pawar 2013-05-06, 18:45
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
On Tue, May 7, 2013 at 12:09 AM, Peter Chu <[EMAIL PROTECTED]> 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?