Re: tableau drill connection - handshake time out error

2018-05-08 Thread Divya Gehlot
Hi Sorabh, On the machine where Tableau Desktop is installed , I am able to login through Drill Explorer . Neither able to login throug tableau desktop nor tableau server. I did enabled ODBC tracing and here is link[1] of the tracing log . Here is the error which I could see at tableau side

Re: RE: Not Able to Query Part files Using Drill

2018-05-08 Thread Paul Rogers
Hi Tilak, Drill's format matching mechanism uses the file suffix (only). Drill has no way to match on any other part of the name. So, in order to get Drill to read your file, you either need a file suffix that matches a format config, or define the default config to be the one you want. That

Re: Apache Drill Automatically Converts Large Numbers to Exponents

2018-05-08 Thread Paul Rogers
Hi Peter, Just to clarify... Internally, Drill stores numbers as FLOAT or DOUBLE. The question is how a client displays the numbers. Khurram has listed a number of those clients. If you are using a JDBC/ODBC client, then the issue might be in the tool using that driver. For Drill's own client

Re: Apache Drill Automatically Converts Large Numbers to Exponents

2018-05-08 Thread Khurram Faraaz
Hi Peter, Where do you see large numbers being represented/displayed as exponents, in Drill (and what version of Drill are you on) ? 1. Do you see that behavior on sqlline prompt ? 2. Do you see it from a JDBC application ? 3. Do you see that on Drill's Web UI ? 4. If you don't see it

Re: permission denied error in drillbit.out

2018-05-08 Thread Sorabh Hamirwasia
This just means it failed to access the directory /Data/Users/AP/ using that MapR file client instance. It can happen if the MapR file client instance is created in context of a user who doesn't have read permission for that directory. Probably you might have some log before this line stating

Re: tableau drill connection - handshake time out error

2018-05-08 Thread Sorabh Hamirwasia
Hi Divya, If you are seeing no logs on server side (considering logging is not disabled) that means issue is on the client side setup. It can be either on Tableau or with the ODBC driver itself. In your previous thread you mentioned the setup was working fine when using Drill Explorer. If you

Re: Apache Drill Automatically Converts Large Numbers to Exponents

2018-05-08 Thread Vova Vysotskyi
Hi Peter, If the problem is only with displaying the numbers, you may convert it to the string with the specified format using TO_CHAR(expression, format) UDF. For more details please see https://drill.apache.org/docs/data-type-conversion/#other-data-type-conversions Kind regards, Volodymyr

Apache Drill Automatically Converts Large Numbers to Exponents

2018-05-08 Thread Peter Edike
Hello everyone, How can I prevent Apache Drill From Displaying large numers as exponents as this is not acceptable for my use case Kind regards Peter Edike

RE: Not Able to Query Part files Using Drill

2018-05-08 Thread Surneni Tilak
Hi Team, I am trying to query the part files which are of type text(Encoding format ASCII ) but with no file extension. Those part files are generated using Sparkbench suite. Please find the below error message: Query Failed: An Error Occurred

permission denied error in drillbit.out

2018-05-08 Thread Divya Gehlot
Hi, I can see below entry in drillbit.out although user has permission. > 2018-05-08 04:52:37,1456 ERROR JniCommon > fs/client/fileclient/cc/jni_MapRClient.cc:2572 Thread: 2454 readdirplus > failed for dir /Data/Users/AP/, error = Permission denied(13) Can anybody help me interpret above error

Re: tableau drill connection - handshake time out error

2018-05-08 Thread Divya Gehlot
Hi, I don't see any entry in drillbit.log and drillbit.out file when I try log in through tableau. I tried with Tableau desktop(10.2) and tableau Server (10.5).None worked for me . Its the 3 node MapR 5.2 having Drill 1.10.0 version . Thanks, Divya On 4 May 2018 at 01:30, Sorabh Hamirwasia