Re: [ANNOUNCE] New Calcite PMC chair: Ruben Q L

2022-01-20 Thread Danny Chan
Congratulations, Ruben, and good luck! Haisheng, Thank you for serving as Chair. Yanjing Wang 于2022年1月21日 周五下午12:16写道: > Congrats Ruben! > > Stamatis Zampetakis 于2022年1月21日周五 06:34写道: > > > Congrats Ruben! You're kind, fair, and knowledgeable, very well deserved. > > > > Many thanks for serving

Re: [ANNOUNCE] New committer: Zhaohui Xu

2021-10-17 Thread Danny Chan
Congratulations ! Danny XING JIN 于2021年10月15日周五 下午5:34写道: > Congratulations ! > > Jin > > Michael Mior 于2021年10月15日周五 上午12:56写道: > > > Welcome Zhaohui! > > -- > > Michael Mior > > mm...@apache.org > > > > Le mer. 6 oct. 2021 à 16:48, Stamatis Zampetakis a > > écrit : > > > > > > Apache Calcit

Re: [ANNOUNCE] New committer: Vladimir Ozerov

2021-06-23 Thread Danny Chan
Congrats, Vladimir! Best, Danny Chan Yanjing Wang 于2021年6月24日周四 上午11:41写道: > Congrats, Vladimir! > > Roman Kondakov 于2021年6月24日周四 上午11:22写道: > > > Congratulations, Vladimir! > > > > Roman Kondakov > > > > On 24.06.2021 12:23, 段雄 wrote: > > >

Re: Question: Hints & Rules

2021-05-27 Thread Danny Chan
optimization), and you should fix it if you wanna keep that. Best, Danny Chan JiaTao Tao 于2021年5月27日周四 下午4:22写道: > Hi > Indeed, there's some situation will lose hints, like RelBuilder#project, we > just construct a project without hints(ImmutableList.of()), so it will lose >

Re: Enumerable rules lost hint info

2021-05-27 Thread Danny Chan
. Jia Tao, what kind of physical hints do you expect to have for Calcite physical operators ? Best, Danny Chan Julian Hyde 于2021年5月20日周四 上午1:06写道: > Sure, there’s a slot to hold the hints. But is there a benefit to keeping > them in the physical algebra? There is certainly a cost to s

Re: Question: Hints & Rules

2021-05-26 Thread Danny Chan
Hi ~ We have interface RelHintsPropagator for hints propagation customization, but you may need to modify the code of the rule a little bit. Best, Danny Chan Taras Ledkov 于2021年5月26日周三 下午7:26写道: > Hi, > > I am trying to figure out how to use hints correctly. > > My case: &g

Re: [ANNOUNCE] Apache Calcite Avatica 1.18.0 released

2021-05-24 Thread Danny Chan
Thanks for the nice work, Francis ~ Best, Danny Chan Francis Chuang 于2021年5月19日周三 上午11:52写道: > The Apache Calcite team is pleased to announce the release of Apache > Calcite Avatica 1.18.0. > > Avatica is a framework for building database drivers. Avatica defines a > wire API an

Re: Re-write right outer join as left outer join

2021-03-03 Thread Danny Chan
Do you mean the join reordering ? You can take a look at LoptOptimizeJoinRule and JoinCommuteRule. Abhishek Agarwal 于2021年3月3日周三 下午5:12写道: > Hello everyone, > > is there an existing rule that can re-write a right outer join as a left > outer join by swapping tables? >

Re: [DISCUSS] Release Managers

2021-02-09 Thread Danny Chan
ompatible (within reason), than what those releases are called. > > That said, a major release would be an opportunity to get rid of the cruft > (deprecated APIs) that have built up over the years. We should do one at > some point in 2021. > > Julian > > > > On Feb

Re: [DISCUSS] Release Managers

2021-02-06 Thread Danny Chan
Just curious, when does Calcit plan to release 2.0, there are so many small versions now ~ Do we really need to be 1.3x.0 or 1.4x.0 version ? Andrei Sereda 于2021年2月5日周五 上午2:34写道: > I'm happy to help with 1.30 > > On Thu, Feb 4, 2021 at 1:27 PM Julian Hyde wrote: > > > Yes, I'll be release manag

Re: [ANNOUNCE] New Calcite PMC chair: Haisheng Yuan

2020-12-17 Thread Danny Chan
Congratulations, Haisheng! Thank you for your service, Stamatis. Julian Hyde 于2020年12月18日周五 上午9:58写道: > Congratulations, Haisheng! > > Thank you for your service, Stamatis. > > Julian > > > > On Dec 17, 2020, at 5:48 AM, Stamatis Zampetakis > wrote: > > > > Calcite community members, > > > > I

Re: [DISCUSS] State of the project 2020

2020-11-26 Thread Danny Chan
Oops, i just saw the mail ~ Thanks Stamatis Zampetakis for the whole year nice work, you are always warm and nice to work with. I'm also +1 for Haisheng being the PMC chair, he is experienced in optimizer and i believe he would take Calcite to a better direction in the following year ~ Also thank

