Re: Drill connection using jdbc

quot; which is the default. >> >> Thanks. >> >> --Robert >> >> On Wed, Jan 9, 2019 at 1:03 AM Robert Hou wrote: >> >>> Can you try "drill" as your zk.root? >>> >>> What do you se

Re: Drill connection using jdbc

zk.root is "drill" by default. If you have specified zk.root in drill-override.conf, then use that. Thanks. --Robert On Wed, Jan 9, 2019 at 12:13 AM Tushar Pathare wrote: > Hello Team, > Same issue. > > > ERROR: An error occur

Re: Drill connection using jdbc

its a necessary parameter if non default cluster I'd is used and given in the connection url. You can check if it works with directory specified. Get Outlook for Android<https://aka.ms/ghei36> ________ From: Tushar Pathare Sent: Tuesday,

Re: Drill connection using jdbc

r if non default cluster I'd is used and given in the connection url. You can check if it works with directory specified. Get Outlook for Android<https://aka.ms/ghei36> ________ From: Tushar Pathare Sent: Tuesday, January 8, 2019 11:40:22 PM

Re: Drill connection using jdbc

lt;https://aka.ms/ghei36> ________ From: Tushar Pathare Sent: Tuesday, January 8, 2019 11:40:22 PM To: user@drill.apache.org Subject: Re: Drill connection using jdbc Is it necessary because I thought it is optional including the cluster ID

Re: Drill connection using jdbc

conn.close(); } catch(SQLException sqlexcpn){ sqlexcpn.printStackTrace(); } if(prdstmnt != null) try { prdstmnt.close(); } catch(SQLException sqlexcpn){ sqlexcpn.printStackTrace(); } } } } Regards, Khurram On Tue, Jan 8, 201

Re: Drill connection using jdbc

There must be a stack trace in the logs.could you share that? On Tue, Jan 8, 2019, 11:10 PM Tushar Pathare Hello Team, > > We have installed drill 1.12.0 and trying to connect > using a client to the drill cluster > &g

Drill connection using jdbc

Hello Team, We have installed drill 1.12.0 and trying to connect using a client to the drill cluster Our config for connection is Drill class is : org.apache.drill.jdbc.Driver Driver location is /Users/tpathare/Downloads/apache-drill-1.12.0/jars/jdbc-driver/drill-jdbc-all-1.1

Re: Proposed Slack Channel for Drill Users & Devs

Very much needed count me in Get Outlook for iOS _ From: Divya Gehlot Sent: Friday, January 5, 2018 1:57 PM Subject: Re: Proposed Slack Channel for Drill Users & Devs To: Cc: yes most needed On 5 January 2018 at 00:10, Charles Givre wrote:

Drill queries not getting executed-son profile for queries not created

Hello Team, What are the pre-reqs needed to be performed to ensure the queries are getting fired. Strangely the Json profiles for queries are not getting created. And the query log stops at this message drillbits: Address | User Port | Control Port | Data Port | Version

Reading column from parquet file saved using spark.1.6

Hello Team, I am getting wrong values for date columns(START_DT,END_DT)timestamp while querying. Please see the attached screenshot.I am using the latest build from drill 1.9. snapshot The value I am getting is [B@471ce738 The schema is as follows |-- _IDENTIFIER: string

Re: Workaround or a quick fix for apostrophe search

gle Jason Altekruse Software Engineer at Dremio Apache Drill Committer On Sat, Oct 15, 2016 at 2:56 AM, Tushar Pathare wrote: > Hello Team, > Is there a quick fix of workaround for non asci > character parsing.I am specifically looking for

Workaround or a quick fix for apostrophe search

Hello Team, Is there a quick fix of workaround for non asci character parsing.I am specifically looking for an apostrophe search Like as in SELECT * from HISTORY_VALUE_D WHERE HISTORY_VALUE_NAME like 'Parkinson`s disease' https://issues.apache.org/jira/browse/DRILL-4039 Much

Nest with clause support

Hello Team, What the roadmap to support nested With clause. If not is there a way to create session specific temporary tables in Drill. Tushar B Pathare High Performance Computing (HPC) Administrator General Parallel File System Scientific Computing B

Re: IN operator can take how many inputs ?

bquery_threshold | LONG | SYSTEM | DEFAULT | 20 > | null| null | null | > > ++---+-+------+--+-+---++ > > On Sun, Oct 2, 2016 at 12:56 AM, Tushar Pathare > wrote: > > Hello Team, > > > > A select clause with IN operator creates a issue if the count of go

IN operator can take how many inputs ?

Hello Team, A select clause with IN operator creates a issue if the count of goes beyond 19 for params.Is this a tunable or this is a drawback. If the number of params is made less that 19 the same select statement works Select something…… IN ( '94479 ', '296979 ', '219579 ', '109179 ', '97179

Re: Table value functions in Drill

, Qatar Near QNCC,5th Floor Office 4003 ext 37443 | M +974 74793547 tpath...@sidra.org<mailto:tpath...@sidra.org> | www.sidra.org<http://www.sidra.org/> From: Tushar Pathare mailto:tpath...@sidra.org>> Date: Monday, July 25, 2016 at 2:01 PM To: "user@drill

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 Para

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 Researc

Re: Drill Issues

Hello Vinita, A simple storage plugins for Hive looks like this. { "type": "hive", "enabled": true, "configProps": { "hive.metastore.uris": "thrift://scflexnode09:9083", "hive.metastore.sasl.enabled": "false", "fs.default.name": "hdfs://scflexnode09:8020/" } } Hop

Re: Drill with MSSQL/Oracke

Drill can work with any of the databases provided you can write the plugin connector for it and a 3rd party driver like ojdbc*.jar etc. The apache drill document is available on the website which gives you details about the same. Get Outlook for iOS __