Hi,
I'm using drill 1.8.0 and I have a custom authenticator implementation
following below steps :
https://drill.apache.org/docs/configuring-user-authentication/
Implementing and Configuring a Custom Authenticator
Administrators can use the template provided here to develop and implement a
Hi,
Should the setFetchSize work similar to applying LIMIT clause with drill JDBC
driver? I've set setFetchSize to
. The JDBC example has a
Class.forName("org.apache.drill.jdbc.Driver") statement to force driver
registration, but a ServiceLoader registration is pretty standard. Maybe you
should open a bug for it?
Laurent
On Tue, Sep 6, 2016 at 9:53 AM, Sudip Mukherjee <smukher...@commvault.com&
Sudip Mukherjee created DRILL-4880:
--
Summary: Support JDBC driver registration using ServiceLoader
Key: DRILL-4880
URL: https://issues.apache.org/jira/browse/DRILL-4880
Project: Apache Drill
Hi,
I am trying out a java program where I want to load drill JDBC driver using
ServiceLoader.load like all other jdbc drivers. But the code is failing to load
org.apache.drill.jdbc.Driver class. One possible reason
Is that the drill jdbc driver jar doesn't have a java.sql.Driver file under
Hi,
Drill service was stopped while I was using it through tableau. I restarted the
service but I couldn't continue with the current tableau workspace as the
queries were not reaching the drill server.
Is this something expected. Could you please suggest troubleshooting steps if
there's any?
Hi,
Drill service was stopped while I was using it through tableau. I restarted the
service but I couldn't continue with the current tableau workspace as the
queries were not reaching the drill server.
Is this something expected. Could you please suggest troubleshooting steps if
there's any?
Hi,
I've been experimenting with Apache Solr storage plugin with DRILL and have a
doubt whether we can query on solr dynamic fields existing in a solr core's
schema.
there is a schema validation which says that column not found which is
expected. Is there way to loosen the schema check or may
Sudip Mukherjee created DRILL-4516:
--
Summary: Transform SUM(1) query to COUNT(1)
Key: DRILL-4516
URL: https://issues.apache.org/jira/browse/DRILL-4516
Project: Apache Drill
Issue Type
take over.
--
Jacques Nadeau
CTO and Co-Founder, Dremio
On Wed, Mar 16, 2016 at 8:38 AM, Sudip Mukherjee <smukher...@commvault.com>
wrote:
> I don't see DRILL is transforming the query. Tried with a CSV file.
> Please let me know if I am missing something.
>
> 00-00
.handlers.DefaultSqlHandler.convertToPrel(DefaultSqlHandler.java:326)
> ~[drill-java-exec.jar:1.4.0]
> at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:175)
> ~[drill-java-exec.jar:1.4.0]
> at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorke
4.0]
at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:175)
~[drill-java-exec.jar:1.4.0]
at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:197)
~[drill-java-exec.jar:1.4.0]
Thanks,
Sudip
-Original Message-
From: Sudip Mukherjee [mailto:smukher...@commvault.
number of customization features, wonder if it is possible to
optimize those settings to avoid this issue.
--Andries
> On Feb 19, 2016, at 10:16 AM, Sudip Mukherjee <smukher...@commvault.com>
> wrote:
>
> Hi,
>
> Have anyone tried optimizing SUM(1) query in drill? Or
Hi,
Have anyone tried optimizing SUM(1) query in drill? Or is it implemented?
Getting these query while using Tableau. Mostly probably it is trying to figure
out NUMBER_OF_RECORDS.
Thanks,
Sudip
***Legal Disclaimer***
"This communication may
Thanks a lot for the information.
Regards,
Sudip
From: Arina Yelchiyeva [mailto:arina.yelchiy...@gmail.com]
Sent: 08 February 2016 PM 01:13
To: dev@drill.apache.org; Sudip Mukherjee
Subject: Re: TIMESTAMPADD sql jdbc function execution in drill
Hi Sudip,
timestampadd / timestampdiff functions
-and-arithmetic/
On Mon, Feb 8, 2016 at 12:09 PM, Sudip Mukherjee <smukher...@commvault.com>
wrote:
> Hi,
> Are TIMESTAMPADD / TIMESTAMPDIFF functions supported through drill? I
> am getting an error while running the below query
>
> SELECT CAST(EXTRACT(YEAR FROM CAST({fn
> TIMEST
Hi,
Are TIMESTAMPADD / TIMESTAMPDIFF functions supported through drill? I am
getting an error while running the below query
SELECT CAST(EXTRACT(YEAR FROM CAST({fn
TIMESTAMPADD(SQL_TSI_YEAR,CAST(`myshare`.`mtm` AS INTEGER),{d '1970-01-01'})}
AS DATE)) AS INTEGER) AS
Hi,
Could you please advise if this is the correct way to fix the problem. Wanted
to use Power BI with Drill and got into the below issue.
https://github.com/apache/drill/commit/19886c11352cfa45bdb2da885a86e6500986e1e3
Thanks,
Sudip
-Original Message-
From: Sudip Mukherjee (JIRA
Hi Stefan,
I've the initial code to query solr server with some of the filter, limit
push-downs. Used solrj to query on solr.
Thanks,
Sudip
-Original Message-
From: Stefán Baxter [mailto:ste...@activitystream.com]
Sent: 22 January 2016 PM 02:56
To: dev
Subject: Re: [GitHub] drill pull
Sudip Mukherjee created DRILL-4294:
--
Summary: InfoSchema is not returning column metadata if the query
contains escape character
Key: DRILL-4294
URL: https://issues.apache.org/jira/browse/DRILL-4294
Hi,
Does drill support connectivity with Microsoft Power BI? Couldn't find any
documentation stating that it is supported.
Thanks,
Sudip
***Legal Disclaimer***
"This communication may contain confidential and privileged material for the
sole
Sudip Mukherjee created DRILL-4172:
--
Summary: Need stop , port as startup parameters in case drill is
installed as windows service
Key: DRILL-4172
URL: https://issues.apache.org/jira/browse/DRILL-4172
Hi,
Could you please advise if there is a way I can use one of my existing
jetty/tomcat server and deploy drill as a service?
Thanks,
Sudip
***Legal Disclaimer***
"This communication may contain confidential and privileged material for the
sole
Hi,
I am trying to implement a custom authenticator so that I can validate against
some of existing service that we use. Wanted to know how can I apply the
security rules i.e. user1 has access to these many tables etc. going further
ahead with using BI Tools.
onger be viewed”).
- Sudheesh
> On Oct 1, 2015, at 12:43 PM, Sudip Mukherjee <smukher...@commvault.com> wrote:
>
> I uploaded to google drive. Should it be okay?
>
> https://drive.google.com/drive/folders/0ByRlB6iLvhRvSm9UQWJ4b2ZjVDQ
>
> Thanks,
> Sudip
>
> --
> On Sep 30, 2015, at 9:10 PM, Sudip Mukherjee <smukher...@commvault.com> wrote:
>
> Yes. I was running drill in embedded mode to try it out with 3.9
> lakhs records , near about 50+ columns.[ sqlline.bat -u "jdbc:drill:zk=local"
> ] I see sqlline.log and sqlli
I've shared an item with you:
Apache_Drill_Exception
https://drive.google.com/folderview?id=0ByRlB6iLvhRvSm9UQWJ4b2ZjVDQ=sharing=CPOnotUP=560d87a6
It's not an attachment -- it's stored online. To open this item, just click
the link above.
Apache drill exception while getting data to
PM, Sudip Mukherjee <smukher...@commvault.com> wrote:
>
> Ohh..Sorry about that,
> Could you please try again? Or I'll put it in github
> https://drive.google.com/drive/folders/0ByRlB6iLvhRvSm9UQWJ4b2ZjVDQ
>
> Thanks,
> Sudip
>
> -Original Message-
t file?
- Sudheesh
> On Sep 30, 2015, at 8:35 PM, Sudip Mukherjee <smukher...@commvault.com> wrote:
>
> Hi Devs,
>
> Getting into a channel closed exception when I tried to connect drill to
> tableau and query a large document set. Could it be because tableau dropped
> th
Hi Devs,
Getting into a channel closed exception when I tried to connect drill to
tableau and query a large document set. Could it be because tableau dropped the
connection due to datasize. Any thoughts?
2015-09-30 21:13:43,716 [29f3777a-d407-295a-d45e-243fb70efc07:frag:0:0] INFO
.jar:4.0.27.Final]
>
> Thanks,
> Sudip
>
> -Original Message-
> From: Sudheesh Katkam [mailto:skat...@maprtech.com]
> Sent: 01 October 2015 AM 09:09
> To: dev@drill.apache.org
> Subject: Re: Channel closed exception
>
> Can you check if there are any error m
so we are not able to see the image
On Sun, Sep 13, 2015 at 10:51 PM, Sudip Mukherjee <smukher...@commvault.com>
wrote:
> Hi,
>
> Need some help understanding the below steps of a query execution. The
> below query is broken down in to these steps.
>
> If you could jus
Hi,
Need some help understanding the below steps of a query execution. The below
query is broken down in to these steps.
If you could just explain me in short or point to a documentation link would be
great for me as I am trying to dig into drill code and logics.
SELECT SUM(1) AS `COL` FROM
Hi Devs,
I am getting the below exception while trying to create view from Web UI. Could
you please take a look on how to troubleshoot this?
org.apache.drill.common.exceptions.UserRemoteException: PARSE ERROR:
java.lang.IndexOutOfBoundsException: index (43) must be less than size (43)
QUERY
at 4:49 AM, Sudip Mukherjee <smukher...@commvault.com>
wrote:
> Hi Devs,
>
> Is there a max row limit which I can configure while pulling data from
> underlying datasource? If there is a large data-set would drill fetch
> like page by page
: Tomer Shiran [mailto:tshi...@dremio.com]
Sent: 08 September 2015 PM 08:16
To: dev@drill.apache.org
Subject: Re: Drill Sql Max row size
That won't be a problem. There's actually no limit on how many records/rows you
can have.
> On Sep 8, 2015, at 2:00 AM, Sudip Mukherjee <s
Hi Devs,
Is there a max row limit which I can configure while pulling data from
underlying datasource? If there is a large data-set would drill fetch like page
by page?
Thanks,
Sudip
***Legal Disclaimer***
"This communication may contain
Hi Devs,
I added some log-in in the drill code (copying excerpt of logs). I am seeing
some repetitive log lines when is do a "show databases" . wondering why would
schema scan would happen multiple times. Or is something I am missing. Could
you please help? [below are the log-lines that I
Hi Devs,
Is there way to connect a drillbit using the jdbc driver. Could you please
point me to an example if there is one?
Thanks,
Sudip
***Legal Disclaimer***
"This communication may contain confidential and privileged material for the
sole
Hi Devs,
I was trying to create views on top of my mongo datasource recently so that I
can use them from BI tools. I was wondering if there is a rest api to create
the views programmatically .
Actually the use case I was thinking that I will use the rest api to configure
the FS workspace for
only. Handling of a skip query is storage plugin-specific.*
You can take a look at JSONRecordReader for an example on how to use
isSkipQuery() to optimize the reading.
Thanks
On Thu, Aug 6, 2015 at 2:01 AM, Sudip Mukherjee
mukherjeesud...@hotmail.com
wrote:
Hi,
I am using apache
to figure out what
aggregate functions you want to push into the scan
2. Now add your new rule(s) to the StoragePlugin.getOptimizerRules() method.
- Rahul
On Thu, Aug 6, 2015 at 10:00 PM, Sudip Mukherjee smukher...@commvault.com
wrote:
Hi ,
I am trying to make basic storage plugin
Hi Rahul,
Thanks for sharing your code. I was trying to get plugin for solr engine. But I
thought of using solr's rest api to do the queries ,get schema metadata info
etc.
The goal for me is to expose a solr engine to tools like Tableau or MS Excel
and user can do stuff there.
I am still
solr
response with rows =0.
Source code : https://github.com/apache/drill/pull/100
Could someone please help me on this?
Thanks,
Sudip Mukherjee
***Legal Disclaimer***
This communication may contain confidential and privileged material
Sudip Mukherjee created DRILL-3585:
--
Summary: Apache Solr as a storage plugin
Key: DRILL-3585
URL: https://issues.apache.org/jira/browse/DRILL-3585
Project: Apache Drill
Issue Type: New
[
https://issues.apache.org/jira/browse/DRILL-3528?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sudip Mukherjee resolved DRILL-3528.
Resolution: Fixed
Apache drill plugin for solr
Sudip Mukherjee created DRILL-3528:
--
Summary: Apache drill plugin for solr
Key: DRILL-3528
URL: https://issues.apache.org/jira/browse/DRILL-3528
Project: Apache Drill
Issue Type: New
47 matches
Mail list logo