Hi Luoc, This is what exactly i tied and it worked. This solves the problem. thanks
Regards Prabhakar On Wed, Feb 24, 2021 at 4:12 PM luoc <[email protected]> wrote: > Hi, > I think `CREATE VIEW` should be the answer you want. please view the > attachments of email to understand Drill views. > > 1. `select *` to view all columns. > 2. `create view` to create view schema. > 3. `show tables`,`describe table_name` to verify the schema. > > See also http://drill.apache.org/docs/create-view > > > 2021年2月23日 下午9:35，Prabhakar Bhosaale <[email protected]> 写道： > > hi Luco, > Thanks for quick response. The "Show files" or querying INFORMATION_SCHEMA > is not an option for me as I need to give an option to business users to > generate reports from BI tools. > So I am trying to integrate with Pentaho. I am able to create the > datasource and query the data by directly writing the query. But it is not > listing the Json files or folders. Is there any way to achieve that? thanks > > Regards > Prabhakar > > On Tue, Feb 23, 2021 at 12:44 PM luoc <[email protected]> wrote: > > Hello, > This is the default behavior. you could use the `show files` command to > list files. See also http://drill.apache.org/docs/show-files < > http://drill.apache.org/docs/show-files>. And then please don’t paste the > image for apache email, this is not supported. as an attachment file is a > simple way. > > Also welcome to join our Slack Channel: https://bit.ly/3t4rozO < > https://bit.ly/3t4rozO> > > 2021年2月23日 下午12:05，Prabhakar Bhosaale <[email protected]> 写道： > > Hi Team, > I am using apache dril 1.16.0 with MapR JDBC driver from URL > > > https://package.mapr.com/tools/MapR-JDBC/MapR_Drill/MapRDrill_jdbc_v1.6.6.1009/ > < > > https://package.mapr.com/tools/MapR-JDBC/MapR_Drill/MapRDrill_jdbc_v1.6.6.1009/ > > > > I used this driver to connect to drill datasource from squirrel. I have > > two storage plug-in one for JSON files and another for oracle > > > When I open connection through squirrel, I do not see table listing for > > JSON storage but I see table listing for oracle DB plug-in. Below is the > screenshot. > > > Am I missing something in configuration? Please help > > Thanks and Regards > Prabhakar > > > > >
