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 or some other descriptor. I've not really poked around in the metastore much ... but that's probably where Hive would have to look anyway. Not sure if there are any built in commands for selecting data from the metastore directly like this...other than things like 'show tables' Tim On Thu, Jul 5, 2012 at 10:15 AM, Stephen R. Scaffidi < sscaff...@tripadvisor.com> wrote: > > 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@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 can I list all the views in hive? I can't seem to figure out how to >> do it with HQL. >> >> >> Regards >> Bejoy KS >> >> Sent from handheld, please excuse typos. >> >> > > -- "The whole world is you. Yet you keep thinking there is something else." - Xuefeng Yicun 822-902 A.D. Tim R. Havens Google Phone: 573.454.1232 ICQ: 495992798 ICBM: 37°51'34.79"N 90°35'24.35"W ham radio callsign: NW0W