Re: [DISCUSS] Does anybody think this is debuging unfriendly: "call.transformTo(relBuilder.build())"

2020-11-22 Thread Danny Chan
I kind of agree, but it's more like a programming specification, we can tell people how to write codes but they may not follow those rules. JiaTao Tao 于2020年11月22日周日 下午5:27写道: > Why I don't want to debug into "transformTo": > > 1. It's a common method, if you directly stop here, every rule will

Re: Search/Sarg: untested feature merged to the default branch

2020-11-12 Thread Danny Chan
Stop the merge, PLEASE !!! We all vote -1 and what's the problem there you still want to revert ? What's the bug/problem there that need to be fixed? Can you log some issues there ? If the RexProgramFuzzyTest can not run, just fix it. From my local test, it is not caused by the Sarg itself, it i

Re: Search/Sarg: untested feature merged to the default branch

2020-11-08 Thread Danny Chan
-1 for the revert, we should fix the issues we encountered instead of reverting the code brainless for a whole release. At lease, project like Apache Flink has upgrade to version 1.26 and the Sarg feature overall looks good. We are trying to fix the Sarg issues in version 1.27 and we should conti

Re: How to parse sql of DDL

2020-11-04 Thread Danny Chan
You can try the sql parser of Apache Flink, which supports the "ALTER TABLE ... ADD COLUMN ..." syntax. [1] [1] https://github.com/apache/flink/blob/master/flink-table/flink-sql-parser/src/test/java/org/apache/flink/sql/parser/FlinkSqlParserImplTest.java xiao cai 于2020年11月4日周三 下午4:25写道: > Hi Li

Re: [DISCUSS] Support Oracle Polymorphic Table Function Syntax

2020-11-02 Thread Danny Chan
tions (and table functions) from the path. > > Julian > > On Mon, Nov 2, 2020 at 3:55 AM Danny Chan wrote: > > > > Thanks Julian ~ > > > > > Possibly, but I'd be cautious, because the semantics become ambiguous > > if there are name clashes. > > &g

Re: [DISCUSS] Support Oracle Polymorphic Table Function Syntax

2020-11-02 Thread Danny Chan
; > > > > select * from udfProductInYear(); > > > This works. > > > > > > > create table udfProductInYear(a int, b VARCHAR); > > > There is already an object named 'udfProductInYear' in the database. > > > > > > F

Re: [DISCUSS] Screenshots of stack traces, code, and debugger sessions

2020-10-29 Thread Danny Chan
Yes, +1 to handle it case by case with proper reminders. Rui Wang 于2020年10月30日周五 上午6:19写道: > >People who write to dev@ list and attach the stacktrace as an image don't > >really know if the list accepts images or not. > >Making images forbidden does not help to teach people to > >attach stacktra

Re: [DISCUSS] Support Oracle Polymorphic Table Function Syntax

2020-10-29 Thread Danny Chan
> Let's not use TUMBLE (or HOP, or SESSION) as the main example. It is somewhat built-in (i.e. has special treatment in the code). Let's work in terms of, say, the RAMP user-defined function. It is used in several tests [1]. We may need to support all the user defined table functions with TABLE ke

Re: Re: how to register udfa to calcite?

2020-10-27 Thread Danny Chan
Your "aggr" needs to implement the interface SqlAggFunction <https://github.com/apache/calcite/blob/master/core/src/main/java/org/apache/calcite/sql/SqlAggFunction.java> . dawangli 于2020年10月27日周二 下午3:24写道: > sorry, i means udaf > > > > > > > > > &g

Re: how to register udfa to calcite?

2020-10-27 Thread Danny Chan
Do you mean DUTF or UDAF ? dawangli 于2020年10月27日周二 上午11:35写道: > I hive the following code,it just valid a simple group by sql with a udaf, > but i doesn't work, it seems like the calcite cannot identify the aggr udaf > ,code and error displayed below > code > String sql = "SELECT\n" + > " dim,\

Re: [DISCUSS] Some quesitons about the new introduced window table functions (TUMBLE, HOP and SESSION)

2020-10-25 Thread Danny Chan
nd. It was considered to place > the original > > row in a nested row and wstart and wend in a separate nested row, for > simplicity of > > namespacing, but that would limit these extensions to engines supporting > nested rows. > > [1] > > https://docs.google.com/docume

Re: [DISCUSS] Some quesitons about the new introduced window table functions (TUMBLE, HOP and SESSION)

2020-10-22 Thread Danny Chan
er there was special consideration to define > window_start and window_end as two separate columns? > > > -Rui > > On Wed, Oct 21, 2020 at 8:20 PM Danny Chan wrote: > > > Some of our fellows suggest the window table value functions to append a > > structure type field:

Re: [DISCUSS] Apache Calcite Online Meetup January 2021

