no current connection error when accessing drill in sql line in distributed mode

2018-05-09 Thread Divya Gehlot
Hi, I am trying to access Drill through Sqlline ,I am getting below error : [mapr@usazprdmapr-dn1 bin]$ sqlline –u > jdbc:drill:zk=xx.xx.xx.x:5181,xx.xx.xx.x:5181,xx.xx.xx.x:5181 > OpenJDK 64-Bit Server VM warning: ignoring option MaxPermSize=512M; > support was removed in 8.0 > –u (No such file o

Re: Failed to fetch parquet metadata after 15000ms

2018-05-09 Thread Parth Chandra
The most common reason I know of for this error is if you do not have enough CPU. Both Drill and the distributed file system will be using cpu and sometimes the file system, especially if it is distributed, will take too long. With your configuration and data set size, reading the file metadata sho

Failed to fetch parquet metadata after 15000ms

2018-05-09 Thread Carlos Derich
Hello guys, Asking this question here because I think i've hit a wall with this problem, I am consistently getting the same error, when running a query on a directory-based parquet file. The directory contains six 158MB parquet files. RESOURCE ERROR: Waited for 15000ms, but tasks for 'Fetch parq

Re: tableau drill connection - handshake time out error

2018-05-09 Thread Sorabh Hamirwasia
Hi Divya, Thanks for sharing the logs unfortunately I don't see any additional information in it. Can you please try following: 1) Enable trace logging on Drillbit side for Rpc package? You can do so by adding below block in logback.xml file location under conf directory and then restart the

Re: Handhsake Error

2018-05-09 Thread Andries Engelbrecht
You stated you can connect with Drill Explorer on the client system, can you also configure a DSN in the ODBC admin and do a connection test successfully? You mentioned you used the No Authentication option to connect to Drill? What version of the ODBC driver are you using? Also which version of

Re: Handhsake Error

2018-05-09 Thread Parth Chandra
Try to set the logging level of the drillbit to trace. In your logback.xml - There should be a message starting with "Handling handshake ... " On Wed, May 9, 2018 at 11:12 AM, Peter Edike < peter.ed...@interswitchgroup.com> wrote: > I have increased the timeout a

Re: Handhsake Error

2018-05-09 Thread Peter Edike
I have increased the timeout and I am quite sure there are no authentication modules enabled. Is there anyway I can check if the request is getting to the server in the first place On May 9, 2018 7:09 PM, Parth Chandra wrote: If you haven't tried it already, try increasing the handshake tim

RE: Handhsake Error

2018-05-09 Thread Robert Wu
Hi Peter, Could you tell us more about the version of the drillbit and the driver you are using? Best regards, Rob -Original Message- From: Peter Edike Sent: Wednesday, May 9, 2018 3:05 AM To: user@drill.apache.org Subject: Handhsake Error Hello everyone I am trying to setup a dat

Re: Handhsake Error

2018-05-09 Thread Parth Chandra
If you haven't tried it already, try increasing the handshake timeout. Do you have any security/authentication settings turned on? One possibility is that an authentication module is being accessed by the server during the handshake and the server is taking too long to reply to the handshake causin

Handhsake Error

2018-05-09 Thread Peter Edike
Hello everyone I am trying to setup a datasource to connect to a drillbit running on a host I am using the Direct To DrillBit Option And have specified the ip-address of the server on which the drill bit service is running as well as the appropriate ports I can telnet from my windows pc into t