Re: JDBC datasource on Websphere server 8.5.5.9

2020-03-24 Thread Igor Guzenko
Hello Prabhakar, Seems like there is a similar question on https://stackoverflow.com/questions/1677722/websphere-application-server-data-source and easiest path is to uncheck enable2Phase somewhere in WebSphere driver settings. Or harder way is that you can try to make a small project just to

Re: Drill Hangout Proposal

2020-02-20 Thread Igor Guzenko
> > > On Feb 20, 2020, at 10:27 AM, Igor Guzenko > wrote: > > > > Hello Charles, > > > > The mentioned EET range (4 pm - 8 pm) is the most convenient for me. > Since > > morning time in Ukraine poorly correlates with the US time. > > An

Re: Drill Hangout Proposal

2020-02-20 Thread Igor Guzenko
civilized hour in the morning for them. > -- C > > > On Feb 20, 2020, at 10:14 AM, Igor Guzenko > wrote: > > > > Hello Charles, > > > > I feel uncomfortable that time is not perfect for everyone. In my > opinion, > > we have a broader time range, perfectl

Re: Drill Hangout Proposal

2020-02-20 Thread Igor Guzenko
Hello Charles, I feel uncomfortable that time is not perfect for everyone. In my opinion, we have a broader time range, perfectly would be to fit within: EST | 9 am - 2 pm PST | 6 am - 10 am EET | 4 pm - 8 pm Although still not so much space for PST, but at least not only 6:30 am... Kind

Re: Timestamp Issue

2020-02-07 Thread Igor Guzenko
Hello Charles, It seems to work when I use one additional ' for escaping, for example try using '-MM-dd''T''HH:mm:ss' for format. Thanks, Igor On Thu, Feb 6, 2020 at 11:43 PM Ted Dunning wrote: > That is really frustrating because that timestamp is literally in an ISO > 8601 format. > >

Re: [DISCUSS]: Thoughts

2020-01-30 Thread Igor Guzenko
Hello Charles, Thank you very much for starting this important discussion. These are all important things but at the current moment, I don't have a clear vision where we could start from. The item which is most interesting to me is the second one, but I've never been involved in building an

Re: Drill Hangout

2020-01-13 Thread Igor Guzenko
Hello Drillers, I'm fine with recovery of hangouts with one good suggestion. I think it will be fine to have a bi-weekly call like it was earlier, but also I'd like to suggest skip calls if one day before no one introduced good topic for discussion. >From previous experience, we had a few times

Re: About integration of drill and arrow

2020-01-10 Thread Igor Guzenko
; interested in doing a virtual get together to discuss further? I'm based > on eastern time in the US, so it's a little more convenient than California > time. > Thanks, > -- C > > > > > > > > On Jan 10, 2020, at 6:47 AM, Igor Guzenko > wrote: > > > >

Fwd: About integration of drill and arrow

2020-01-10 Thread Igor Guzenko
-- Forwarded message - From: Igor Guzenko Date: Fri, Jan 10, 2020 at 1:46 PM Subject: Re: About integration of drill and arrow To: dev Hello Drill Developers and Drill Users, This discussion started as migration to Arrow but uncovered questions of strategical plans for moving

Re: [ANNOUNCE] New Committer: Denys Ordynskiy

2019-12-31 Thread Igor Guzenko
Congratulations Denys! Well done! On Mon, Dec 30, 2019 at 8:24 PM Paul Rogers wrote: > Congratulations Denys! > > - Paul > > > > On Monday, December 30, 2019, 4:25:49 AM PST, Arina Ielchiieva < > ar...@apache.org> wrote: > > The Project Management Committee (PMC) for Apache Drill has

Re: [ANNOUNCE] Apache Drill 1.17.0 Released

2019-12-26 Thread Igor Guzenko
Many thanks to everyone who has contributed to the release! Great work! On Thu, Dec 26, 2019 at 8:27 PM Abhishek Girish wrote: > Congratulations, everyone! > > On Thu, Dec 26, 2019 at 10:20 AM Volodymyr Vysotskyi > > wrote: > > > On behalf of the Apache Drill community, I am happy to announce

Re: [VOTE] Release Apache Drill 1.17.0 - RC1

2019-12-18 Thread Igor Guzenko
Hi all, I've verified checksums, queried csv, json, parquet formats. I found a few issues with complex types, but they're not regressions. My vote: +1 (binding) Kind regards, Igor On Wed, Dec 18, 2019 at 6:23 PM Denys Ordynskiy wrote: > Hi all, > > I successfully built and run Drill from

Re: [ANNOUNCE] New PMC member: Ihor Guzenko

2019-12-16 Thread Igor Guzenko
Hello everyone, Thank you very much for greetings. It's an honor to be part of the Drill community. Sincerely, Igor On Fri, Dec 13, 2019 at 9:05 PM Pritesh Maker wrote: > Congrats Ihor!! > > On Fri, Dec 13, 2019 at 10:36 AM Paul Rogers > wrote: > > > Congratulations Ihor! > > - Paul > > > >

Re: Issue while setting up hive storage plugin in kerberized cluster

2019-11-30 Thread Igor Guzenko
efe9eb6c4995:0:0: State change requested > AWAITING_ALLOCATION --> RUNNING > 2019-11-29 18:27:09,100 [221e9d03-7c28-6462-bf0b-efe9eb6c4995:frag:0:0] > INFO o.a.d.e.w.f.FragmentStatusReporter - > 221e9d03-7c28-6462-bf0b-efe9eb6c4995:0:0: State to report: RUNNING > 2019-11-29 1

