[jira] [Created] (CALCITE-3149) CACHE in RelDataTypeFactoryImpl can't be garbage collected

2019-06-26 Thread Haisheng Yuan (JIRA)
Haisheng Yuan created CALCITE-3149: -- Summary: CACHE in RelDataTypeFactoryImpl can't be garbage collected Key: CALCITE-3149 URL: https://issues.apache.org/jira/browse/CALCITE-3149 Project: Calcite

[jira] [Created] (CALCITE-3148) Validator throws IndexOutOfBoundsException for SqlInsert when source and sink have non-equal fields number

2019-06-26 Thread Danny Chan (JIRA)
Danny Chan created CALCITE-3148: --- Summary: Validator throws IndexOutOfBoundsException for SqlInsert when source and sink have non-equal fields number Key: CALCITE-3148 URL:

Re: Modify Calcite Planner in Hive to remove GROUP BY

2019-06-26 Thread Vineet Garg
Hi Julian, You are right it should produce zero rows not NULL. Thanks for the correction. Vineet On Wed, Jun 26, 2019 at 4:49 PM Julian Hyde wrote: > > Select count(*) from empty_table group by will produce NULL > > Really? I thought it should produce zero rows. > > Hsqldb: > > > select

Re: Giving the Calcite logo some love

2019-06-26 Thread Michael Mior
The easiest approach is to convert the fonts to curves. Whatever editing software you use should be able to do this, but I agree with Julian that it's not critical. Thanks for working on this! -- Michael Mior mm...@apache.org Le mer. 26 juin 2019 à 18:45, Stamatis Zampetakis a écrit : > > I did

Re: Modify Calcite Planner in Hive to remove GROUP BY

2019-06-26 Thread Julian Hyde
> Select count(*) from empty_table group by will produce NULL Really? I thought it should produce zero rows. Hsqldb: > select count(*) from "foodmart"."days" where false group by true; +-+ | C1| +-+ +-+ No rows selected (0.001

Re: Giving the Calcite logo some love

2019-06-26 Thread Julian Hyde
I’m not too worried about fonts. I assume that we can generate PNGs from the SVGs and those PNGs will render the same on all platforms. It makes our decision-making a little more complex, because people on Linux/Windows may not be seeing the exact product, but it’s good enough. > On Jun 26,

Re: Giving the Calcite logo some love

2019-06-26 Thread Stamatis Zampetakis
I did my best to fix the problems with the fonts but I have no other OS at the moment to see if the problems disappeared. I also added two new variants (5G and 5H) based on the suggestions so far. Apologies for the multiple emails but I was not meant to be a designer :) On Wed, Jun 26, 2019 at

Re: How to do SemiJoin?

2019-06-26 Thread Chia-Hung Lin
It looks like the operation is done by 1. Build main query * `main query= builder.scan(table name).build` 2. Then push the main table * `builder.push(main query)` 3. Build subquery * `sub query = builder.scan().filter().build` 4. Push the subquery * `builder.push(sub query)` 5.

Re: Modify Calcite Planner in Hive to remove GROUP BY

2019-06-26 Thread Vineet Garg
Hello Krzysztof, The rewrite you mention in Hive was done in HIVE-19674 to be able to push such group by to Druid. Currently there is no way to disable this rewrite. As for removing Group by , there are rules/rewrites which can reduce grouping

Re: Giving the Calcite logo some love

2019-06-26 Thread Ruben Q L
My top two are: 5B, 2C Best regards, Ruben Le mer. 26 juin 2019 à 12:01, Stamatis Zampetakis a écrit : > FYI: I checked the logos today on Windows and Debian and the fonts for a > couple of them (4A, 4B, 5B, 5C, 5D, 5E, 5F) are quite messed up. Apparently > they appear as they were supposed

Re: Release 1.20 and release notes

2019-06-26 Thread Kevin Risden
Top level has src/ which has a bunch of config files for checkstyle/forbidden-apis/etc. Might be a decent spot. Kevin Risden On Wed, Jun 26, 2019 at 11:07 AM Michael Mior wrote: > A Gradle task is great if we migrate to Gradle, but I don't think it's > a compelling reason in itself. I would

Re: Release 1.20 and release notes

2019-06-26 Thread Michael Mior
A Gradle task is great if we migrate to Gradle, but I don't think it's a compelling reason in itself. I would personally prefer to just have a copy of the script somewhere in the repo because the only purpose of putting it in the HOWTO would be so someone could copy and paste and run it. That

回复:Modify Calcite Planner in Hive to remove GROUP BY

2019-06-26 Thread Haisheng Yuan
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 semantic is different without group key. Try it on empty relation, you will see the difference. Thanks~ Haisheng

Modify Calcite Planner in Hive to remove GROUP BY

2019-06-26 Thread Krzysztof Zarzycki
Hello, While the question I have might look like regards to Hive, I believe is more about Calcite. I need to add a Calcite plan rule to Hive, that removes "Group by" clause when it groups by some constant value (GROUP BY TRUE more precisely). As far as I believe, the query semantically is the

[DISCUSSION] Unify throws in sql parser

2019-06-26 Thread Danny Chan
Now our parser has 3 kinds of throws behavior [1] Use JavaCC generateParseException [2] Use SqlUtil.newContextException [3] Use JavaCC ParseExecption directly For [1] and [2] there is a position info in the exception message, a throw may like: > From line 1, column 15 to line 1, column 26: But

Re: Giving the Calcite logo some love

2019-06-26 Thread Stamatis Zampetakis
FYI: I checked the logos today on Windows and Debian and the fonts for a couple of them (4A, 4B, 5B, 5C, 5D, 5E, 5F) are quite messed up. Apparently they appear as they were supposed to only on MacOS. On Wed, Jun 26, 2019 at 4:10 AM Chunwei Lei wrote: > I prefer the design of 5b too, but with