There may be a way to select table_name's from the metastore...if so name
your views like *_view and select for those table names.
Of course if you can query the metastore there's probably an even better
way where you don't have to name you view's anything special, and just
search for a table type
Thank you, but what I need is to list only the views, or conversely,
only the actual tables.
On 07/05/2012 11:14 AM, Bejoy KS wrote:
Hi Stephen
You can see the views as well along with tables using the
Show tables;
command.
--Original Message--
From: Stephen R. Scaffidi
To: user@h
Hi Stephen
You can see the views as well along with tables using the
Show tables;
command.
--Original Message--
From: Stephen R. Scaffidi
To: user@hive.apache.org
ReplyTo: user@hive.apache.org
ReplyTo: sscaff...@tripadvisor.com
Subject: How to list all views
Sent: Jul 5, 2012 20:38
How