2020-10-22 Thread Danny Chan
+1 for the online meeting, nice idea ~ Best, Danny Chan 在 2020年10月22日 +0800 PM5:58,JiaTao Tao ,写道: > I think it's a nice idea, hope to hear Julian's topic about lattice/mv, we > have a big demand on this and want to learn more. > > > Regards! > > Aron Tao > >

Re: RelBuilder#project should try keep alias in optimizer

2020-10-21 Thread Danny Chan
/jira/browse/CALCITE-3662 [3] https://issues.apache.org/jira/browse/CALCITE-1584 Best, Danny Chan 在 2020年10月21日 +0800 PM2:49,JiaTao Tao ,写道: > Hi fellows > I found in some place, we just call `project(Iterable > nodes) `, but this will lose alias, why don't we try to call > `project

Re: [DISCUSS] Some quesitons about the new introduced window table functions (TUMBLE, HOP and SESSION)

2020-10-21 Thread Danny Chan
, so it becomes > > > table_function(RexCorrelVariable, DESCRIPTOR($1), internal:INTERVAL > > MINUTE) > > > > > > I know RexCorrelVariable might be not designed for this purpose, but I > > > find RexCorrelVariable is really useful because: > > > 1. I

Re: [QUESTION] Does SQL standard allows project nested fields for aggregate ?

2020-10-20 Thread Danny Chan
Thanks, it works ~ I didn’t find evidence that SQL standard does not support this, at least, the semantic is clear. Best, Danny Chan 在 2020年10月21日 +0800 AM7:58,Jinfeng Ni ,写道: > SELECT f0.a, max(f1) FROM t1 GROUP BY f0 > > I think the problem with the 1st query is that the parser is

[QUESTION] Does SQL standard allows project nested fields for aggregate ?

2020-10-19 Thread Danny Chan
alid query My question is does SQL standard allows projecting nested fields for aggregate ? In current Calcite, it throws and complains that the nested field can not be seen in the scope (somehow same with the PG). Best, Danny Chan

Re: It's my pleasure to introduce myself to you

2020-10-14 Thread Danny Chan
e.net/JordanHalterman/introduction-to-apache-calcite [3] https://github.com/apache/ignite [4] https://github.com/apache/drill [5] https://github.com/hazelcast/hazelcast [6] https://calcite.apache.org/docs/powered_by.html Best, Danny Chan 在 2020年10月14日 +0800 PM2:29,guangyuan wang ,写道: > Hi Danny Cha

Re: It's my pleasure to introduce myself to you

2020-10-13 Thread Danny Chan
Welcome Guangyuan Wang ~ Very glad that you are interested in Calcite community, hope we can work together to make it better ~ You can fire issues, ask/answer questions, basically any contributions are appreciated ~ Best, Danny Chan 在 2020年10月14日 +0800 AM8:48,guangyuan wang ,写道: > He

Re: TableScan#explainTerms may be not enough for digest

2020-10-09 Thread Danny Chan
Thanks for driving this discussion, JiaTao, the Flink way: Extend the digest through getQualifiedName is hacky somehow. We actually need some interfaces to reflect/represent the pushed info, the pushed fields or filter expression. Best, Danny Chan 在 2020年10月9日 +0800 PM3:35,dev

Re: [RESULT] [VOTE] Release apache-calcite-1.26.0 (release candidate 0)

2020-10-06 Thread Danny Chan
Thanks for your work, Ruben! Release is a hard work but you made it easy :) Ruben Q L 于2020年10月7日 周三上午2:08写道: > Hi all, > > I have rolled out the release, there is still the site that needs to be > published (working on that), but in the meanwhile I assume it is safe to > re-open master branch fo

Re: [VOTE] Release apache-calcite-1.26.0 (release candidate 0)

2020-10-05 Thread Danny Chan
+1 (binding). - run tests locally: ok - verify the commit hash in git tag: ok - check sha512: ok Environment: - java version 1.8.0_151 - MacOS Mojave 10.14.6 I also find the new introduced ersi library when i do upgrade for Flink. I solves the problem by adding a dependency for it. It is awesome

Re: [DISCUSS] Towards Calcite 1.26.0

2020-10-03 Thread Danny Chan
Best, Danny Chan 在 2020年10月3日 +0800 AM1:12,Ruben Q L ,写道: > I'm working on the release notes, any breaking change worth mentioning > apart from https://issues.apache.org/jira/browse/CALCITE-2082 ? > > > On Fri, Oct 2, 2020 at 11:59 AM Ruben Q L wrote: > > > T

Re: [DISCUSS] Towards Calcite 1.26.0

2020-09-29 Thread Danny Chan
The schedule sounds good to me, thanks Ruben for being the release manager ~ Best, Danny Chan 在 2020年9月30日 +0800 AM3:44,Julian Hyde ,写道: > > What is the status on 4279 (SEARCH operator into Druid)? > > Working on it. > > > On Sep 29, 2020, at 11:58 AM, Ruben Q L wrote: &

Re: [DISCUSS] The date to release Calcite 1.26.0

