Re: ANALYZE TABLE

2018-09-20 Thread Gautam Parai
Oracle no longer recommends using ANALYZE TABLE except for certain cases and for preserving backwards compatibility. Instead, they now have a DBMS_STATS package with several methods for collecting statistics. [1] ALTER TABLE is usually associated with DDLs. If several projects/vendors already use

Re: [ANNOUNCE] Volodymyr Vysotskyi joins Calcite PMC

2018-07-09 Thread Gautam Parai
Congratulations Vova!! Gautam On Mon, Jul 9, 2018 at 7:53 AM, Julian Hyde wrote: > Well deserved. Thanks for all your work making the project great, > Volodymyr! > > > On Jul 9, 2018, at 7:36 AM, Aman Sinha wrote: > > > > Congratulations Volodymyr ! > > > > > > On Mon, Jul 9, 2018 at 7:09 AM

[CODE REVIEW] CALCITE-2366

2018-06-18 Thread Gautam Parai
1. Hello committers! Could someone please review the PR for CALCITE-2366? Here is the link: https://github.com/apache/calcite/pull/735 Please let me know if you have any questions. Thanks, Gautam

Re: JoinPushTransitivePredicatesRule

2017-08-30 Thread Gautam Parai
Hi Michael, Do you see a filter pushdown with the following query? select * from T1 inner join T2 on T1.C = T2.C1 where T2.C2 > 0; Gautam From: Michael Alexeev Sent: Wednesday, August 30, 2017 5:58:04 PM To: dev@calcite.apache.org

Re: Column missing from COUNT(column)

2017-02-02 Thread Gautam Parai
The same query on Drill executes correctly. Hence, the logical plan should be correct. Maybe the COUNT(sal) converted to COUNT(*) because sal is NOT NULL. From: Eli Levine Sent: Thursday, February 2, 2017 2:29:06 PM To: