Handhsake Error

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

Re: Handhsake Error

8 at 3:05 AM, Peter Edike < peter.ed...@interswitchgroup.com> wrote: > > 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

Exception While Querying Decimal Fields in Apache Drill

I am trying to run the following query in apache drill, I am querying data stored in parquet files using the following query select pan, count(*) as number_of_transactions , terminal_id,SUM((cast(SETTLE_AMOUNT_IMPACT as double) *-1)/100) AS settle_amount_impact from

RE: Exception While Querying Decimal Fields in Apache Drill

ersome. --Andries On 4/27/18, 5:18 AM, "Peter Edike" <peter.ed...@interswitchgroup.com> wrote: I am trying to run the following query in apache drill, I am querying data stored in parquet files using the following query select pan, count(*) as number_of_transactions ,

RE: Handhsake Error

either works. The Apache Drill data source connection can only support No and Basic (user/pass authentication). --Andries On 5/9/18, 11:12 AM, "Peter Edike" <peter.ed...@interswitchgroup.com> wrote: I have increased the timeout and I am quite sure there are no authenti

RE: Handhsake Error

That’s the exact location from which I downloaded the odbc driver. There is no authentication and yes drillbit is listening on 31010. I am connecting to drillbit directly Best regards, Peter Edike -Original Message- From: Andries Engelbrecht <aengelbre...@mapr.com> Sent: Th

RE: Handhsake Error

n 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 and I am quite sure there are no > au

RE: Handhsake Error

an user authentication issue. As a workaround I would suggest you enable at least PLAIN authentication on the drillbit and use user/pass to access. --Andries On 5/10/18, 7:18 AM, "Peter Edike" <peter.ed...@interswitchgroup.com> wrote:

Apache Drill Automatically Converts Large Numbers to Exponents

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

Unable to run Drill queries on Drill1.13

[Error Id: ee07252c-597e-4602-a06e-583bedd4eaff on BGDTEST5.INTERSWITCH.COM:31010] I always see a username text box but I don't quite like the fact that I must enter a username to run queries. How can I disable this behavior Peter Edike Senior Software Engineer

RE: Error Joining Two Tables In Apache Drill

The query queries a no-sql databaseso I don’t think there is type information. However, Querying without the cast returns an empty result set, but I can see matching rows when I query the two views independently Best regards, Peter Edike Senior Software Engineer Interswitch Tel

RE: Error Joining Two Tables In Apache Drill

I GET VARCHAR Best regards, Peter Edike Senior Software Engineer Interswitch Tel.  | Mobile.  | IP Phone. Fax.  | mailto:peter.ed...@interswitchgroup.com | http:// http://www.interswitchgroup.com InterswitchThis e-mail and all attachments transmitted with it remain the property

Error Joining Two Tables In Apache Drill

function implementation: [castTINYINT(VARCHAR-OPTIONAL)]. Full expression: --UNKNOWN EXPRESSION--.. Fragment 2:0 [Error Id: 6c84fc61-c9d7-4d55-9ebd-bbbf7be84865 on BGDTEST2.INTERSWITCH.COM:31010]. ... 21 more Please what am I doing wrong Kind Regards Peter Edike

RE: Error Joining Two Tables In Apache Drill

casting or conversion, solved the problem Best regards, Peter Edike Senior Software Engineer Interswitch Tel.  | Mobile.  | IP Phone. Fax.  | mailto:peter.ed...@interswitchgroup.com | http:// http://www.interswitchgroup.com InterswitchThis e-mail and all attachments transmitted

RE: Error Joining Two Tables In Apache Drill

Nothing really, Just felt that since straight through equality comparison did not work, perhaps casting to a number will produce the desired results. Unknown to us, some rows had that column set to XXX Thanks Again Best regards, Peter Edike Senior Software Engineer Interswitch Tel

RE: Error Joining Two Tables In Apache Drill

query returns results albeit in Exponent Notation SELECT TO_NUMBER(table1.product_code, '#') from dfs.vtucare.vw_tbl_transactions as table1 LIMIT 1 Best regards, Peter Edike Senior Software Engineer Interswitch Tel.  | Mobile.  | IP Phone. Fax.  | mailto:peter.ed

RE: Error Joining Two Tables In Apache Drill

in for the local filesystem Best regards, Peter Edike Senior Software Engineer Interswitch Tel.  | Mobile.  | IP Phone. Fax.  | mailto:peter.ed...@interswitchgroup.com | http:// http://www.interswitchgroup.com InterswitchThis e-mail and all attachments transmitted with it remain the property

RE: Exception While Querying Decimal Fields in Apache Drill

Kind regards, Volodymyr Vysotskyi пт, 27 квіт. 2018 о 17:47 Peter Edike <peter.ed...@interswitchgroup.com> пише: > > > Drill Version 1.12.0 > > > > planner.enable_decimal_data_type is set to true on the system. > > > > --peter > > &

RE: Exception While Querying Decimal Fields in Apache Drill

Hi Here is the stacktrace on the server side error_type: SYSTEM message: "SYSTEM ERROR: ClassCastException: org.apache.drill.exec.vector.NullableDecimal28SparseVector cannot be cast to org.apache.drill.exec.vector.VariableWidthVector\n\nFragment 2:8\n\n[Error Id:

Apache Drill Queries Take so Long after which Webconsole dies and I don't see results

Hello everyone, I am currently using apache drill to query a directory of parquet files (total size 64gb with each file averaging 6.4Gb per size). I am running the following query select * from dfs.rj.vw_reports_201805 where unique_key in ( select unique_key from

Error Querying Parquet Files In Apache Drill 1.13

do to mitigate against this Peter Edike Senior Software Engineer Research and Development, ENG Engineering [cid:image002.png@01D42E71.8D117260] Office NO: Mobile NO: Email: peter.ed...@interswitchgroup.com<mailto:peter.ed...@interswitchgroup.com> Inter

RE: This query is so slow

_key`", "expr":"`unique_key`" }, { "ref":"`E_X_P_R_H_A_S_H_F_I_E_L_D`", "expr":"hash32asdouble(`unique_key`, 1301011) " } ], "child":262146,

Re: Problem Creating Views In Apache Drill

and provide the stack trace from the console. Thanks, Gautam On Fri, Jan 11, 2019 at 3:22 AM Peter Edike < peter.ed...@interswitchgroup.com> wrote: > Hello Everyone, > > > I have a set of parquet files which where created as a result of a batch > ETL job (using Sqoop

Re: Problem Creating Views In Apache Drill

bose` = true and provide > the stack trace from the console. > > Thanks, > Gautam > > On Fri, Jan 11, 2019 at 3:22 AM Peter Edike < > peter.ed...@interswitchgroup.com> wrote: > > > Hello Everyone, > > > > > > I have a set of parquet files which

Problem Creating Views In Apache Drill

Hello Everyone, I have a set of parquet files which where created as a result of a batch ETL job (using Sqoop 1). I can query the fields normally without any kind of formatting and all is well... However, when i try to create a view with the following code CREATE VIEW