2020-09-27 Thread Danny Chan
]  https://issues.apache.org/jira/issues/?jql=project%20%3D%20CALCITE%20AND%20status%20in%20(Open%2C%20%22In%20Progress%22%2C%20Reopened)%20AND%20resolution%20%3D%20Unresolved%20AND%20fixVersion%20%3D%201.26.0%20ORDER%20BY%20priority%20DESC%2C%20updated%20DESC Best, Danny Chan 在 2020年9月28日 +0800 AM10

Re: [DISCUSS] The date to release Calcite 1.26.0

2020-09-27 Thread Danny Chan
I will do that. Best, Danny Chan 在 2020年9月28日 +0800 AM3:35,James Starr ,写道: > Could I get CALCITE-4210 included in release 1.26.0? > > On Fri, Sep 25, 2020 at 1:50 AM Danny Chan wrote: > > > Thanks. I will prepare my local test as fast as possible. > > > > Ru

Re: [DISCUSS] The date to release Calcite 1.26.0

2020-09-25 Thread Danny Chan
promise anything. > > > > Best regards, > > Ruben > > > > > > Le ven. 25 sept. 2020 à 09:05, Danny Chan a écrit : > > > > > Ruben , can we make sure that the next release happens before 8th > October? > > > I would do local tests for it bef

Re: [DISCUSS] The date to release Calcite 1.26.0

2020-09-25 Thread Danny Chan
our help on > > > https://issues.apache.org/jira/browse/CALCITE-4259 (supporting JDK 15 > > > and removing log4j), which is a must-fix for 1.26. > > > > > > Julian > > > > > > > > > On Wed, Sep 23, 2020 at 2:30 AM Danny Chan wrote: > >

Re: [ DISCUSS] The window table functions join syntax

2020-09-23 Thread Danny Chan
Thanks for the feedback, I agree we should keep the verbose part **L.window_start = R.window_start AND L.window_end =R.window_end** Which would make the semantic more clear ~ Best, Danny Chan 在 2020年9月23日 +0800 PM3:24,Viliam Durina ,写道: > You can also use > > SELECT L.f0, R.f2, L.win

Re: [DISCUSS] The date to release Calcite 1.26.0

2020-09-23 Thread Danny Chan
. And it would be great if we can make this sooner, this is important because I can fire the upgrade PR sooner and actually we have many features developed based on current master branch. Best, Danny Chan 在 2020年9月23日 +0800 PM4:15,Ruben Q L ,写道: > Hello Danny, > > As the release ma

[DISCUSS] The date to release Calcite 1.26.0

2020-09-22 Thread Danny Chan
Is there any possibility that 1.26.0 can be released in the following weeks, e.g. within the October ? Apache Flink would release next major version in the end of October, if we can use the latest Calcite code, that would be awesome ~ Best, Danny Chan

Re: [ DISCUSS] The window table functions join syntax

2020-09-22 Thread Danny Chan
, how do you think about the condition syntax **L.window_start = R.window_start AND L.window_end = R.window_end** ? Best, Danny Chan 在 2020年9月23日 +0800 PM12:47,dev@calcite.apache.org,写道: > > L.window_start = R.window_start AND L.window_end = R.window_end

[ DISCUSS] The window table functions join syntax

2020-09-22 Thread Danny Chan
= R.window_end The red syntax part is what I want to discuss, the condition seems too verbose because user need to declare it every time. • Should we make it optional ? • Is there better syntax to describe this window join semantics ? Best, Danny Chan

Re: [ANNOUNCE] New committer: Rui Wang

2020-09-09 Thread Danny Chan
Congrats Rui! Best, Danny Chan > 在 2020年9月10日,上午6:28,Francis Chuang 写道: > > Congrats Rui!

Re: help with structured fields in JDBC table

2020-08-25 Thread Danny Chan
at. Maybe you can have a test case in the JdbcTest so that the contributors interested in this can give some help. Best, Danny Chan 在 2020年8月26日 +0800 PM2:20,James Anderson ,写道: > Hi, > > I'm having trouble successfully validating a SQL query against a postgres > db where one

Re: master locked during 1.25.0 release

2020-08-16 Thread Danny Chan
Thanks for the notice ~ Best, Danny Chan 在 2020年8月17日 +0800 AM1:06,Andrei Sereda ,写道: > Hello, > > Following the vote on 1.25 release and Julian's suggestion to open up > master sooner, I have merged 1.25 release with master. > > master branch is unlocked now. You can re

Re: [ANNOUNCE] Ruben Quesada Lopez joins Calcite PMC

2020-08-11 Thread Danny Chan
Congratulations ~ Best, Danny Chan 在 2020年8月12日 +0800 AM9:57,chunwei ,写道: > Congrats, Ruben! > > On Wed, Aug 12, 2020 at 8:58 AM XING JIN wrote: > > > Congrats, Ruben! > > > > 953396112 <953396...@qq.com> 于2020年8月12日周三 上午7:47写道: > > > >

Re: [DISCUSS] Publish test JARS

2020-08-11 Thread Danny Chan
Michael, do you plan to push this function/patch ? We actually need this too ~ Best, Danny Chan 在 2020年8月11日 +0800 AM3:06,Michael Mior ,写道: > Thanks for pointing back to the previous discussion. I'm fine with > publishing separate modules. No real preference on my end since I >

Re: Pushing down aggregates through rhs of a left join

2020-08-03 Thread Danny Chan
I didn’t see the derivation formula yet but I believe there is indeed some promotion space for the Agg Join transpose cases, Alex, can you log an issue there ? Best, Danny Chan 在 2020年7月31日 +0800 PM1:43,Alex Baden ,写道: > Hi all, > > I have a query of the form: > > SELECT a.x, SU

Re: [DISCUSSION] Rename master branch to main

2020-07-28 Thread Danny Chan
ely low impact change that can potentially > make us even more welcoming to new contributors, which is a benefit to > us all :) Is this true ? People would always contribute to Calcite if they need to, apparently not just because of a branch name. Best, Danny Chan 在 2020年7月29日 +0800 AM7:0

Re: Exception:Catch clause is unreachable

2020-07-24 Thread Danny Chan
Is there any possibility that you gave an re-producable test case in the JdbcTest and log an issue there ? So that the volunteers can contribute the fix if they want to. Best, Danny Chan 在 2020年7月24日 +0800 PM2:05,tonytao ,写道: > I had found the empty result was happened at select validate

Re: Re: Exception:Catch clause is unreachable

2020-07-23 Thread Danny Chan
ebugging, so you need to copy the files out and past it into the IDEA again to see which file has the Java syntax error. Best, Danny Chan 在 2020年7月23日 +0800 PM4:05,tonytao ,写道: > hi Danny, > > Thank you for your kindly help. > > Attach is the generated code.but I had no idea how th

Re: [VOTE] Release apache-calcite-1.24.0 (release candidate 0)

2020-07-22 Thread Danny Chan
Thanks Chunwei for taking care of the release ~ +1 (binding) - verified hashes and checksums - built from sources and run tests (1.8.0_161 on MacOS Mojave) - run some tests of Flink Best, Danny Chan 在 2020年7月22日 +0800 PM11:50,dev@calcite.apache.org,写道: > > +1 (non binding) > - verifi

Re: Exception:Catch clause is unreachable

2020-07-21 Thread Danny Chan
It seems that you got some problem with the generated code, take this [1] to debug the code and to see which line caused the compilation error. [1]  https://calcite.apache.org/docs/howto.html#debugging-generated-classes-in-intellij Best, Danny Chan 在 2020年7月22日 +0800 AM12:17,taojin ,写道: >

Re: custom metadata logic

2020-07-21 Thread Danny Chan
/calcite/plan/RelOptCluster.java#L142 [2]  https://github.com/apache/calcite/blob/d2c859098acb3210ac5cad90c5ea28a3317f0386/core/src/main/java/org/apache/calcite/rel/metadata/RelMetadataQueryBase.java#L58 Best, Danny Chan 在 2020年7月21日 +0800 PM4:18,Tal Glanzman ,写道: > thank you it is working gr

Re: Re: [DISCUSS] New Join Type: ANTI_NOTIN

2020-07-20 Thread Danny Chan
If it is only constant NOT IN predicate, how difficult it is to rewrite it into a normal composite AND predicate before entering the planning phrase ? Best, Danny Chan 在 2020年7月21日 +0800 PM12:35,Haisheng Yuan ,写道: > Thanks Jinpeng for providing a good example for not in subquery. > &

Re: [DISCUSS] Default disable the RexNode normalization(or operands reorder)

2020-07-16 Thread Danny Chan
I added and it passed. Best, Danny Chan 在 2020年7月16日 +0800 PM4:35,Vladimir Sitnikov ,写道: > Danny, could you please add a test case for nestes normalization (see > comment in pr) ? > > Vladimir

Re: [DISCUSS] Default disable the RexNode normalization(or operands reorder)

2020-07-16 Thread Danny Chan
I would commit the PR soon because I want this into 1.24 release, we can continue the discussion though ~ Best, Danny Chan 在 2020年7月16日 +0800 PM2:53,Vladimir Sitnikov ,写道: > > But currently AND/OR in Calcite is always binary operator > > I guess we might want to add multi-arg AND i

Re: [DISCUSS] Default disable the RexNode normalization(or operands reorder)

