Alternatively to see all the VIEWS on the Drill cluster you can run the following query.
select * from INFORMATION_SCHEMA.`TABLES` where TABLE_TYPE='VIEW'; This will give you 4 columns. TABLE_CATALOG - Self explanatory. TABLE_SCHEMA - which give you the <storage plugin>.<workspace> where the View is located TABLE_NAME - The name of the View TABLE_TYPE - Where VIEW is for a View and you can remove the predicate to see other Tables and System Tables registered in INFORMATION_SCHEMA --Andries > On Jul 28, 2016, at 6:02 AM, Neeraja Rentachintala > <[email protected]> wrote: > > If you want to see a list of views created, you can use 'show tables' in > the workspace. > > On Thu, Jul 28, 2016 at 5:05 AM, Santosh Kulkarni < > [email protected]> wrote: > >> How to see a view created in Drill Explorer thru Drill shell? Is there any >> any command for Drill views? >> >> Thanks, >> >> Santosh >>
