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