CSVAdapter OTHER TYPE

Hi , I saw an interesting exchange about the CSVAdapter I am also in a similar case where I want to be able to perform predicate filters from table after conversion from JSON to JsonScannableTable . the first dimension are correctly converted into the right type VARCHAR ect but other dimensio

[jira] [Created] (CALCITE-3535) EnumerableJoinRule: remove unnecessary Filter on top of INNER Join

Ruben Q L created CALCITE-3535: -- Summary: EnumerableJoinRule: remove unnecessary Filter on top of INNER Join Key: CALCITE-3535 URL: https://issues.apache.org/jira/browse/CALCITE-3535 Project: Calcite

Re: [DISCUSS] New Apache Calcite Chair

+1 On 11/21/19 4:48 PM, Francis Chuang wrote: Hey everyone, It's Calcite's tradition to rotate the chair every year. When we had the State of the Project discussion [1] a month ago, there was some consensus towards nominating Stamatis Zampetakis as our next chair. Stamatis has been a prolif

Re: [DISCUSS] New Apache Calcite Chair

+1! Thanks for Francis's contribution as PMC chair in the past year. Looking forward to Stamatisto to be PMC chair in the next year! On Sun, Nov 24, 2019 at 6:57 PM Chunwei Lei wrote: > Francis, thank you for your great job. I really respect it. > > I am +1 for Stamatis being the PMC chair. He

Re: Re: [DISCUSS] New Apache Calcite Chair

Thank you for your service as a chair, Francis, I really appreciate it. +1 for Stamatis, who has been instrumental in issue discussions, answering questions and making Calcite a more friendly community together with other contributors. Looking forward to working with you more closely. - Haishen

Re: Re: [DISCUSS] New Apache Calcite Chair

+1 On Mon, Nov 25, 2019 at 12:29 PM Haisheng Yuan wrote: > Thank you for your service as a chair, Francis, I really appreciate it. > > +1 for Stamatis, who has been instrumental in issue discussions, answering > questions and making Calcite a more friendly community together with other > contrib

Question about SortJoinTransposeRule and Inner Joins

The performance of our queries are dependent on our ability to push the filter and sort into the RPC layer. Today the planner's SortJoinTransposeRule pushes the sort through th

Re: Question about SortJoinTransposeRule and Inner Joins

Yes, we can. Currently the rule applies only on left/right outer join, because the cardinality of join will always be greater than or equal with the cardinality of outer relation. For inner join, the join cardinality may be much less, in which case, sorting on the join output might be cheaper.

Re: CSVAdapter OTHER TYPE

Thanks, Steve ~ Calcite did support LIST type syntax, such as “INT ARRAY” or “INT MULTISET ARRAY”, but we do not support MAP syntax yet, because it is not a SQL standard, so the MAP type would always parsed to other type. You can reference a ARRAY column item with syntax “column_name[_index]”,

IntelliJ and Gradle

After our migration to gradle, IntelliJ frequently fails to correctly load a project. For example, I just switched to the amaliujia/rw-add_TVF_TUMBLE branch and opened SqlToRelConverterTest. The file starts with the following: import org.apache.calcite.config.CalciteConnectionConfigImpl; import

Re: IntelliJ and Gradle

Usually, i run gradle build to solve this problem On Tue, Nov 26, 2019 at 10:03 AM Julian Hyde wrote: > After our migration to gradle, IntelliJ frequently fails to correctly load > a project. > > For example, I just switched to the amaliujia/rw-add_TVF_TUMBLE branch and > opened SqlToRelConv

Re: Question about SortJoinTransposeRule and Inner Joins

I never understood why this rule did not handle inner join, but Haisheng’s analysis is plausible. (By the way, see https://issues.apache.org/jira/browse/CALCITE-892 for when the rule was originally added.) It’s not a good idea for rules to re

[jira] [Created] (CALCITE-3536) Wrong semantics in CoalesceImplementor

Jin Xing created CALCITE-3536: - Summary: Wrong semantics in CoalesceImplementor Key: CALCITE-3536 URL: https://issues.apache.org/jira/browse/CALCITE-3536 Project: Calcite Issue Type: Bug

Re: IntelliJ and Gradle

In this case I restarted IntelliJ and performed ‘./gradlew build’ from the command line and it solved the problem. I would be interested to hear how Gradle is working for other folks. Julian > On Nov 25, 2019, at 6:07 PM, Shuo Cheng wrote: > > Usually, i run gradle build to solve this

Re: IntelliJ and Gradle

Upgrade to IDEA 2019.3 solves the problem. Best, Danny Chan 在 2019年11月26日 +0800 AM10:03，Julian Hyde ，写道： > After our migration to gradle, IntelliJ frequently fails to correctly load a > project. > > For example, I just switched to the amaliujia/rw-add_TVF_TUMBLE branch and > opened SqlToRelConve

Re: Streaming extensions to the SQL Standard, call for participation

Thanks, Rick. I would be interested in joining. Adding Tyler, Kenn, Fabian to CC. They were (with Edmon) my co-authors of the SIGMOD paper and are adding streaming SQL extensions to Apache Beam and Flink based on Calcite. Julian > On Nov 24, 2019, at 3:21 PM, Rick Hillegas wrote: > > The AN

Re: Question about SortJoinTransposeRule and Inner Joins

Hi Scott, I think the rule did not handle the case of inner joins since along with the sort it pushes also the limit and offset. In order to work properly for inner joins you have to take into account foreign keys (see the discussion in [1]). Recently we added another rule, i.e., SortJoinCopyRule

Re: IntelliJ and Gradle

Same to me when I face similar situation: run ./gradlew build or ./gradlew assemble in command line and then IDEA seems stop complaining. -Rui On Mon, Nov 25, 2019 at 7:08 PM Danny Chan wrote: > Upgrade to IDEA 2019.3 solves the problem. > > Best, > Danny Chan > 在 2019年11月26日 +0800 AM10:03，Jul

[QUESTION] Build Calcite using Gradle

Hi everyone, After migrating Calcite to Gradle, i built Calcite referring to docs[1] and got the following exception. As i have no idea to handle it, this help-seeking email comes. Thanks in advance. Best wishes, Trista [1] https://calcite.apache.org/docs/howto.html#building-from-git

Re: [QUESTION] Build Calcite using Gradle

First make sure the URLs in `FileReaderTest`, e.g , en.wikipedia.org/wiki/List_of_states_and_territories_of_the_United_States, can be accessed from your machine. On Tue, Nov 26, 2019 at 3:49 PM Juan Pan wrote: > Hi everyone, > > > After migrating Calcite to Gradle, i built Calcite referring to d