RE: Table vs View

2013-05-06 Thread Connell, Chuck
I am not sure about speed, but my understanding is that tables are real things, they exist as files on disk and can be reused. Views are temporary entities that are created on-the-fly and cannot be reused later. Chuck From: Peter Chu [mailto:pete@outlook.com] Sent: Monday, May 06, 2013 2:4

Re: Table vs View

2013-05-06 Thread Nitin Pawar
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 tabl