Re: Issue while setting up hive storage plugin in kerberized cluster

2019-11-29 Thread Igor Guzenko
> The hive metastore is up and running, the metastore is accessible from the > machine where drill is installed. I have followed all the steps present in > the documentation. > > On Fri, 29 Nov 2019, 05:17 Igor Guzenko, > wrote: > > > Hello Rameshwar, > > > > I

Re: Issue while setting up hive storage plugin in kerberized cluster

2019-11-28 Thread Igor Guzenko
Hello Rameshwar, I think the issue is a little bit more complicated, at least you need to be sure that hive metastore is up and running, and is accessible from given machine. Could you please create jira ticket containing configuration info as much as possible ? (hive-site.xml, storage plugin

Re: not able read few tables form mysql due to date type format error

2019-11-28 Thread Igor Guzenko
the Drill > documentation as I would imagine it would benefit others who run into the > same issue? > Thanks, > -- C > > > > > On Nov 28, 2019, at 9:42 AM, Igor Guzenko > wrote: > > > > Hello Rameshwar, > > > > It seems like you ha

Re: not able read few tables form mysql due to date type format error

2019-11-28 Thread Igor Guzenko
Hello Rameshwar, It seems like you have issue with date conversion for one of columns: Caused by: java.sql.SQLException: Value '-00-00' can not be represented as java.sql.Date. I believe you could try options suggested here:

Re: insert into will be or not supported in drill feature

2019-11-22 Thread Igor Guzenko
Hello Shuchangbo, Regarding the DRILL-3534 [1] status this challenging task is open for contribution since 2015 :) . Drill users have only one alternative for a long time (CTAS [2]). [1] https://issues.apache.org/jira/browse/DRILL-3534 [2] https://drill.apache.org/docs/create-table-as-ctas/

Re: ask for a question

2019-09-04 Thread Igor Guzenko
Hello Hongwei, You could easily check your assumption by connecting both drillbits and then disabling first(successful) one. Although as far as I know storage plugin shouldn't be enabled if connection to storage fails. It would be great if you described in detail the steps to reproduce in order

Re: Drill query result with NULL for new added column in transactional (ACID) Hive bucketed ORC table

2019-09-04 Thread Igor Guzenko
Hello Jerry, Thank you very much for detailed steps. The issue is pretty complex, when Drill reads meta about partition, somehow linked storage descriptor doesn't have the newly added column. I've created DRILL-7365 [1] which at the end of description contains one possible workaround. [1]

Re: Drill query result with NULL for new added column in transactional (ACID) Hive bucketed ORC table

2019-09-03 Thread Igor Guzenko
Hello Jerry, Could you please describe your use-case in details. I've tried following steps and Drill reads data for new column just fine. 1) Create table create table hive_bucketed(emp_id int, first_name string) clustered by (emp_id) into 4 buckets stored as orc tblproperties

Apache Drill Hangout - Sep 3, 2019

2019-09-02 Thread Igor Guzenko
Hello everyone, We have our bi-weekly hangout scheduled for tomorrow. It will start at 10 AM PST (link: http://meet.google.com/yki-iqdf-tai). Does anyone have topics to discuss tomorrow ? Thanks, Igor

Re: [ANNOUNCE] New PMC Chair of Apache Drill

2019-08-22 Thread Igor Guzenko
Congratulations, Charles! Great job! On Thu, Aug 22, 2019 at 10:28 AM Arina Ielchiieva wrote: > Hi all, > > It has been a honor to serve as Drill Chair during the past year but it's > high time for the new one... > > I am very pleased to announce that the Drill PMC has voted to elect Charles >

Re: [ANNOUNCE] New Committer: Anton Gozhyi

2019-07-29 Thread Igor Guzenko
Congratulations Anton! On Mon, Jul 29, 2019 at 12:09 PM denysord88 wrote: > Congratulations Anton! Well deserved! > > On 07/29/2019 12:02 PM, Volodymyr Vysotskyi wrote: > > The Project Management Committee (PMC) for Apache Drill has invited Anton > > Gozhyi to become a committer, and we are

Re: [ANNOUNCE] New Committer: Igor Guzenko

2019-07-23 Thread Igor Guzenko
Hello Drillers, Thank you all for the greetings. It is an honor for me to be part of the Apache Drill community. Best regards, Igor Guzenko On Tue, Jul 23, 2019 at 6:37 PM Charles Givre wrote: > Congrats Igor! Well deserved! > > > On Jul 23, 2019, at 11:15 AM, Kunal K

Re: [ANNOUNCE] New Committer: Bohdan Kazydub

2019-07-23 Thread Igor Guzenko
Congratulations, Bohdan! Great job !!! On Tue, Jul 23, 2019 at 12:33 PM Volodymyr Vysotskyi wrote: > Congratulations, Bohdan! Thanks for your contributions! > > Kind regards, > Volodymyr Vysotskyi > > > On Thu, Jul 18, 2019 at 4:55 PM Kunal Khatua wrote: > > > Congratulations, Bohdan! > > On

Re: cant select from hive table

2019-05-27 Thread Igor Guzenko
Hello Khurram, If Hive storage based authorization is enabled for your deployment it's may be the reason why you're getting such messages. In the test it's visible that when at storage level user don't have rights to query table files Drill shows the confusing error. Here is the test