Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

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


+
Peter Chu 2013-05-06, 18:39
Copy link to this message
-
RE: Table vs View
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:[EMAIL PROTECTED]]
Sent: Monday, May 06, 2013 2:40 PM
To: [EMAIL PROTECTED]
Subject: Table vs View

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 2013-05-06, 18:45
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB