select VIEW_DEFINITION from INFORMATION_SCHEMA.VIEWS where TABLE_NAME ='your_view_name';
On Fri, Jun 26, 2015 at 8:35 AM, Jacques Nadeau <[email protected]> wrote: > I believe that the information is available from one of the information > Schema tables. > On Jun 26, 2015 5:19 AM, "Andy Pernsteiner" <[email protected]> > wrote: > > > In Drill, a view is just a JSON file, which will live within the > workspace > > where you saved it. EG, if you do: > > > > create or replace view dfs.workspace.myview as select * from mytable; > > > > It will create a file called 'myview.view.drill' , which will look > similar > > to: > > > > { > > "name" : "testview", > > "sql" : "SELECT *\nFROM `drill/new.json`\nFETCH NEXT 10 ROWS ONLY", > > "fields" : [ { > > "name" : "*", > > "type" : "ANY", > > "isNullable" : true > > } ], > > "workspaceSchemaPath" : [ "dfs", "workspace" ] > > } > > > > On Fri, Jun 26, 2015 at 5:14 AM, Vinupriyaa Muthusamypillai > Ananthakrishna > > < > > [email protected]> wrote: > > > > > How can we get the Drill views definition. The sql for which the drill > > > view is created. > > > > > > > > > > > > Thanks > > > Vinupriyaa > > > > > > > > > > > > -- > > Andy Pernsteiner > > Manager, Field Enablement > > ph: 206.228.0737 > > > > www.mapr.com > > > > Now Available - Free Hadoop On-Demand Training > > < > > > http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available > > > > > >
