Hi ,
I am facing a strange Drill connection issue.
I am connecting to Drill through Tableau.
I have published coupled of reports to tableau server.
When I connect to Drill thorugh tableau desktop and tableau server at same
time
it becomes unresponding.I keeping getting "connection time out error"
Hi,
I have few questions on modeling a time series use case with parquet and
drill. I have seen the topic discussed at
https://issues.apache.org/jira/browse/DRILL-3534.
My requirements are:
* Keep the parquet files partitioned by year and month
* For the current month, the data needs to be furth
parquet-tools can be used only for inspecting parquet files, not for creating
new
parquet files. Yes, you can use CTAS to do this. You have to manually remove
the
old files and move the new files.
It does impact the metadata caching mechanism.
You need to regenerate metadata cache.
Thanks
Pad
Hi, good afternoon.
We have a question regarding the MongoDB and Drill integration through the
Mongo storage plugin; we need to query and execute geospatial queries through
Drill using the MongoDB geospatial functions. That means we have data in Mongo
and using Drill we need to call those Mongo
Hi Team,
I have configured drill on 4 node cluster and getting error while creating
storage plugin for Oracle DB.
Error : Please retry: error (unable to create/ update storage)
Oracle DB Version : *12.1.0.2.0*
Following steps followed to create storage plugin:
1. copied ojdbc7.jar to jars/3rdpa
Hi Akshay,
Did you copy jdbc driver to all the drill nodes and restarted drillbits ?
Thanks,
Arjun
From: Akshay Joshi
Sent: Tuesday, October 31, 2017 9:46 PM
To: user@drill.apache.org
Subject: Apache drill : Error while creating storage plugin for Oracle DB
Starting the hangout in a bit ...
On Mon, Oct 30, 2017 at 1:12 PM, Timothy Farkas wrote:
> I'll speak about unit testing:
>
>
> - Common mistakes that were made in unit tests
>
> - The soon to be merged temp directory test watcher classes
>
> - Making our Travis build run smoke tests with cod
Hi,
Seems Drill already has geospatial query support
https://issues.apache.org/jira/browse/DRILL-3914.
Can you please take a look into https://github.com/k255/drill-gis and
https://github.com/k255/drill-gis/blob/master/src/main/java/org/apache/drill/exec/expr/fn/impl/gis/STIntersects.java
functi
Looks like the call is full. Bunch of us are not able to join.
Can some other folks get together and join together?
On Tue, Oct 31, 2017 at 10:04 AM, Parth Chandra wrote:
> Starting the hangout in a bit ...
>
> On Mon, Oct 30, 2017 at 1:12 PM, Timothy Farkas wrote:
>
>> I'll speak about unit
Can you share the logs from your Drill bit? Without the logs I'm taking a shot
in the dark but
you can try increasing the timeout between the DrillClient and foreman by
adding this configuration
to your drill-override.conf
drill.exec.rpc.user.timeout: 30
Thanks,
Tim
__
Try again; I dropped off.
- Paul
> On Oct 31, 2017, at 10:06 AM, Parth Chandra wrote:
>
> Looks like the call is full. Bunch of us are not able to join.
> Can some other folks get together and join together?
>
>
>
> On Tue, Oct 31, 2017 at 10:04 AM, Parth Chandra wrote:
>
>> Starting the h
We are in. Thanks Paul.
On Tue, Oct 31, 2017 at 10:09 AM, Paul Rogers wrote:
> Try again; I dropped off.
>
> - Paul
>
> > On Oct 31, 2017, at 10:06 AM, Parth Chandra wrote:
> >
> > Looks like the call is full. Bunch of us are not able to join.
> > Can some other folks get together and join toge
Hi Arjun,
Yes. I copied jdbc driver (ojdbc7.jar) to all the drill nodes and restarted
the drillbits on all nodes.
Thanks and Regards,
Akshay
On Tue, 31 Oct 2017 at 10:30 PM, Arjun kr wrote:
> Hi Akshay,
>
>
> Did you copy jdbc driver to all the drill nodes and restarted drillbits ?
>
>
> Thanks
Do you see any specific error message in drillbit.log ?
Thanks,
Arjun
From: Akshay Joshi
Sent: Tuesday, October 31, 2017 11:10 PM
To: user@drill.apache.org
Subject: Re: Apache drill : Error while creating storage plugin for Oracle DB
Hi Arjun,
Yes. I copied j
Hi Arjun,
No error message getting logged in drillbit.log once I click on "create"
button.
Thanks,
Akshay
On Tue, Oct 31, 2017 at 11:19 PM, Arjun kr wrote:
>
> Do you see any specific error message in drillbit.log ?
>
> Thanks,
>
> Arjun
>
>
> From: Akshay Josh
There are other logs that might be reporting the error.
Look at the other logs in the Drill UI ... one of them that can carry more
information would be drillbit.out
-Original Message-
From: Akshay Joshi [mailto:joshiakshay0...@gmail.com]
Sent: Tuesday, October 31, 2017 11:06 AM
To: us
Thanks everyone!
Converting to partitioned parquet really did the trick. I ended up
partitioning by day and hour, and while the queries aren’t instantaneous, they
aren’t slow either.
> On Oct 30, 2017, at 14:21, Andries Engelbrecht wrote:
>
> As Ted touched on - CSV requires a lot of text
Can you try with CURL as well ?
curl -v -X POST -H "Content-Type: application/json" -d '{"name":"oracle1",
"config": {"type": "jdbc", "enabled": true,"driver":
"oracle.jdbc.driver.OracleDriver",
"url":"jdbc:oracle:thin:/@:/" }}'
http://< drill_server>:8047/storage/oracle1.json
Please refer t
Hi Arjun/Kunal,
Error message is not getting logged in drillbit.out as well once "create"
button is clicked. None of the log files is getting updated in drill UI.
Tried with curl command and getting the same error *(unable to create/
update storage) *without much stacktrace about error. PFB more
Hi Arjun/Kunal,
Just to add to my previous mail I am using *Apache Drill version 1.11.0.*
Thanks,
Akshay
On Wed, Nov 1, 2017 at 10:29 AM, Akshay Joshi
wrote:
> Hi Arjun/Kunal,
>
> Error message is not getting logged in drillbit.out as well once "create"
> button is clicked. None of the log fi
Could you file a JIRA for this? I see the potential sources where the bug
originated and there doesn’t seem to be sufficient logging, so it gets hard to
narrow it down.
-Original Message-
From: Akshay Joshi [mailto:joshiakshay0...@gmail.com]
Sent: Tuesday, October 31, 2017 10:04 PM
To:
Hi Akshay,
Just wondering if the issue is only with Oracle storage plugin. Are you able to
create storage plugin other than oracle , say dfs or cp ?
Thanks,
Arjun
From: Kunal Khatua
Sent: Wednesday, November 1, 2017 11:12 AM
To: user@drill.apache.org
Subjec
Hi Arjun/Kunal,
Yes I am able to create storage plugins other than oracle.
I have created plugin for Alluxio. dfs and cp were default plugins.
As well I am able to trigger queries using these plugins.
Thanks,
Akshay
On Wed, 1 Nov 2017 at 11:20 AM, Arjun kr wrote:
> Hi Akshay,
>
>
> Just wonder
23 matches
Mail list logo