I think this is a great idea. +1 for the online meetup.
If there are slots left I can also talk about how Hive leverages Calcite to
do query optimization.
-Vineet
On Fri, Nov 6, 2020 at 7:21 AM Stamatis Zampetakis
wrote:
> Let's try to fix the date/time and tentative agenda so that we can add
Vineet Garg created CALCITE-3952:
Summary: Improve SortRemoveRule to remove Sort based on rowcount
Key: CALCITE-3952
URL: https://issues.apache.org/jira/browse/CALCITE-3952
Project: Calcite
Vineet Garg created CALCITE-3914:
Summary: Improve SubsitutionVisitor to consider RexCall of type
PLUS and TIMES for canonicalization
Key: CALCITE-3914
URL: https://issues.apache.org/jira/browse/CALCITE-3914
Vineet Garg created CALCITE-3862:
Summary: Rewriting for materialized view consisting of group by on
join keys with aggregate fails
Key: CALCITE-3862
URL: https://issues.apache.org/jira/browse/CALCITE-3862
Vineet Garg created CALCITE-3848:
Summary: Materialized view rewriting fails for mv consisting of
group by on join keys
Key: CALCITE-3848
URL: https://issues.apache.org/jira/browse/CALCITE-3848
Vineet Garg created CALCITE-3824:
Summary: JoinProjectTransposeRule should skip Projects containing
windowing expression
Key: CALCITE-3824
URL: https://issues.apache.org/jira/browse/CALCITE-3824
Vineet Garg created CALCITE-3734:
Summary: MySQL JDBC rewrite is producing queries with CHAR with
range beyond 255
Key: CALCITE-3734
URL: https://issues.apache.org/jira/browse/CALCITE-3734
Project
Vineet Garg created CALCITE-3733:
Summary: MySQL JDBC rewrite should rewrite CAST as TIMESTAMP to
CAST as DATETIME
Key: CALCITE-3733
URL: https://issues.apache.org/jira/browse/CALCITE-3733
Project
Vineet Garg created CALCITE-3222:
Summary: Fix code style issues introduced by CALCITE-3031
Key: CALCITE-3222
URL: https://issues.apache.org/jira/browse/CALCITE-3222
Project: Calcite
Issue
qldb:
>
> > select count(*) from "foodmart"."days" where false group by true;
> +-+
> | C1|
> +-+
> +-+
> No rows selected (0.001 seconds)
>
>
> Julian
>
>
> > On Jun 26, 201
urther fixed by
HIVE-21539 <https://issues.apache.org/jira/browse/HIVE-21539>.
Regards,
Vineet Garg
On Wed, Jun 26, 2019 at 7:08 AM Haisheng Yuan
wrote:
> Calcite has the rule that does the work. But you can't remove the group by
> clause if the constant is the only group key. The sem
Vineet Garg created CALCITE-3132:
Summary: Simply expressions in LogicalFilter generated for
subqueries with quantified predicate
Key: CALCITE-3132
URL: https://issues.apache.org/jira/browse/CALCITE-3132
I also converted to wrong time and ended up missing the call. I'll try to
join the next one.
On Thu, May 2, 2019 at 10:29 AM Haisheng Yuan
wrote:
> Sorry, I missed the call. Converted to wrong time. Will join next party.
>
> Thanks ~
> Haisheng Yuan
>
Hi,
I am only contributor but I would like to join the party.
*pub* 4096R/600252AE
<http://keys.gnupg.net/pks/lookup?op=get=0x99B92500600252AE>
2018-05-18
Fingerprint=65DA 42EC 10B7 95CB 0888 E545 99B9 2500 6002 52AE
*uid* Vinee
Vineet Garg created CALCITE-3028:
Summary: Support FULL OUTER JOIN with AggregateJoinTransposeRule
Key: CALCITE-3028
URL: https://issues.apache.org/jira/browse/CALCITE-3028
Project: Calcite
Congratulations Chunwei!
On Sat, Apr 27, 2019 at 11:20 AM Kevin Risden wrote:
> Congrats and welcome!
>
> Kevin Risden
>
>
> On Sat, Apr 27, 2019 at 11:36 AM Stamatis Zampetakis
> wrote:
>
> > It's great to have you onboard Chunwei!
> >
> > I would love to see some those of optimizations land
Congratulations Ruben.
On Sat, Apr 27, 2019 at 11:19 AM Kevin Risden wrote:
> Congrats and welcome!
>
> Kevin Risden
>
>
> On Sat, Apr 27, 2019 at 1:48 PM Ruben Q L wrote:
>
> > Thank you everyone for your kind messages.
> >
> > Currently I am working with Stamatis in the Core Engine team at
Congratulations Stamatis!
On Fri, Apr 26, 2019 at 7:44 PM Francis Chuang
wrote:
> I'm pleased to announce that Stamatis has accepted an invitation to
> join the Calcite PMC. Stamatis has been a consistent and helpful
> figure in the Calcite community for which we are very grateful. We
> look
Vineet Garg created CALCITE-3012:
Summary: areColumnsUnique for FULL OUTER JOIN could return wrong
answer when ignoreNulls is false
Key: CALCITE-3012
URL: https://issues.apache.org/jira/browse/CALCITE-3012
Vineet Garg created CALCITE-3011:
Summary: Support for outer joins with AggregateJoinTransposeRule
Key: CALCITE-3011
URL: https://issues.apache.org/jira/browse/CALCITE-3011
Project: Calcite
OIN,
SEMI JOIN or Nested loop join but I don't believe any of them will produce
correct semantics.
Does anyone know what is the correct rewrite for <>ANY?
P.S. Can someone review pull request to fix =ANY rewrite? - #1161
<https://github.com/apache/calcite/pull/1161>
Thanks,
Vineet Garg
Vineet Garg created CALCITE-2991:
Summary: getMaxRowCount should return rowcount 1 for an aggregate
with constant keys
Key: CALCITE-2991
URL: https://issues.apache.org/jira/browse/CALCITE-2991
Vineet Garg created CALCITE-2971:
Summary: Correlated subquery in JOIN is failing
Key: CALCITE-2971
URL: https://issues.apache.org/jira/browse/CALCITE-2971
Project: Calcite
Issue Type: Bug
Vineet Garg created CALCITE-2954:
Summary: SubQueryJoinRemoveRule and SubQueryProjectRemoveRule
passing on empty set instead of set of correlation id
Key: CALCITE-2954
URL: https://issues.apache.org/jira/browse
Vineet Garg created CALCITE-2874:
Summary: NOT IN correlated subquery has un-necessary join
Key: CALCITE-2874
URL: https://issues.apache.org/jira/browse/CALCITE-2874
Project: Calcite
Issue
Hello devs,
I’ll really appreciate if someone can take a look at this pull request
(https://github.com/apache/calcite/pull/1035)
Thanks,
Vineet Garg
On Feb 7, 2019, at 9:00 PM, GitBox mailto:g...@apache.org>>
wrote:
vineetgarg02 opened a new pull request #1035: [CALCITE-1726] Su
e
> core/target/test-classes/sql/surefire/sql/agg.iq with which you can overwrite
> (if you choose) the original script file core/src/test/resources/sql/agg.iq.
>
> Julian
>
>
>> On Jan 30, 2019, at 5:42 PM, Vineet Garg wrote:
>>
>> Hello all,
>&
Hello all,
How do I run a particular (e.g. sql/dummy.iq) test (with debug mode on)?
I have run these tests in the past but I can’t seem to recall how did I manage
to run it.
Thanks,
Vineet G
Hive actually does this optimization (it is called semi-join reduction) by
generating bloom-filters on one side and passing it on to the other side.
This is not a rewrite but instead a physical implementation.
Vineet
On Aug 29, 2018, at 10:34 AM, Vladimir Sitnikov
My bad. Please ignore this.
Sorry about that!
Vineet
> On Jul 18, 2018, at 5:30 PM, Julian Hyde wrote:
>
> Vineet, I think you meant to send this to dev@hive, not dev@calcite.
>
> (Can you send a [CANCEL], please!)
>
>
>> On Jul 18, 2018, at 5:25 PM, Vineet Garg
Apache Hive 3.1.0 Release Candidate 0 is available here:
http://people.apache.org/~vgarg/apache-hive-3.1.0-rc-0
Maven artifacts are available here:
https://repository.apache.org/content/repositories/orgapachehive-1089/
Source tag: https://github.com/apache/hive/tree/release-3.1.0-rc0
Voting
Vineet Garg created CALCITE-1726:
Summary: Subquery in FILTER is left untransformed
Key: CALCITE-1726
URL: https://issues.apache.org/jira/browse/CALCITE-1726
Project: Calcite
Issue Type
> https://calcite.apache.org/testapidocs/org/apache/calcite/test/QuidemTest.html
>
> [2]
> https://calcite.apache.org/testapidocs/org/apache/calcite/test/QuidemTest.html#main-java.lang.String:A-
>
> On Thu, Feb 23, 2017 at 6:00 PM, Vineet Garg <vg...@hortonworks.com> w
Vineet Garg created CALCITE-1624:
Summary: Inefficient plan for NOT IN correlated subqueries
Key: CALCITE-1624
URL: https://issues.apache.org/jira/browse/CALCITE-1624
Project: Calcite
Issue
Vineet Garg created CALCITE-1605:
Summary: Wrong result/plan for correlated subquery with windowing
Key: CALCITE-1605
URL: https://issues.apache.org/jira/browse/CALCITE-1605
Project: Calcite
Vineet Garg created CALCITE-1583:
Summary: Wrong results for query with correlated subqueries with
aggregate subquery expression
Key: CALCITE-1583
URL: https://issues.apache.org/jira/browse/CALCITE-1583
Vineet Garg created CALCITE-1546:
Summary: Wrong result/plan for NOT IN subqueries with disjunction
Key: CALCITE-1546
URL: https://issues.apache.org/jira/browse/CALCITE-1546
Project: Calcite
Vineet Garg created CALCITE-1542:
Summary: Update RelShuttle interface to work on Filter, Join etc
instead of Logical rel nodes
Key: CALCITE-1542
URL: https://issues.apache.org/jira/browse/CALCITE-1542
Vineet Garg created CALCITE-1541:
Summary: Update RelDecorrelator to work on Filter, Join, Project
etc
Key: CALCITE-1541
URL: https://issues.apache.org/jira/browse/CALCITE-1541
Project: Calcite
so only running on
>logical rels was never a hardship. Also, very few physical algebras even
>support correlation, so RelDecorrelator would be a no-op on these.
>
>Please log a JIRA case.
>
>Julian
>
>
>
>
>> On Dec 15, 2016, at 9:33 AM, Vineet Garg <vg...
Hi Julian,
Reldecorrelator’s logic including all rules implemented within it are written
to take LogicalJoin, LogicalFilter, LogicalProject etc. Since Logical operators
are final that makes extending RelDecorrelator very difficult. Is there any
reason why RelDecorrelator is written in this
Vineet Garg created CALCITE-1537:
Summary: Un-necessary project expression in multi-subquery plan
Key: CALCITE-1537
URL: https://issues.apache.org/jira/browse/CALCITE-1537
Project: Calcite
l.com> wrote:
>
>> Also for Storm. I also would like to see the chance to have 1.11.0. Does
>> Calcite have a milestone or TODO issues for 1.11.0?
>>
>> Thanks in advance,
>> Jungtaek Lim (HeartSaVioR)
>>
>> 2016년 12월 7일 (수) 오전 10:35, Vineet Garg <vg
Hello Julian/Jesus,
We would like to test Calcite’s latest snapshot (nightly builds) against HIVE.
I tried searching on apache repository but I only see releases until 1.10. Does
Calcite build and publish daily snapshots ? If not is it possible to do so ?
Thanks,
Vineet Garg
Vineet Garg created CALCITE-1511:
Summary: RelDecorrelator's allLessThan failing for NOT EXISTS
subquery
Key: CALCITE-1511
URL: https://issues.apache.org/jira/browse/CALCITE-1511
Project: Calcite
Vineet Garg created CALCITE-1495:
Summary: Add a rule to convert INNER JOIN preceded by GROUP BY to
appropriate SEMI-JOIN
Key: CALCITE-1495
URL: https://issues.apache.org/jira/browse/CALCITE-1495
Vineet Garg created CALCITE-1494:
Summary: Inefficient plan for co-related subqueries
Key: CALCITE-1494
URL: https://issues.apache.org/jira/browse/CALCITE-1494
Project: Calcite
Issue Type
Vineet Garg created CALCITE-1493:
Summary: Wrong plan for NOT IN correlated queries
Key: CALCITE-1493
URL: https://issues.apache.org/jira/browse/CALCITE-1493
Project: Calcite
Issue Type: Bug
I logged in jira CALCITE-1483 for the query in question. I’ll try to find more
examples.
On 11/7/16, 9:17 PM, "Vineet Garg" <vg...@hortonworks.com> wrote:
>Hi Julian,
>
>Apologies for not responding earlier.
>
>I understand that planner rules sometime prod
Vineet Garg created CALCITE-1483:
Summary: Suboptimal plan for NOT IN query
Key: CALCITE-1483
URL: https://issues.apache.org/jira/browse/CALCITE-1483
Project: Calcite
Issue Type: Bug
Hi Julian,
During my work on subquery support in Hive I am running into similar issue with
almost same query where the CASE statement [NOT(CASE(=($1, 0), false, IS NOT
NULL($5), true, IS NULL($3), null, <($2, $1), null, false))] is generated with
a null constant expression but with NULL type.
Never mind I figured it out by looking at Calcite tests :)
On 9/22/16, 9:26 PM, "Vineet Garg" <vg...@hortonworks.com> wrote:
>Hi Julian,
>
>Thank you for your response. I have few follow-up questions:
>
>Yes. Remember it should return only the correlating
Hello Julian/Calcite community,
I am working on adding subquery support in HIVE using calcite. From what I
have read/understood so far Calcite requires HIVE to create RexSubqueryNode
corresponding to a subquery and then call SubQueryRemoveRule to get rid of
RexSubqueryNode and change it to
53 matches
Mail list logo