2020-07-15 Thread Danny Chan
IN. Best, Danny Chan 在 2020年7月16日 +0800 AM1:55,Haisheng Yuan ,写道: > > Customized sql operator can also benefit. [1] > > I am not sure if I missed something. Can you show me how can the customized > sql operator benefit from this? > e.g. geospatial operator intersect (it is input

Re: [DISCUSS] Default disable the RexNode normalization(or operands reorder)

2020-07-14 Thread Danny Chan
if: • the algorithm is deterministic • It can cover most of the cases, like the user defined function • It does not affect the performance too much [1]  https://github.com/apache/calcite/pull/2065 Best, Danny Chan 在 2020年7月15日 +0800 PM12:10,dev@calcite.apache.org,写道: > > Sql ope

Re: [RESULT] [VOTE] Release apache-calcite-avatica-go-5.0.0 (release candidate 0)

2020-07-14 Thread Danny Chan
Thanks for the great work, Francis ~ Best, Danny Chan 在 2020年7月15日 +0800 AM7:23,dev@calcite.apache.org,写道: > > Francis

Re: [DISCUSS] Default disable the RexNode normalization(or operands reorder)

2020-07-13 Thread Danny Chan
Yes, it is. We can keep it as a builtin promotion. Best, Danny Chan 在 2020年7月13日 +0800 PM3:48,Vladimir Sitnikov ,写道: > > Hi, all, I’m planning to default disable the RexNode normalization in > CALCITE-4073, if you have any objections, please let me know in 24 hours, > thanks so

Re: [DISCUSS] Default disable the RexNode normalization(or operands reorder)

2020-07-13 Thread Danny Chan
Hi, all, I’m planning to default disable the RexNode normalization in CALCITE-4073, if you have any objections, please let me know in 24 hours, thanks so much ~ Looking forward to your feedback ~ Best, Danny Chan 在 2020年7月8日 +0800 PM4:38,Danny Chan ,写道: > In CALCITE-2450, we proposed a cha

Re: [VOTE] Release apache-calcite-avatica-go-5.0.0 (release candidate 0)

2020-07-12 Thread Danny Chan
Docker version 19.03.5, docker-compose version 1.25.4 * Checked signatures and checksums OK * Release note OK * docker-compose run test OK (for git tag and source artifacts) * Checked diff between repo and artifacts OK +1 (binding) Best, Danny Chan 在 2020年7月13日 +0800 AM6:31,dev

Re: Calcite PR CI offten failed due to elasticsearch:test

2020-07-10 Thread Danny Chan
t; > > > > > > > Stamatis Zampetakis 于2020年7月2日周四 下午5:05写道: > > > > > >> I didn't observe the problem on my local post so if it is only a CI > > >> problem > > >> then it would be nice if we could disable the tests only there

Re: [DISCUSS] Default disable the RexNode normalization(or operands reorder)

2020-07-10 Thread Danny Chan
ld avoid that. > > I am not sure I understand what you mean when you say disabling it by > default. Are you talking about features that are already released or the > things currently in progress for 1.24.0? > > Best, > Stamatis > > On Wed, Jul 8, 2020 at 10:39 AM Danny Ch

[DISCUSS] Default disable the RexNode normalization(or operands reorder)

2020-07-08 Thread Danny Chan
/x/thread.html/54bf3ed733eb7e725ce3ea397334aad8f1323ead13e450b1753b1521@%3Cdev.calcite.apache.org%3E [2] https://issues.apache.org/jira/browse/CALCITE-2450 [3] https://issues.apache.org/jira/browse/CALCITE-4073 Best, Danny Chan

Re: [DISCUSS] Make RexNode serializable

2020-07-07 Thread Danny Chan
operators. In the distributed scenarios of Beam, I’m afraid it is hard to get the  RelOptSchema because it is execution, we usually see the RelOptSchema during SQL compile time. Best, Danny Chan 在 2020年7月8日 +0800 AM3:39,Roman Kondakov ,写道: > Hi Rui, > > AFAIK, RelNodes can be serializ

Re: Calcite PR CI offten failed due to elasticsearch:test

2020-07-01 Thread Danny Chan
2 and 3 doesn’t really solve the problem, I would choose 1, you should log these tests in the issue in order to track the status ~ Best, Danny Chan 在 2020年7月2日 +0800 AM11:15,JiaTao Tao ,写道: > Hi Danny > > > There is 4 failed ut, and the root cause is java.net.SocketTimeoutExcepti

Re: Fwd: Announcing Apachecon @Home 2020

2020-06-30 Thread Danny Chan
That’s true, look forward to the new talk ~ Best, Danny Chan 在 2020年6月29日 +0800 PM9:04,Michael Mior ,写道: > This could be a great opportunity for anyone interested in giving a > talk about Calcite and normally unable to attend ApacheCon. > > -- > Michael Mior >

Re: Help to parse spark dialect

2020-06-27 Thread Danny Chan
The Apache Flink sql parser template is a good choice to reference [1]. [1]  https://github.com/apache/flink/blob/master/flink-table/flink-sql-parser/src/main/codegen/includes/parserImpls.ftl Best, Danny Chan 在 2020年6月27日 +0800 AM4:26,Tang, Mingjun ,写道: > Hi dear calcite community, > >

Re: Calcite PR CI offten failed due to elasticsearch:test

2020-06-27 Thread Danny Chan
Yes, it times out often, can you log an issue there and disable the case ? Best, Danny Chan 在 2020年6月26日 +0800 PM6:00,JiaTao Tao ,写道: > Seems an unstable case. > > > Regards! > > Aron Tao

Re: [ANNOUNCE] Apache Calcite Avatica 1.17.0 released

2020-06-22 Thread Danny Chan
Thanks for the work, Francis~ Francis Chuang 于2020年6月23日 周二上午8:10写道: > The Apache Calcite team is pleased to announce the release of Apache > Calcite Avatica 1.17.0. > > Avatica is a framework for building database drivers. Avatica defines a > wire API and serialization mechanism for clients to c

Re: [RESULT] [VOTE] Release apache-calcite-avatica-1.17.0 (release candidate 0)

2020-06-21 Thread Danny Chan
Thanks for the great work, Francis ~ Best, Danny Chan 在 2020年6月22日 +0800 AM7:11,Francis Chuang ,写道: > Thanks to everyone who has tested the release candidate and given their > comments and votes. > > The tally is as follows. > > 3 binding +1s: > Francis Chuang > Julian Hy

Re: Nested data handling in Caclite

2020-06-19 Thread Danny Chan
designed to extract nested fields so that the work like de-correlation is much easier, but it also makes the plan changed and hard to maintain, it is not updated frequently, if possible, close the  flattening. Best, Danny Chan 在 2020年6月19日 +0800 AM4:39,Slim Bouguerra ,写道: > @Danny it is attached

Re: How to support case-insensitive identifier resolution?

2020-06-18 Thread Danny Chan
because the DDL and DML case-sensitivity should keep the same, thus, when you create the second table `MyTable`, the catalog show throw instead. Best, Danny Chan 在 2020年6月18日 +0800 PM10:02,Viliam Durina ,写道: > > Does any SQL vendors behave like that ? > I don't know of any vendor. >

Re: How to support case-insensitive identifier resolution?

2020-06-18 Thread Danny Chan
> when the identifier was > quoted and case-insensitive, if it wasn’t Does any SQL vendors behave like that ? What do you mean by “sometimes”, SQL must have a deterministic semantic I think. Best, Danny Chan 在 2020年6月18日 +0800 PM4:23,dev@calcite.apache.org,写道: > > when the id

Re: Nested data handling in Caclite

2020-06-18 Thread Danny Chan
What diff, I didn’t see that ~ Best, Danny Chan 在 2020年6月16日 +0800 PM11:52,Slim Bouguerra ,写道: > Hi Danny I have run some test yesterday with RelToSqlConverterStructsTest I > have attached the diff, let me know what you think > > > > On Tue, Jun 16, 2020 at 2:22 AM Danny Chan

Re: Nested data handling in Caclite

2020-06-16 Thread Danny Chan
Take SqlToRelConverterTest#testAliasUnnestArrayPlanWithSingleColumn for an example, you should make every record type with StructKind.PEEK_FIELDS, so that nested record type can be also accessed with DOT. Best, Danny Chan 在 2020年6月16日 +0800 PM12:50,Slim Bouguerra ,写道: > Hi Danny, > Than

Re: How to support case-insensitive identifier resolution?

2020-06-16 Thread Danny Chan
/config/Lex.java#L37 Best, Danny Chan 在 2020年6月16日 +0800 PM5:05,Vladimir Ozerov ,写道: > Hi colleagues, > > I am trying to implement case insensitive resolution of column/table/schema > names for our Apache Calcite integration in Hazelcast and got stuck. I hope > that the communit

Re: Nested data handling in Caclite

2020-06-15 Thread Danny Chan
Hi, when you create a structure type, you should choose StructKind.PEEK_FIELDS instead, which let you to access the nested fields with DOT, i.e. “a.b.c”. Best, Danny Chan 在 2020年6月16日 +0800 AM4:21,Slim Bouguerra ,写道: > I am using this thread since the question seems related. > As of now

Re: Why migrate from Maven to Gradle

2020-06-14 Thread Danny Chan
Thanks, are there some building functionalities that grade can do but maven can not ? Gradle is not that user friendly for new uses but I works well, it has better flexibility than maven with many custom plugins. Best, Danny Chan 在 2020年6月13日 +0800 AM1:31,丁小冬(比古) ,写道: > > Hi, Calcite deve

Re: NULL in IN clause

2020-06-05 Thread Danny Chan
one that are interested in it would contribute ~ Thanks again ~ [1]  https://github.com/apache/calcite/blob/feae6fbc328e3a7c87693951d1623f8b47ccea59/core/src/main/java/org/apache/calcite/sql2rel/SqlToRelConverter.java#L1102 Best, Danny Chan 在 2020年6月6日 +0800 AM5:38,Rui Wang ,写道: > I see. I

[DISCUSS] Some quesitons about the new introduced window table functions (TUMBLE, HOP and SESSION)

2020-06-04 Thread Danny Chan
/issues.apache.org/jira/browse/CALCITE-3737 Best, Danny Chan

Re: Using indexes rather than table scans with Calcite

2020-05-29 Thread Danny Chan
erver.101/b10752/hintsref.htm#5156 [3] https://docs.microsoft.com/en-us/sql/t-sql/queries/hints-transact-sql-table?view=sql-server-ver15 Best, Danny Chan 在 2020年5月29日 +0800 PM4:44,Tim Fox ,写道: > Hi, > > I'm building a query engine with Calcite - really enjoying working with > Ca

Re: [VOTE] Release apache-calcite-1.23.0 (release candidate 1)

2020-05-20 Thread Danny Chan
Thanks Haisheng for driving this! Verified GPG signature - OK Verified SHA512 - OK Release notes - OK Diff the files in the release artifact and tag - ok As for Calcite 3997, it only affects the Physical node, I’m fine with that ~ So +1 (binding) ~ Gradle 6.3 (via gradlew) Mac OS High Sierra J

Re: Calcite in research - The ReProVide Query-Sequence Optimization in a Hardware-Accelerated DBMS

2020-05-10 Thread Danny Chan
Exciting, glad to hear that Lekshmi ! Lekshmi 于2020年5月11日 周一上午3:07写道: > Hello all, > This happened because of the support provided by this group. I'm always > grateful to this community. > You could also find another paper and the video which demonstrates the > prototype we developed using Ap

Re: Re: [ANNOUNCE] New committer: Forward Xu

2020-04-30 Thread Danny Chan
Congrations! Forward! Best, Danny Chan 在 2020年4月30日 +0800 PM12:14,Fan Liya ,写道: > Congratulations, Forward! > > Best, > Liya Fan > > On Wed, Apr 29, 2020 at 8:51 PM Wang Yanlin <1989yanlinw...@163.com> wrote: > > > Congrations! Forward!-- > > > > Bes

Re: How to give type in case of type mismatch while doing union

2020-04-29 Thread Danny Chan
Or try SQL, it has the implicit type coercion ~ Best, Danny Chan 在 2020年4月28日 +0800 AM4:36,Julian Hyde ,写道: > Anjali, > > If you’re using RelBuilder to create the union, or creating the union > manually, it is your responsibility to make sure that the input RelNodes have > c

Re: [ANNOUNCE] New committer: Wang Yanlin

2020-04-29 Thread Danny Chan
Congrats, Wang Yanlin! Best, Danny Chan 在 2020年4月29日 +0800 AM8:26,dev@calcite.apache.org,写道: > > Congrats, Wang Yanlin!

Re: Re: [ANNOUNCE] New committer: Jin Xing

2020-04-29 Thread Danny Chan
Congrats, Jin Xing! Best, Danny Chan 在 2020年4月30日 +0800 PM12:15,dev@calcite.apache.org,写道: > > Congrats, Jin Xing!

Re: [Tests Failing] Master Travis test fails continuously for JDK14

2020-04-28 Thread Danny Chan
I have deleted the master cache, hope it helps ~ Best, Danny Chan 在 2020年4月28日 +0800 AM10:53,Michael Mior ,写道: > I have my accounts linked, but I see " Your permissions are > insufficient to access this content." > -- > Michael Mior > mm...@apache.org > > Le l

Re: [Tests Failing] Master Travis test fails continuously for JDK14

2020-04-27 Thread Danny Chan
Thanks, how could I ask them to do that ? Log an issue there ? Best, Danny Chan 在 2020年4月27日 +0800 PM5:38,Vladimir Sitnikov ,写道: > I guess the solution is to ask INFRA to reset all the Travis caches for > Calcite. > > Vladimir

[Tests Failing] Master Travis test fails continuously for JDK14

2020-04-27 Thread Danny Chan
Here is an example https://travis-ci.org/github/apache/calcite/jobs/679970288 Can someone help with that ? Thanks ~ Best, Danny Chan

Re: [ANNOUNCE] New committer: Vineet Garg

2020-04-26 Thread Danny Chan
Congrats, Vineet! Best, Danny Chan 在 2020年4月26日 +0800 PM1:55,dev@calcite.apache.org,写道: > > Congrats, Vineet!

Re: [DISCUSS] Towards Cascades Optimizer

2020-04-21 Thread Danny Chan
> Is there any recommended approach to make that happen smoothly besides coding and testing work? We need to be aware that the new planner might be co-exist with VolcanoPlanner for 5 or more years, or even never replace VolcanoPlanner. If that is true, i might say the new planner is probably with

Re: Calcite geode adapter query

2020-04-02 Thread Danny Chan
I believe few people in the community are familiar with geode, maybe you can ask the author of this module [1] [1] https://github.com/tzolov Best, Danny Chan 在 2020年4月2日 +0800 PM6:41,aashish choudhary ,写道: > Can anyone help me with this? > > With best regards, > Ashish > > O

Re: Asking help for parsing MySql Alter Table statements

2020-04-02 Thread Danny Chan
json). Here is the full syntax for DDL so far [1] [1]  https://github.com/apache/calcite/blob/master/server/src/main/codegen/includes/parserImpls.ftl Best, Danny Chan 在 2020年3月27日 +0800 AM8:23,Antonio Gelameris ,写道: > Hello to everyone! > I was trying to understand whether it's possib

  1   2   3   4   >