Apache Drill connection issue in tableau

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"

Time series storage with parquet

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

Re: Time series storage with parquet

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

Execute Mongo functions through Drill

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

Apache drill : Error while creating storage plugin for Oracle DB

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

Re: Apache drill : Error while creating storage plugin for Oracle DB

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

Re: [HANGOUT] Topics for 10/31/2017

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

Re: Execute Mongo functions through Drill

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

Re: [HANGOUT] Topics for 10/31/2017

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

Re: Apache Drill connection issue in tableau

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 __

Re: [HANGOUT] Topics for 10/31/2017

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

Re: [HANGOUT] Topics for 10/31/2017

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

Re: Apache drill : Error while creating storage plugin for Oracle DB

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

Re: Apache drill : Error while creating storage plugin for Oracle DB

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

Re: Apache drill : Error while creating storage plugin for Oracle DB

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

RE: Apache drill : Error while creating storage plugin for Oracle DB

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

Re: Drill performance question

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

Re: Apache drill : Error while creating storage plugin for Oracle DB

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

Re: Apache drill : Error while creating storage plugin for Oracle DB

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

Re: Apache drill : Error while creating storage plugin for Oracle DB

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

RE: Apache drill : Error while creating storage plugin for Oracle DB

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:

Re: Apache drill : Error while creating storage plugin for Oracle DB

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

Re: Apache drill : Error while creating storage plugin for Oracle DB

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