Re: Connecting to Drill ODBC DSN takes exceptionally long time

Andries did a great job on putting together the material below on this topic. This info will be helpful to you to optimize metadata access experience from Tableay. Additionally make sure you are using the Tableau TDC file that ships with Drill ODBC drier.

Connecting to Drill ODBC DSN takes exceptionally long time

While connecting Tableau to Drill ODBC DSN, it takes almost 5 minutes to connect to Drill.I created 2 DSN, one for Zookeeper Quorum and other one for Direct to drillbit, Both take very long time to connect successfully to Drill. Also, after the connection just to open Schema and the tables within

Re: Tableau Web Data Connector

Steve, As far as I know, this has not been written (or maybe someone has written but not yet contributed). Agree that it would certainly be a useful functionality. -Aman On Mon, Jul 25, 2016 at 11:17 AM, Steve Warren wrote: > Has anyone written a Tableau Web Data Connector

Overflow detection in Drill

Hi All, As of today Drill does not handle overflow detection and does not report that was an overflow to users, instead we just return results that are incorrect. This issue has been discussed (but not in detail) in the past. It would be great if Drill also handled overflow detection in data of

Tableau Web Data Connector

Has anyone written a Tableau Web Data Connector for Drill? I noticed prestodb.io has one and it really opens up the ability to interface with drill over the internet. -- Confidentiality Notice and Disclaimer: The information contained in this e-mail and any attachments, is not transmitted by

Re: deploy dockerized drill cluster

it's still not picking up the store.json* config changes The only way I can see to set these is with running ALTER SYSTEM query after drill api is up. Scott Kinney | DevOps stem | m 510.282.1299 100 Rollins Road, Millbrae, California 94030 This e-mail

Re: tmp noexec

I move the /tmp off local disk into the distributed FS on a node local volume on MapR. Other file systems can be inserted. Open up drill-override.conf on all of the nodes, and insert this : sort: { purge.threshold : 100, external: { batch.size : 4000, spill: {

tmp noexec

Hello, I've run into an issue where Drill will not start if mount permissions are set on /tmp to noexec. The permissions were set to noexec due to security concerns. I'm using Drill version 1.7. The error I get when starting Drill is: Exception in thread "main" java.lang.UnsatisfiedLinkError:

Re: deploy dockerized drill cluster

Try (for the sake of the conversation here) using host networking, and see if it changes how successful your setup is. (I know bridged is preferred, but try the host side and see what happens) John On Mon, Jul 25, 2016 at 10:06 AM, Scott Kinney wrote: > I'm running the

Re: Partition prunning using CURRENT_DATE?

Great, thanks! I'm gonna try swapping the view file and see how it goes. On Thu, Jul 21, 2016 at 11:09:45AM -0500, John Omernik wrote: Yes, I have a view that has the hard coded date in it. It wasn't difficult, and using the REST API was actually fairly neat/clean. I agree with you, it would

Table value functions in Drill

Like suppose I need to get the following sql function in drill create function abc () returns @xyz table (id int,name varchar(100)) as begin insert into @xyz select 1 id,'aaa' name union select 2 id,'bbb' name return end Tushar B Pathare High Performance Computing (HPC) Administrator General

Sql functions help

Hello Team, Can we write a java function in drill to invoke a shell script or sql functions to return table-value format. Thanks Tushar B Pathare High Performance Computing (HPC) Administrator General Parallel File System Scientific Computing Bioinformatics Division

Re: How drill works internally

You can start with the high level architecture [1]. Then the community might help you if you have any specific questions. [1] https://drill.apache.org/architecture/ On Sun, Jul 24, 2016 at 11:36 PM, Sanjiv Kumar wrote: > How drill runs query internally. I want to know how

How drill works internally

How drill runs query internally. I want to know how drill execute query for different data sources.I want to know internal process of drill. .. Thanks & Regards *Sanjiv Kumar*