You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Prabhakar Bhosaale <bh...@gmail.com> on 2021/02/23 04:05:04 UTC
Squirrel not showing JSON table
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/
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
[image: image.png]
Thanks and Regards
Prabhakar
Re: Squirrel not showing JSON table
Posted by Prabhakar Bhosaale <bh...@gmail.com>.
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 <lu...@apache.org> 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 <bh...@gmail.com> 写道：
>
> 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 <lu...@apache.org> 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 <bh...@gmail.com> 写道：
>
> 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
>
>
>
>
>
Re: Squirrel not showing JSON table
Posted by luoc <lu...@apache.org>.
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 <http://drill.apache.org/docs/create-view>
> 2021年2月23日 下午9:35，Prabhakar Bhosaale <bh...@gmail.com> 写道：
>
> 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 <lu...@apache.org> 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 <bh...@gmail.com> 写道：
>>>
>>> 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
>>>
>>
>>
Re: Squirrel not showing JSON table
Posted by Prabhakar Bhosaale <bh...@gmail.com>.
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 <lu...@apache.org> 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 <bh...@gmail.com> 写道：
> >
> > 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
> >
>
>
Re: Squirrel not showing JSON table
Posted by luoc <lu...@apache.org>.
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 <bh...@gmail.com> 写道：
>
> 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
>