Apache Drill Hangout - Sept 17, 2019

Hi Drillers, We will have our bi-weekly hangout tomorrow Sept 17th, at 10 AM PST (link: https://meet.google.com/yki-iqdf-tai ). If there are any topics you would like to discuss during the hangout please respond to this email. Thanks, Gautam

Apache Drill Hangout - Aug 20, 2019

Hi Drillers, We will have our bi-weekly hangout tomorrow Aug 20th, at 10 AM PST (link: https://meet.google.com/yki-iqdf-tai ). If there are any topics you would like to discuss during the hangout please respond to this email. Thanks, Gautam

Re: [ANNOUNCE] New Committer: Igor Guzenko

Congratulations Igor! Gautam On Tue, Jul 23, 2019 at 12:47 PM Paul Rogers wrote: > Congrats Igor! > Thanks, > - Paul > > > > On Monday, July 22, 2019, 07:02:44 AM PDT, Arina Ielchiieva < > ar...@apache.org> wrote: > > The Project Management Committee (PMC) for Apache Drill has invited

Re: [ANNOUNCE] New Committer: Jyothsna Donapati

Congratulations Jyothsna!! Gautam On Thu, May 9, 2019 at 2:59 PM Timothy Farkas wrote: > Congrats!! > > > On Thu, May 9, 2019 at 2:54 PM Bridget Bevens wrote: > > > Congratulations, Jyothsna!!! :-) > > > > On Thu, May 9, 2019 at 2:46 PM Khurram Faraaz wrote: > > > > > Congratulations

[jira] [Created] (DRILL-7245) TPCDS queries 1, 45, 65, 97 are 3x slower when Statistics is enabled at sf 100

Gautam Parai created DRILL-7245: --- Summary: TPCDS queries 1, 45, 65, 97 are 3x slower when Statistics is enabled at sf 100 Key: DRILL-7245 URL: https://issues.apache.org/jira/browse/DRILL-7245 Project

[jira] [Created] (DRILL-7231) TPCDS-21 regresses after fix for DRILL-7148

Gautam Parai created DRILL-7231: --- Summary: TPCDS-21 regresses after fix for DRILL-7148 Key: DRILL-7231 URL: https://issues.apache.org/jira/browse/DRILL-7231 Project: Apache Drill Issue Type

[jira] [Resolved] (DRILL-7114) ANALYZE command generates warnings for stats file and materialization

[ https://issues.apache.org/jira/browse/DRILL-7114?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Parai resolved DRILL-7114. - Resolution: Fixed > ANALYZE command generates warnings for stats file and materializat

Re: [ANNOUNCE] New PMC member: Sorabh Hamirwasia

Congratulations Sorabh! Gautam On Fri, Apr 5, 2019 at 9:06 AM Arina Ielchiieva wrote: > I am pleased to announce that Drill PMC invited Sorabh Hamirwasia to > the PMC and > he has accepted the invitation. > > Congratulations Sorabh and welcome! > > - Arina > (on behalf of Drill PMC) >

[jira] [Created] (DRILL-7148) TPCH query 17 increases execution time with Statistics enabled because join order is changed

Gautam Parai created DRILL-7148: --- Summary: TPCH query 17 increases execution time with Statistics enabled because join order is changed Key: DRILL-7148 URL: https://issues.apache.org/jira/browse/DRILL-7148

[jira] [Resolved] (DRILL-7123) TPCDS query 83 runs slower when Statistics is disabled

[ https://issues.apache.org/jira/browse/DRILL-7123?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Parai resolved DRILL-7123. - Resolution: Fixed > TPCDS query 83 runs slower when Statistics is disab

[jira] [Resolved] (DRILL-7120) Query fails with ChannelClosedException when Statistics is disabled

[ https://issues.apache.org/jira/browse/DRILL-7120?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Parai resolved DRILL-7120. - Resolution: Fixed > Query fails with ChannelClosedException when Statistics is disab

[jira] [Resolved] (DRILL-7122) TPCDS queries 29 25 17 are slower when Statistics is disabled.

[ https://issues.apache.org/jira/browse/DRILL-7122?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Parai resolved DRILL-7122. - Resolution: Fixed > TPCDS queries 29 25 17 are slower when Statistics is disab

Apache Drill Hangout - March 19, 2019

Hello All, Does anyone have any topics to discuss during the hangout tomorrow? We will start the hangout at 10AM PST (http://meet.google.com/yki-iqdf-tai). Thanks, Gautam

[jira] [Resolved] (DRILL-1328) Support table statistics

[ https://issues.apache.org/jira/browse/DRILL-1328?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Parai resolved DRILL-1328. - Resolution: Fixed Merged with commit IDs  469be17597e7b7c6bc1de9863dcb6c5604a55f0c

Re: Anouncing Powered-By-Drill page

Great work team! Looks great :) Gautam On Thu, Feb 28, 2019 at 11:56 AM Jyothsna Reddy wrote: > This is some awesome addition to the website!! > > > > On Thu, Feb 28, 2019 at 9:38 AM Pritesh Maker wrote: > > > This is awesome! Thanks for driving this and also to Aashreya for his > >

Re: BI Tool Demo on Drill

+1 On Mon, Feb 11, 2019 at 2:54 PM Hanumanth Maduri wrote: > +1 > > > On Feb 11, 2019, at 2:50 PM, Aman Sinha wrote: > > > > +1 > > > >> On Mon, Feb 11, 2019 at 12:08 PM Abhishek Ravi > wrote: > >> > >> +1 > >> > >>> On Mon, Feb 11, 2019 at 11:54 AM Pritesh Maker > wrote: > >>> > >>> +1 >

Re: [VOTE] Apache Drill release 1.15.0 - RC2

- Downloaded source from [3] onto my Linux VM, built and ran unit tests. - Built the source using MapR profile and ran the secondary indexing tests - Verified checksum of the file with the one [3] +1 Gautam On Fri, Dec 28, 2018 at 10:06 AM Khurram Faraaz wrote: > Thanks Kunal, I will report a

Re: [ANNOUNCE] New Committer: Salim Achouche

Congratulations Salim! Well deserved. :) Gautam On Mon, Dec 17, 2018 at 10:30 AM Khurram Faraaz wrote: > Congratulations Salim!! > > On Mon, Dec 17, 2018 at 9:44 AM Hanumanth Maduri > wrote: > > > Congratulations Salim ! > > > > > On Dec 17, 2018, at 9:38 AM, Timothy Farkas wrote: > > > > >

[jira] [Created] (DRILL-6899) Fix timestamp issues in unit tests ignored with DRILL-6833

Gautam Parai created DRILL-6899: --- Summary: Fix timestamp issues in unit tests ignored with DRILL-6833 Key: DRILL-6899 URL: https://issues.apache.org/jira/browse/DRILL-6899 Project: Apache Drill

Re: [DISCUSS] 1.15.0 release

IkdA=-F7L9LEUsirwMUP2XMKpWwLdSbeqSvnnz0hKT2O16QQ= > . > A PR has been opened for DRILL-6882. > > I am actively working on both the issues and will keep you posted. > > Gautam > > On Mon, Dec 3, 2018 at 2:54 PM Gautam Parai wrote: > > > Hi Vitalii, > > > > J

Re: [ANNOUNCE] New Committer: Karthikeyan Manivannan

Congratulations Kathik! Well-deserved :) Gautam On Fri, Dec 7, 2018 at 11:12 AM Abhishek Girish wrote: > Congratulations Karthik! > > On Fri, Dec 7, 2018 at 11:11 AM Arina Ielchiieva wrote: > > > The Project Management Committee (PMC) for Apache Drill has invited > > Karthikeyan > >

Re: [DISCUSS] 1.15.0 release

at 2:54 PM Gautam Parai wrote: > Hi Vitalii, > > Jyothsna recently discovered a blocker issue - unit test failures for the > rowkeyjoin pushdown feature. This is tracked by > https://issues.apache.org/jira/browse/DRILL-6878 > > I am actively working on it and will keep y

[jira] [Created] (DRILL-6882) Handle the cases where RowKeyJoin's left pipeline being called multiple times.

Gautam Parai created DRILL-6882: --- Summary: Handle the cases where RowKeyJoin's left pipeline being called multiple times. Key: DRILL-6882 URL: https://issues.apache.org/jira/browse/DRILL-6882 Project

[jira] [Created] (DRILL-6878) Index Plan Test failures after DRILL-6833

Gautam Parai created DRILL-6878: --- Summary: Index Plan Test failures after DRILL-6833 Key: DRILL-6878 URL: https://issues.apache.org/jira/browse/DRILL-6878 Project: Apache Drill Issue Type: Bug

Re: [DISCUSS] 1.15.0 release

7DV93bSsGRRhvRphMOTQ=PJQNlV5Bxt1H5tFRor8AdoKKAyh9HDC1lheQrDoK4TQ= > > > >>> > > > > >>> > Kind regards > > > >>> > Vitalii > > > >>> > > > > >>> > > > > >>> > On Wed, Nov 7, 2

Re: [DISCUSS] Resurrect support for Table Statistics in Drill

Hi Paul, Thanks so much for the feedback. Please see my responses below. To take a step back, recall that Arina is working on a metadata proposal. A > key aspect of that proposal is that it provides an API so that Drill can > connect (via an adapter) to any metadata system. The gist of my

[jira] [Created] (DRILL-6841) Statistics ANALYZE statement should be more flexible

Gautam Parai created DRILL-6841: --- Summary: Statistics ANALYZE statement should be more flexible Key: DRILL-6841 URL: https://issues.apache.org/jira/browse/DRILL-6841 Project: Apache Drill

Re: [DISCUSS] Resurrect support for Table Statistics in Drill

rFQ=Ff9ubGKUQTI0u7uQ2BvlrxfKnDg6zhLL0XoTBAbkwAY=kBFloq2EVOAYXO-O7d19Oe-dug40ZW3Lili5D1ipJ5A= > > > Kind regards > Vitalii > > > On Tue, Nov 6, 2018 at 1:47 AM Parth Chandra wrote: > > > +1 > > I'd say go for it. > > If the option to use enhanced stats an be turn

Re: [DISCUSS] 1.15.0 release

Hi Vitalii, Thanks for volunteering to be the release manager! I am currently working on DRILL-6770( https://issues.apache.org/jira/browse/DRILL-6770) which is upgrading the MapR/OJAI versions. We are running into some wrong results issues and I am actively working on it. I think we should

[jira] [Created] (DRILL-6833) MapRDB queries with Run Time Filters with row_key/Secondary Index Should Support Pushdown

Gautam Parai created DRILL-6833: --- Summary: MapRDB queries with Run Time Filters with row_key/Secondary Index Should Support Pushdown Key: DRILL-6833 URL: https://issues.apache.org/jira/browse/DRILL-6833

[DISCUSS] Resurrect support for Table Statistics in Drill

Hi all, I had an initial implementation for statistics support for Drill [DRILL-1328] . This JIRA has links to the design spec as well as the PR. Unfortunately, because of some regressions on performance benchmarks (TPCH/TPCDS) we decided to

Re: [ANNOUNCE] New Committer: Hanumath Rao Maduri

Congratulations Hanumath! Well deserved :) Gautam On Thu, Nov 1, 2018 at 9:44 AM AnilKumar B wrote: > Congratulations Hanumath. > > Thanks & Regards, > B Anil Kumar. > > > On Thu, Nov 1, 2018 at 9:39 AM Vitalii Diravka wrote: > > > Congratulations! > > > > Kind regards > > Vitalii > > > > > >

[jira] [Created] (DRILL-6824) Drill Query on MapRDB JSON table failing on schema SchemaChangeException, the only distinct Values are NULL and Text

Gautam Parai created DRILL-6824: --- Summary: Drill Query on MapRDB JSON table failing on schema SchemaChangeException, the only distinct Values are NULL and Text Key: DRILL-6824 URL: https://issues.apache.org/jira

Re: [ANNOUNCE] New Committer: Gautam Parai

; > > > > > > Congratulations, Gautam! > > > > > > > > On 10/22/2018 10:02:46 AM, Paul Rogers > > > > > > > > > > > > wrote: > > > > > > > > Congrats Guatam! > > > > &

Re: Problem of adding support for CROSS JOIN syntax

Hi Igor, I saw Arina discuss/propose adding hint support through Calcite. This would definitely be useful for the usecase you were trying to target. This will allow the user to selectively apply cross joins without actually overloading the meaning on "CROSS JOIN" to bypass the

Re: [ANNOUNCE] New Committer: Chunhui Shi

Congratulations Chunhui!! Well-deserved :) On Fri, Sep 28, 2018 at 11:12 AM Aman Sinha wrote: > Congratulations Chunhui ! > > On Fri, Sep 28, 2018 at 10:46 AM Karthikeyan Manivannan < > kmanivan...@mapr.com> wrote: > > > Congrats Chunhui! > > > > On Fri, Sep 28, 2018 at 10:04 AM Hanumath Rao

Re: Problem of adding support for CROSS JOIN syntax

Hello Ihor, Welcome to the Drill community!! I would re-think the motivation for this JIRA. Calcite does not distinguish between the comma-separated and CROSS JOIN ways as you pointed out precisely because they are the same! It seems like you want to provide a mechanism to by-pass the

Re: [DISCUSS] Drill Hackathon/Drill Developers Day - 2018!

Charles Givre > wrote: > >>> > >>> HI there, > >>> I am interested in attending, but it may have to be virtual as I am > based > >>> in DC. I’d love to hear about (and possibly present) use cases of how > >>> Drill is actually being

[DISCUSS] Drill Hackathon/Drill Developers Day - 2018!

Hi Drill Developers, It has already been one year since our last Drill Hackathon/Developers Day! I would like to get the ball rolling for this year's Drill Developer Day ™. The tentative date is Nov 14 (Wednesday). The goal is to get the community together for a half-day long technical

Re: [ANNOUNCE] New PMC member: Volodymyr Vysotskyi

Congratulations Vova! Gautam On Fri, Aug 24, 2018 at 10:59 AM, Khurram Faraaz wrote: > Congratulations Volodymyr! > > Regards, > Khurram > > On Fri, Aug 24, 2018 at 10:25 AM, Hanumath Rao Maduri > wrote: > > > Congratulations Volodymyr! > > > > Thanks, > > -Hanu > > > > On Fri, Aug 24, 2018

Re: [ANNOUNCE] New PMC member: Boaz Ben-Zvi

Congratulations Boaz!! Gautam On Fri, Aug 17, 2018 at 11:04 AM, Khurram Faraaz wrote: > Congratulations Boaz. > > On Fri, Aug 17, 2018 at 10:47 AM, shi.chunhui < > shi.chun...@aliyun.com.invalid> wrote: > > > Congrats Boaz! > > --

Re: Drill Hangout tomorrow 08/07

Thanks everyone for joining the hangout. Attendees : Boaz, Vitalii, Vova, Gautam Vitalii is facing an issue with Zookeeper - he will post it on the user mailing lists. There were no other topics. Gautam On Mon, Aug 6, 2018 at 10:54 AM, Gautam Parai wrote: > The Apache Drill Hang

Drill Hangout tomorrow 08/07

The Apache Drill Hangout will be held tomorrow at 10:00am PST; please let us know should you have a topic for tomorrow's hangout. We will also ask for topics at the beginning of the hangout. Hangout Link - https://hangouts.google.com/hangouts/_/event/ci4rdiju8bv04a64efj5fedd0lc Regards, Gautam

Re: [ANNOUNCE] New PMC Chair of Apache Drill

Congratulations Arina! Gautam On Wed, Jul 18, 2018 at 4:03 PM, Boaz Ben-Zvi wrote: >"plus one" more congratulations > > > > On 7/18/18 3:20 PM, Parth Chandra wrote: > >> Congratulations >> >> On Wed, Jul 18, 2018 at 3:14 PM, Kunal Khatua wrote: >> >> Congratulations, Arina ! >>> On

Re: [ANNOUNCE] New PMC member: Vitalii Diravka

Congratulations Vitalii! Gautam On Tue, Jun 26, 2018 at 11:48 AM, Volodymyr Vysotskyi wrote: > Congratulations, Vitalii! > > Kind regards, > Volodymyr Vysotskyi > > > вт, 26 черв. 2018 о 21:38 Robert Wu пише: > > > Congratulations, Vitalii! > > > > Best regards, > > > > Rob > > > >

Re: [ANNOUNCE] New Committer: Padma Penumarthy

Congratulations Padma!! Gautam From: Vlad Rozov Sent: Friday, June 15, 2018 11:56:37 AM To: dev@drill.apache.org Subject: Re: [ANNOUNCE] New Committer: Padma Penumarthy Congrats Padma! Thank you, Vlad On 6/15/18 11:38, Charles Givre wrote: > Congrats

Re: [ANNOUNCE] New Committer: Timothy Farkas

Congratulations Tim! Gautam From: Sorabh Hamirwasia Sent: Friday, May 25, 2018 12:44:47 PM To: dev@drill.apache.org Subject: Re: [ANNOUNCE] New Committer: Timothy Farkas Congratulations Tim! Thanks, Sorabh

Re: [HANGOUT] Topics for May 15 2018

Hangout link: https://urldefense.proofpoint.com/v2/url?u=https-3A__plus.google.com_hangouts_-5F_event_ci4rdiju8bv04a64efj5fedd0lc=DwIFAw=cskdkSMqhcnjZxdQVpwTXg=jGaWXfAULy7L7yLSDM6rFQ=WED3lepY_zTnY-lDfHxhDWIlMw3VKANkW0iQu5FFrkI=N0UtWs-KDoE5koI9hSiULag28iNA5JJfXOLB5JnNv-0=

[HANGOUT] Topics for 05/01/2018

Hi all, We will have a Drill hangout tomorrow (Tuesday May 1) at 10 AM Pacific Time. Please suggest topics by replying to this thread or bring them up during the hangout. Hangout link: https://plus.google.com/hangouts/_/event/ci4rdiju8bv04a64efj5fedd0lc Thanks, Gautam

Re: [ANNOUNCE] New Committer: Sorabh Hamirwasia

Congratulations Sorabh! Well deserved. Gautam From: rahul challapalli Sent: Monday, April 30, 2018 11:09:24 AM To: dev Subject: Re: [ANNOUNCE] New Committer: Sorabh Hamirwasia Congratulations Sorabh! On Mon, Apr 30, 2018 at 11:07

Re: [DISCUSS] Regarding mutator interface

ode trying to set? Thanks, - Paul On Wednesday, April 11, 2018, 12:33:52 PM PDT, Padma Penumarthy <ppenumar...@mapr.com> wrote: Can you explain how aggregation on complex type works (or supposed to work). Thanks Padma > On Apr 11, 2018, at 12:15 PM, Gautam Parai <gpa...@m

[DISCUSS] Regarding mutator interface

Hi all, I am implementing a new aggregate function which also handles Complex types (map and list). However, the codegen barfs with CompileException: Line 104, Column 39: A method named "setSafe" is not declared in any enclosing class nor any supertype, nor through a static import It looks

Re: Issue in accessing ORC transactional table through apache drill

>From the error it seems like Drill barfs when trying to convert "112_" >to a number which would be expected? I am not familiar with Hive ORC but maybe >you could (temporarily) remove the offending row and try it? Gautam From: Smruti Ranjan

Re: [ANNOUNCE] New Committer: Volodymyr Vysotskyi

Congratulations Volodymyr! Gautam From: Timothy Farkas Sent: Thursday, March 15, 2018 11:10:40 AM To: dev@drill.apache.org Subject: Re: [ANNOUNCE] New Committer: Volodymyr Vysotskyi Congratulations Volodymyr!

Re: [ANNOUNCE] New Committer: Kunal Khatua

Congratulations Kunal! From: rahul challapalli Sent: Tuesday, February 27, 2018 10:53:37 AM To: dev Subject: Re: [ANNOUNCE] New Committer: Kunal Khatua Congratulations Kunal! On Tue, Feb 27, 2018 at 10:52 AM, Pritesh Maker

Re: How to get org.apache.calcite of calcite for drill

Drill uses its own fork of Calcite. You could open a JIRA in Apache Calcite and commit the changes, then port those back to Drill's forked version - a committer can help you in porting/deploying the new JAR with your changes (which will also bump up the version e.g. from r23 to r24). With the

Re: [ANNOUNCE] New PMC member: Paul Rogers

Congratulations Paul! From: Timothy Farkas Sent: Tuesday, January 30, 2018 1:54:43 PM To: dev@drill.apache.org Subject: Re: [ANNOUNCE] New PMC member: Paul Rogers Congrats! From: Aman Sinha

Re: DRILL-5214

Hi Dor, DRILL-5214 is dependent on DRILL-1328 which is not present in Apache Master. So the underlying issue might not be the same. Could you please share more details e.g. the query and any query options you maybe using? Gautam From: Dor Ben Dov

Re: [ANNOUNCE] New Committer: Boaz Ben-Zvi

Congratulations Boaz! Thank you for your contributions. Gautam From: Abhishek Girish Sent: Wednesday, December 13, 2017 10:24:30 AM To: dev@drill.apache.org Subject: Re: [ANNOUNCE] New Committer: Boaz Ben-Zvi Congratulations Boaz! On Wed,

Re: [ANNOUNCE] New Committer: Vitalii Diravka

Congratulations Vitalii! Gautam From: Vitalii Diravka Sent: Monday, December 11, 2017 2:36:00 AM To: dev@drill.apache.org Subject: Re: [ANNOUNCE] New Committer: Vitalii Diravka Thanks to everyone! I highly appreciate the opportunity

[HANGOUT] Topics for 10/31/2017

Hi, We will have a Drill hangout tomorrow (Tuesday Oct 31) at 10 AM Pacific Time. Please suggest topics by replying to this thread or bring them up during the hangout. Hangout link: https://plus.google.com/hangouts/_/event/ci4rdiju8bv04a64efj5fedd0lc Thanks, Gautam

Re: [ANNOUNCE] New PMC member: Arina Ielchiieva

Congratulations Arina and thanks for your contributions to Drill! Gautam From: Bridget Bevens Sent: Wednesday, August 2, 2017 12:15:11 PM To: dev Subject: Re: [ANNOUNCE] New PMC member: Arina Ielchiieva Congratulations, Arina!!!

Re: Question about Kudu Storage and storages in general

Hi Cliff, Thanks and let us know how it goes on the colocated cluster. It would be great if you could share your usecase with the community. We always look forward to contributions from the community. Gautam From: Clifford Resnick

Re: [ANNOUNCE] New PMC Chair of Apache Drill

Congratulations Aman! Gautam From: Jinfeng Ni Sent: Friday, June 23, 2017 12:54:53 PM To: dev Subject: Re: [ANNOUNCE] New PMC Chair of Apache Drill Congratulations, Aman! On Fri, Jun 23, 2017 at 12:54 PM, Kunal Khatua

Re: [HANGOUT] Topics for 05/30/17

From: Gautam Parai <gpa...@mapr.com> Sent: Monday, May 29, 2017 12:59:37 PM To: dev@drill.apache.org; u...@drill.apache.org Subject: [HANGOUT] Topics for 05/30/17 Hi Drillers, The bi-weekly Drill hangout is scheduled for tomorrow (05/30/17 10 AM PT). Please suggest

[HANGOUT] Topics for 05/30/17

Hi Drillers, The bi-weekly Drill hangout is scheduled for tomorrow (05/30/17 10 AM PT). Please suggest topics by adding them to this thread. We will also ask for topics at the beginning of the hangout. Thanks, Gautam

Re: Drill custome function query

Hi Honey, Can you try using the ObjectHolder instead? Please let us know if it resolve the issue. Gautam From: honey francis Sent: Thursday, May 25, 2017 12:41:03 AM To: dev@drill.apache.org Subject: Drill custome function query

Re: [ANNOUNCE] New Committer: Paul Rogers

Congratulations Paul and thank you for your contributions! Gautam From: Abhishek Girish Sent: Friday, May 19, 2017 8:27:05 AM To: dev@drill.apache.org Subject: Re: [ANNOUNCE] New Committer: Paul Rogers Congrats Paul! On Fri, May 19, 2017

Re: Running cartesian joins on Drill

Can you please specify the query you are trying to execute? Gautam From: Muhammad Gelbana Sent: Saturday, May 6, 2017 7:34:53 AM To: u...@drill.apache.org; dev@drill.apache.org Subject: Running cartesian joins on Drill Is there a reason

Re: [VOTE] Release Apache Drill 1.10.0 - rc0

+1 (non-binding) Downloaded and built from src on Linux. Ran unit tests and several sample queries in Drill embedded mode. Gautam From: Parth Chandra Sent: Sunday, March 12, 2017 12:47:35 PM To: dev@drill.apache.org Subject: Re: [VOTE]

Re: 1.10 release

Hi Parth, We are currently in the code review phase for the `statistics` work. I think I should be done by end of February. Gautam From: Parth Chandra Sent: Monday, February 6, 2017 10:09:50 AM To: dev@drill.apache.org Subject: 1.10

Re: Drill Hangout 2/7/2017

Hi Jasbir, Which version of Drill are you using? This issue was fixed in 1.8.0. Please see DRILL-3710 As Jinfeng mentioned, the default value of `planner.in_subquery_threshold` is 20. So you should see the Join plan for ~300 in clause size.

Re: Join keys should be converted to target type

Hi Flow, This happens because Drill is using a hash join based plan where '1', '2' are used to build the hash table(CHAR) which is probed using m1 which is BIGINT. Hence, the complaint. You could a) rewrite the query as select count(*) from `test` where cast(m1 as CHAR(2)) in

Re: [VOTE] Release Apache Drill 1.9.0 RC2

+1 (non-binding) built from source. ran unit tests. ran fixed-bugs (Drill-4862, 4906, 4763, 4986 , 4927) queries. ran some random queries. Sudheesh, Should we remove Drill-4941, Drill-4525 from the Release Notes as they are not fixed? Gautam On Mon, Nov 21, 2016 at 9:19 AM, Parth Chandra

Re: [VOTE] Release Apache Drill 1.9.0 RC1

+1 (non-binding) Built from source on Linux VM and Mac. Ran unit tests. Ran new tests derived from bugs (Drill-4986/Drill-4771/Drill- 4792/Drill-4927) Ran some random queries Found a potential bug (NON-blocker) in Drill-4792. LGTM On Wed, Nov 16, 2016 at 5:52 PM, Kunal Khatua

[HANGOUT] Suggestions for topics for 11/15

Hi all, The bi-weekly hangout is tomorrow (11/15/16, 10 AM PST). If you have any suggestions for topics for tomorrow, please add to this thread. We will also ask for topics at the beginning of the hangout. Hangout link: https://hangouts.google.com/hangouts/_/event/ci4rdiju8bv04a64efj5fedd0lc

Re: Proposed November report for Drill

+1 On Tue, Nov 8, 2016 at 9:59 AM, Jinfeng Ni wrote: > +1 > > > > On Tue, Nov 8, 2016 at 9:31 AM, Sudheesh Katkam > wrote: > > +1 > > > >> On Nov 7, 2016, at 10:35 PM, Parth Chandra wrote: > >> > >> Hi Drill devs, > >> > >> Below is

Re: [DISCUSS] - Design Docs

Thanks so much for writing design documents for complex projects! They are very helpful in learning about Drill Internals especially for new contributors like me - most recently Drill 4280. The design document template [2] looks good to me. For the reviews, I like Google Docs since it makes the

Re: [VOTE] Release Apache Drill 1.8.0 - rc1

+1 Built from src, ran all unit tests on the linux VM. Checked signature and checksums. Ran tests for a few bugs which were fixed in the release. LGTM. On Sat, Aug 27, 2016 at 10:00 AM, Dechang Gu wrote: > +1 > Build from src, ran tpch queries and a bunch of other > queries.

Re: Suggestions for hangout topics for 08/09

mal implementation is vulnerable to overflow errors - To address issues and simplify implementation Aman - Good idea to look at previous design TODO: Parth/Aman Attach - Mehant's doc to JIRA Please correct me if I missed anything. Gautam On Tue, Aug 9, 2016 at 9:59 AM, Gautam Parai <gpa...@maprte

Re: Suggestions for hangout topics for 08/09

estions about Subbu's pull request? > > > > -- Zelaine > > > > > > On Mon, Aug 8, 2016 at 11:33 AM, Gautam Parai <gpa...@maprtech.com> > wrote: > > > >> Tomorrow's hangout is scheduled for 10AM - 11AM PST > >> > >> On Mon, Aug 8, 20

Re: Suggestions for hangout topics for 08/09

Tomorrow's hangout is scheduled for 10AM - 11AM PST On Mon, Aug 8, 2016 at 11:30 AM, Subbu Srinivasan <ssriniva...@zscaler.com> wrote: > What time is tomorrow's mtg scheduled for? > > > On Mon, Aug 8, 2016 at 10:48 AM, Gautam Parai <gpa...@maprtech.com> wrote: > >

Suggestions for hangout topics for 08/09

If you have any suggestions for Drill hangout topics for tomorrow, you can add it to this thread. We will also ask around at the beginning of the hangout for any topics. We will try to cover whatever possible during the 1 hr. Topics: 1. DRILL-4653: Malformed JSON should not stop the entire

[Drill-1328] Design Review - Compute and use statistics in Drill

Hi all, I have uploaded a design specification for Drill-1328 Compute and use statistics in Drill. The goal is to provide statistics support in Drill which will help build better plans in Drill. This design borrows ideas from the earlier design. However, we try to address some concerns in the

Re: median, quantile

As Julian mentioned, an optional APPROXIMATE clause along with a session/system setting looks like the best option to me. Exposing the algorithm in the name does not make sense - we might want to replace it with a new one in the future. However, there might be different approaches e.g. Oracle uses