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
> >
>
