Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Table vs View


Copy link to this message
-
Re: Table vs View
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 <[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?
>
> Peter
>

--
Nitin Pawar