Re: [DISCUSS] Tests vs multiline strings

2019-12-15 Thread Danny Chan
change them back to Java. [1]  https://github.com/apache/calcite/commit/0d6bec4140da46af07d58cf07a5e682d61529603 Best, Danny Chan 在 2019年12月16日 +0800 AM9:02,Julian Hyde ,写道: > I don't think we should do this. > > Multi-line strings are a bit unwieldy, but they're not a major >

Re: How to keep quotes in SqlIdentifier?

2019-12-15 Thread Danny Chan
. [1]  https://github.com/apache/calcite/blob/547e49c1c37554f3bff904d5266d9e1c671e98f0/core/src/main/java/org/apache/calcite/sql/validate/SqlConformance.java#L34 Best, Danny Chan 在 2019年12月14日 +0800 AM10:03,月宫的木马兔 ,写道: > Hi, > I got the SqlNode  by using SqlParse.parseQuery() (Sql bellow), 

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

2019-12-17 Thread Danny Chan
-avatica-1.16.0-src: licenses There are quite a few commits that does not have a JIRA issue to trace, which is hard to understand, instead of list the commit message, maybe we should give a broad summary of them. +1 (binding) Best, Danny Chan 在 2019年12月12日 +0800 AM6:20,Francis Chuang ,写道: > Hi

Re: Re: [ANNOUNCE] New Calcite PMC chair: Stamatis Zampetakis

2019-12-18 Thread Danny Chan
Congratulations Stamatis! Best, Danny Chan 在 2019年12月19日 +0800 AM7:37,dev@calcite.apache.org,写道: > > Congratulations Stamatis!

Re: [DISCUSS] CALCITE-2450 reorder predicates to a canonical form

2019-12-29 Thread Danny Chan
ongly -1 for this way, because it beaks the plan test where almost all of the change are meaningless. Best, Danny Chan 在 2019年12月30日 +0800 AM3:09,dev@calcite.apache.org,写道: > > We do not normalize RexNodes, thus it results in excessive planning time, > especially when the planner is t

Re: [DISCUSS] CALCITE-2450 reorder predicates to a canonical form

2019-12-30 Thread Danny Chan
can change the plan for necessary requirements, but within your PR, you did not solve that, almost all of the plan change are meaningless, can you stop doing that ? I do want to be awful when I upgrade to the next calcite version ~ Best, Danny Chan 在 2019年12月30日 +0800 PM3:04,Vladimir Sitnikov ,写

Re: Re: [DISCUSS] CALCITE-2450 reorder predicates to a canonical form

2019-12-30 Thread Danny Chan
Or better, we can make the digest change transparent to user, keep it as what user writes them, but, in the Planner cache, we use the normalized digest as the key. Best, Danny Chan 在 2019年12月31日 +0800 AM9:50,Haisheng Yuan ,写道: > Normalizing scalar expressions is helpful, especially

Re: [DISCUSS] Proposal to add API to force rules matching specific rels

2020-01-07 Thread Danny Chan
forward to the result, because Apache Flink suffers for the bad planning performance for Join re-order or traits auto-adapter. Best, Danny Chan 在 2019年11月20日 +0800 AM2:14,Vladimir Ozerov ,写道: > HI Igor, > > Thank you for the details. Meanwhile, I solved it with separation of > conversio

Re: [DISCUSS] Proposal to add API to force rules matching specific rels

2020-01-07 Thread Danny Chan
Internally we have a multi-inputs merge join, for each input there maybe a collation permutations. Best, Danny Chan 在 2020年1月8日 +0800 AM1:20,Xiening Dai ,写道: > Danny, I am not sure how this would affect join re-order. Could you elaborate? > > > > On Jan 7, 2020, at 1:29 AM, Da

Re: Calcite-Master - Build # 1554 - Failure

2020-01-09 Thread Danny Chan
Is it related with Spark version upgrade ? Best, Danny Chan 在 2020年1月10日 +0800 PM2:50,Vladimir Sitnikov ,写道: > In case you wondered, the exception there is OOM in JVM 1.8: > > java.lang.OutOfMemoryError: unable to create new native thread > at java.lang.Thread.start0(Native

Re: Usage of SqlStdOperatorTable.BETWEEN from RelBuilder

2020-01-18 Thread Danny Chan
/SqlCaseOperator.java#L221 Best, Danny Chan 在 2020年1月18日 +0800 AM9:56,Hrudaya Reddy ,写道: > Hi all, > > We are trying to generate the following sql query > > SELECT [user_id], [create_date] > FROM [users] > WHERE [user_id] BETWEEN 1 AND 5 > > I am trying the following but I g

Re: Usage of SqlStdOperatorTable.BETWEEN from RelBuilder

2020-01-18 Thread Danny Chan
See https://issues.apache.org/jira/browse/CALCITE-3747 Best, Danny Chan 在 2020年1月18日 +0800 AM9:56,Hrudaya Reddy ,写道: > Hi all, > > We are trying to generate the following sql query > > SELECT [user_id], [create_date] > FROM [users] > WHERE [user_id] BETWEEN 1 AND 5 > >

[DISCUSS] Deprecate TableScanRule

2020-02-04 Thread Danny Chan
]  https://github.com/apache/calcite/blob/d6fa25cd11625ad7b4b74dafbd0211c701b38d49/core/src/main/java/org/apache/calcite/sql2rel/SqlToRelConverter.java#L3498 Best, Danny Chan

[DISCUSS] Deprecate TableScanRule

2020-02-04 Thread Danny Chan
]  https://github.com/apache/calcite/blob/d6fa25cd11625ad7b4b74dafbd0211c701b38d49/core/src/main/java/org/apache/calcite/sql2rel/SqlToRelConverter.java#L3498 Best, Danny Chan

Re: [DISCUSS] Towards Calcite 1.22

2020-02-07 Thread Danny Chan
I can do that. Andrei Sereda 于2020年2月8日 周六上午6:18写道: > Is there anyone willing to swap a Calcite release with me ? > > On Fri, Feb 7, 2020 at 12:41 PM Andrei Sereda wrote: > > > Hi Julian et al, > > > > Unfortunately my current work schedule is still very tense. There are > some > > internal dead

Re: Is there any way to view the physical SQLs executed by Calcite JDBC?

2020-02-11 Thread Danny Chan
You can set a debug break point in the RelToSqlConverter I think. Best, Danny Chan 在 2020年2月11日 +0800 AM3:51,Yang Liu ,写道: > Hi there, recently I am studying Apache Calcite, by now I can use explain > plan for via JDBC to view the logical plan, and I am wondering how can I > view the phy

Re: [DISCUSS] Towards Calcite 1.22

2020-02-11 Thread Danny Chan
Sure, we can do a switch. My next release is 1.24 Best, Danny Chan 在 2020年2月12日 +0800 AM1:09,Andrei Sereda ,写道: > Thanks for stepping in Danny. Can I take your release ? > > On Mon, Feb 10, 2020 at 2:34 PM Julian Hyde wrote: > > > It would be helpful for us to test th

Re: Is there any way to view the physical SQLs executed by Calcite JDBC?

2020-02-12 Thread Danny Chan
I think we can patch this code to master Best, Danny Chan 在 2020年2月12日 +0800 PM5:26,Yang Liu ,写道: > Hi all, > > on StackOverflow someone give a solution which seems great: > https://stackoverflow.com/a/60116333/1614589 > > Yang Liu 于2020年2月12日周三 下午3:29写道: > > > Hi V

Re: Not able use PostgresDialect.

2020-02-13 Thread Danny Chan
If you want to parse the sql in PostgreSQL dialect, there is no way to do that now. You need a new SqlConformance actually. Shivraj Singh 于2020年2月13日 周四下午3:50写道: > Hi, I want to parse the query of PostgreSQL via Calcite and while I am > parsing the query using the calcite parser it gives me excep

[ DISCUSS ] Revert change: CALCITE-3713 Remove column names from Project#digest

2020-02-13 Thread Danny Chan
/54bf3ed733eb7e725ce3ea397334aad8f1323ead13e450b1753b1521%40%3Cdev.calcite.apache.org%3E Best, Danny Chan

Re: Not able use PostgresDialect.

2020-02-13 Thread Danny Chan
el parser. It can handle (or could > > handle) SQL extensions that are not in standard SQL and which we don't > > want to bring into Calcite SQL. PostgreSQL's "::" cast operator is an > > example of that. > > > > On Thu, Feb 13, 2020 at 4:00 AM Danny Chan

Re: [ DISCUSS ] Revert change: CALCITE-3713 Remove column names from Project#digest

2020-02-13 Thread Danny Chan
> if you use explain_digest attributes, it means you expect it might change due to implementation details. That is what you just defined that, why a digest should be changed just because of the implementation. Best, Danny Chan 在 2020年2月14日 +0800 PM2:54,Vladimir Sitnikov ,写道: > The subj

Re: Not able use PostgresDialect.

2020-02-14 Thread Danny Chan
The XXXDialect is used for translating the Calcite RelNode tree to normal sql text that is used in the JDBC connection to external engines, so it is actually “unparsing”, what you need is parsing sql text to RelNode. Best, Danny Chan 在 2020年2月14日 +0800 PM3:58,Shivraj Singh ,写道: > Thanks @Da

Re: Talk about Calcite at University of Cergy-Pontoise (France) on 3 March 2020

2020-02-15 Thread Danny Chan
Thanks for the share, look forward to the talk! Stamatis Zampetakis 于2020年2月15日 周六下午5:39写道: > Hello, > > In case somebody is interested, I will give an introductory talk about > query optimization and Calcite for master students at the University of > Cergy-Pontoise in France, on 3 March 2020 [1]

Re: [ DISCUSS ] Revert change: CALCITE-3713 Remove column names from Project#digest

2020-02-16 Thread Danny Chan
for me, I just need a conclusion ~ Best, Danny Chan 在 2020年2月14日 +0800 PM2:54,Vladimir Sitnikov ,写道: > The subject of the mail does not match the body. > > Please double check and ensure you mention a single change. > > > PS if you use explain_digest attributes, it means y

Re: [ DISCUSS ] Revert change: CALCITE-3713 Remove column names from Project#digest

2020-02-17 Thread Danny Chan
Thanks Vladimir, too many config options is hard to maintain, so no need to add that, i would use the explain_attributes and update the log files. The explain would not change frequently, right? Vladimir Sitnikov 于2020年2月18日 周二上午12:45写道: > > And state that it is going to be removed before say 1.

Re: Correlation with a variable

2020-02-17 Thread Danny Chan
From the case you gave, the “variable” seems a view ? Sorry I’m not familiar with the traditional RDBMS. Best, Danny Chan 在 2020年2月17日 +0800 PM1:27,Christian Beikov ,写道: > Hello, > > I asked this before but I guess the question got too big, so I thought > splitting it up might be b

Re: Correlation with a variable

2020-02-18 Thread Danny Chan
ed, but I have no idea how to avoid > quoting for this single use case with the relational algebra model in > Calcite. > > Regards, > > Christian > > Am 18.02.2020 um 04:22 schrieb Danny Chan: > > From the case you gave, the “variable” seems a view ? Sorry I’m not

Re: log4j settings in Calcite

2020-02-18 Thread Danny Chan
Hi, Radim ~ Did you open the project from existing one or a fresh new ? The Calcite use log4j 1.17 but there seems some class path problems with your env. Best, Danny Chan 在 2020年2月19日 +0800 AM4:28,Baca Radim ,写道: > Hi, > > I have downloaded the Calcite and opened its Gradle project in

[DISCUSS] Towards Calcite 1.22.0

2020-02-19 Thread Danny Chan
r you! [1] https://issues.apache.org/jira/secure/Dashboard.jspa?selectPageId=12333950 Best, Danny Chan

[DISCUSS] Towards Calcite 1.22.0

2020-02-19 Thread Danny Chan
! [1] https://issues.apache.org/jira/secure/Dashboard.jspa?selectPageId=12333950 Best, Danny Chan

[DISCUSS] Towards Calcite 1.22.0

2020-02-19 Thread Danny Chan
! [1] https://issues.apache.org/jira/secure/Dashboard.jspa?selectPageId=12333950 Best, Danny Chan

Re: limitations on the SQLs executed

2020-02-20 Thread Danny Chan
You are right, we have only row count into the source. There is no meta can describe the query performance. Can you multiply the row count with a explicit factor? Yang Liu 于2020年2月20日 周四下午5:05写道: > Currently I can use following code to getCost, > > def getCost(rootSchema: SchemaPlus, sql: String)

Re: limitations on the SQLs executed

2020-02-20 Thread Danny Chan
Sorry to tell that Calcite runtime is not designed to query bigdata. It actually executes all the operator in single task. In distributed systems like Spark or Flink, we usually fallback to merge join instead of hash when the data is huge. Danny Chan 于2020年2月20日 周四下午10:16写道: > You are right,

Re: Calcite equivalent for Select CONVERT date formatter

2020-02-20 Thread Danny Chan
>From varchar to date? Suresh Krishnan 于2020年2月20日 周四下午1:55写道: > Hi Team, > > We are having trouble finding the right approach to convert the date > fields using calcite. > > We are looking for something that will give us the below SQL equivalent > SELECT CONVERT(varchar(12), GETD

Re: How to optimize repeated RelNode Structures? (CALCITE-3806)

2020-02-20 Thread Danny Chan
Calcite has a Spool operator, maybe you can check that. Anjali Shrishrimal 于2020年2月20日 周四下午3:20写道: > Hi everybody, > > I would like to have your suggestions on CALCITE-3806. > > Asking it here as suggested by Julian. > > > > > > If RelNode tree contains a subtree whose result can be obtained by s

Re: [DISCUSS] Towards Calcite 1.22.0

2020-02-20 Thread Danny Chan
Thanks ~ I found there are 2 new issues https://issues.apache.org/jira/browse/CALCITE-3809 from Chunwei https://issues.apache.org/jira/browse/CALCITE-3811  from Julian Are these issue planning to be included in 1.22.0 ? Expect for your confirm. Best, Danny Chan 在 2020年2月21日 +0800 AM10:02

RE: Re: Calcite equivalent for Select CONVERT date formatter

2020-02-20 Thread Danny Chan
Is this [1] what you need ? [1] https://issues.apache.org/jira/browse/CALCITE-2980 Best, Danny Chan 在 2020年2月21日 +0800 AM8:23,Hrudaya Reddy ,写道: > Hi Julian and Danny, > > We are basically looking for the equivalent SQL Server CONVERT() function > which converts a value (of any

Re: Date and time formats in the standard operator table

2020-02-20 Thread Danny Chan
Maybe the format for CAST in SQL 2016 [1] is what you need, it’s not implemented yet. [1] https://issues.apache.org/jira/browse/CALCITE-2980 Best, Danny Chan 在 2020年2月20日 +0800 PM7:02,Soma Mondal ,写道: > Hi, > > > We are seeing that in many dialects, there is support for form

Re: limitations on the SQLs executed

2020-02-21 Thread Danny Chan
Yes, if you use totally the Calcite runtime, modify the queries is a way to avoid huge memory consumption. Best, Danny Chan 在 2020年2月21日 +0800 PM3:52,Yang Liu ,写道: > Thanks Danny, > > multiplying row count and factor seems not help. In following query > > PLAN: Enumerable

[Needs help] How to config PGP key of Apache

2020-02-21 Thread Danny Chan
but the committer key page still shows “key not found” ~ Maybe it’s not the right place to ask the question, but can someone help me for that, many thanks !! Best, Danny Chan

Re: [Needs help] How to config PGP key of Apache

2020-02-22 Thread Danny Chan
I already did that ~ Best, Danny Chan 在 2020年2月22日 +0800 PM3:30,Rui Wang ,写道: > To make your key appear on the committer link. As I recalled you have to > login https://id.apache.org/ and fill out "OpenPGP Public Key Primary > Fingerprint" > > > > -Rui > > On

Re: [Needs help] How to config PGP key of Apache

2020-02-22 Thread Danny Chan
Very detail instructions, I have added my PGP key to the KEYS file. Best, Danny Chan 在 2020年2月22日 +0800 PM2:03,Francis Chuang ,写道: > Hey Danny, > > You need to update the KEYS file. See instructions here: > https://gist.github.com/F21/b0e8c62c49dfab267ff1d0c6af39ab84#updating-your-key

Re: [DISCUSS] Towards Calcite 1.22.0

2020-02-23 Thread Danny Chan
I’m preparing RC0 ~ Best, Danny Chan 在 2020年2月21日 +0800 PM12:02,Danny Chan ,写道: > Thanks ~ > > I found there are 2 new issues > > https://issues.apache.org/jira/browse/CALCITE-3809 from Chunwei > https://issues.apache.org/jira/browse/CALCITE-3811  from Julian > > Are th

[VOTE] Release apache-calcite-1.22.0 (release candidate 0)

2020-02-24 Thread Danny Chan
. [ ] +1 Release this package as Apache Calcite X.Y.Z [ ] 0 I don't feel strongly about it, but I'm okay with the release [ ] -1 Do not release this package because... Here is my vote: +1 (binding) Best, Danny Chan

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

2020-02-24 Thread Danny Chan
Just to note that, I have updated the release note though, so the history.md has diff for tar.gz in  https://dist.apache.org/repos/dist/dev/calcite/apache-calcite-1.22.0-rc0/ and the source tag calcite-1.22.0. Best, Danny Chan 在 2020年2月24日 +0800 PM6:34,Danny Chan ,写道: > Hi all, > &g

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

2020-02-24 Thread Danny Chan
ira/browse/CALCITE-3769 Best, Danny Chan 在 2020年2月24日 +0800 PM9:55,Enrico Olivelli ,写道: > Danny, > We are testing HerdDB with 1.22.0rc0 tag and we are seeing problems with > Joins. > > We were still on 1.19.0 and in December we created a test branch > against current Calcite'

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

2020-02-24 Thread Danny Chan
I would try to have an upgrade for the Avatica to 1.16.0 for the RC1. Best, Danny Chan 在 2020年2月25日 +0800 AM4:25,Francis Chuang ,写道: > There was a problem with the docker images not being built when a > release was pushed. The Avatica code itself is fine, so I think it > should be safe t

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

2020-02-24 Thread Danny Chan
The voting was canceled for 2 reasons: 1. Upgrade Avatica to 1.16.0 2. Update the release notes I’m preparing RC1 now ~ Best, Danny Chan 在 2020年2月25日 +0800 AM11:06,Danny Chan ,写道: > I would try to have an upgrade for the Avatica to 1.16.0 for the RC1. > > Best, > Danny Chan &g

[VOTE] Release apache-calcite-1.22.0 (release candidate 1)

2020-02-24 Thread Danny Chan
. [ ] +1 Release this package as Apache Calcite 1.22.0 [ ] 0 I don't feel strongly about it, but I'm okay with the release [ ] -1 Do not release this package because... Here is my vote: +1 (binding) Best, Danny Chan

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

2020-02-25 Thread Danny Chan
Hi fellow, can you help to verify this release if you have time ? We plan to release at this Friday and there is no much time left. Best, Danny Chan 在 2020年2月25日 +0800 PM12:56,Danny Chan ,写道: > Hi all, > > I have created a build for Apache Calcite 1.22.0, release candidate 0. >

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

2020-02-25 Thread Danny Chan
/820f6ab4965d79946e4144db8e33aeef98c3d2ff 2. https://github.com/apache/calcite/commit/10a5b8a89d319e6fed563e7e49518cfc960b93d6 Both seem to be a result fix though ~ Best, Danny Chan 在 2020年2月25日 +0800 PM2:44,Enrico Olivelli ,写道: > Danny, > This is our workbench > > > https://github.com

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

2020-02-25 Thread Danny Chan
e OK > * Run Calcite tests with the RC OK > > > Best, > Chunwei > > > On Tue, Feb 25, 2020 at 5:04 PM Danny Chan wrote: > > > Hi fellow, can you help to verify this release if you have time ? We plan > > to release at this Friday and there is no much time left.

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

2020-02-25 Thread Danny Chan
Yes, it is canceled. Best, Danny Chan 在 2020年2月25日 +0800 PM6:30,Chunwei Lei ,写道: > Should this vote be canceled since there is release candida 1? > > Best, > Chunwei > > > On Tue, Feb 25, 2020 at 5:08 PM Danny Chan wrote: > > > Without a plan diff of each case,

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

2020-02-25 Thread Danny Chan
I also found this, but look at the info it seems expected, this is done by the Gradle plugin, maybe @Vladimir Sitnikov can answer the question better ~ Best, Danny Chan 在 2020年2月25日 +0800 PM7:51,Enrico Olivelli ,写道: > I am building the RC > I found this warning in logs, it looks like a s

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

2020-02-25 Thread Danny Chan
Thanks for the kindly reminder, would follow that style ~ Best, Danny Chan 在 2020年2月25日 +0800 PM9:25,Stamatis Zampetakis ,写道: > Normally there should be a separate [CANCEL] [VOTE] email like [1]. > > Btw, thanks for driving this huge release forward Danny. > > Best, > Stamat

[CANCEL] [VOTE] Release apache-calcite-1.22.0 (release candidate 1)

2020-02-25 Thread Danny Chan
The vote for Apache Calcite 1.2120 release candidate 1 was cancelled due to the invalid LICENCE, see https://issues.apache.org/jira/browse/CALCITE-3822 for details. Thanks to all who voted. A new release will be tagged as 1.22.0-rc2 and will be available for voting soon. Best, Danny Chan

[VOTE] Release apache-calcite-1.22.0 (release candidate 2)

2020-02-25 Thread Danny Chan
. [ ] +1 Release this package as Apache Calcite 1.22.0 [ ] 0 I don't feel strongly about it, but I'm okay with the release [ ] -1 Do not release this package because... Here is my vote: +1 (binding) Best, Danny Chan

Re: [VOTE] Release apache-calcite-1.22.0 (release candidate 2)

2020-02-26 Thread Danny Chan
Replied in the JIRA issue, I tried to reproduce your case but failed, can you give one in Calcite, thanks. Best, Danny Chan 在 2020年2月26日 +0800 PM3:04,Enrico Olivelli ,写道: > Danny, > I have created https://issues.apache.org/jira/browse/CALCITE-3826 > for the problem about bind variables

Re: [VOTE] Release apache-calcite-1.22.0 (release candidate 2)

2020-02-26 Thread Danny Chan
they still what a EnumerableTableScan, which is error prone for the reason I have illustrated in the EnumerableTableScan comments To fix this, change your plan to the correct one or implement your Table correctly. Best, Danny Chan 在 2020年2月26日 +0800 PM3:16,Stamatis Zampetakis ,写道: > Anton a

Re: [VOTE] Release apache-calcite-1.22.0 (release candidate 2)

2020-02-26 Thread Danny Chan
a release now ~ Best, Danny Chan 在 2020年2月26日 +0800 PM1:23,Danny Chan ,写道: > Hi all, > > I have created a build for Apache Calcite 1.22.0, release candidate 2. > > Thanks to everyone who has contributed to this release. > You can read the release notes here: > https://gith

Re: [VOTE] Release apache-calcite-1.22.0 (release candidate 2)

2020-02-26 Thread Danny Chan
Gives a -1 when you are sure that it is a bug, or the voting would be very depressing, anyone can give a -1 for any reasons. Best, Danny Chan 在 2020年2月26日 +0800 PM3:04,Enrico Olivelli ,写道: > Danny, > I have created https://issues.apache.org/jira/browse/CALCITE-3826 > for the problem a

Re: javacc problem: support "!" as "NOT"

2020-02-26 Thread Danny Chan
You can add a token and alias it as you like. The token is always a reserved keyword. Best, Danny Chan 在 2020年2月27日 +0800 AM11:23,dev@calcite.apache.org,写道: > > SqlParserImplConstants

Re: [VOTE] Release apache-calcite-1.22.0 (release candidate 2)

2020-02-27 Thread Danny Chan
: gpg: 签名建立于 三 2/26 12:47:33 2020 CST gpg: 使用 RSA 密钥 9A48922F682AB05D1AE4A3E7C2931E4BDB03D5AE gpg: 完好的签名,来自于 “Danny Chan (yuzhao.cyz gpg) ” [绝对] Best, Danny Chan 在 2020年2月28日 +0800 AM5:13,Rui Wang ,写道: > Hi Danny, > > Thanks a lot for all Danny's contributions so far on this release

Travis filed: net.hydromatic.foodmart.queries does not exist

2020-02-27 Thread Danny Chan
The Travis failed recently very frequently, such as https://travis-ci.org/apache/calcite/jobs/656071104?utm_medium=notification&utm_source=github_status It always reports net.hydromatic.foodmart.queries does not exist Can someone help with that ? Best, Danny Chan

Re: Travis filed: net.hydromatic.foodmart.queries does not exist

2020-02-28 Thread Danny Chan
That was great, thanks Julian for your spare time work ! Best, Danny Chan 在 2020年2月28日 +0800 PM3:58,Julian Hyde ,写道: > I’ll take a look tomorrow. > > Julian > > > On Feb 27, 2020, at 8:06 PM, Danny Chan wrote: > > > > The Travis failed recently very frequently, suc

Re: [ANNOUNCE] New committer: Feng Zhu

2020-02-29 Thread Danny Chan
Congratulations! Francis Chuang 于2020年2月29日 周六下午4:35写道: > Congrats, well-deserved! > > On 29/02/2020 6:26 pm, Stamatis Zampetakis wrote: > > Apache Calcite's Project Management Committee (PMC) has invited Feng > > Zhu to become a committer, and we are pleased to announce that he > > has accepted.

Re: [VOTE] Release apache-calcite-1.22.0 (release candidate 2)

2020-02-29 Thread Danny Chan
I agree to only release tar.gz, thanks for the reminder ~ Stamatis Zampetakis 于2020年2月29日 周六下午11:25写道: > In the last release of avatica we didn't release two archives in the end > (but only the .tar.gz) [1]. > Before that for a quite some time we were releasing only the tar.gz > archive. > I woul

Re: Travis filed: net.hydromatic.foodmart.queries does not exist

2020-02-29 Thread Danny Chan
Cool, thanks for the fix, Julian ~ Best, Danny Chan 在 2020年3月1日 +0800 AM8:48,Julian Hyde ,写道: > OK, clearing the cache seems to have done the trick. “master” and > “branch-1.22” both had built successfully. > > > On Feb 29, 2020, at 3:26 PM, Julian Hyde wrote: > > > &

Re: [ANNOUNCE] New committer: Feng Zhu

2020-02-29 Thread Danny Chan
Awesome, expect to have the new Tencent logo ~ Best, Danny Chan 在 2020年3月1日 +0800 AM7:33,Julian Hyde ,写道: > PS This is the “powered by” page: > https://calcite.apache.org/docs/powered_by.html > <https://calcite.apache.org/docs/powered_by.html> > > > On Feb 29, 2020,

Re: [VOTE] Release apache-calcite-1.22.0 (release candidate 2)

2020-02-29 Thread Danny Chan
TRUST is a requirement. Best, Danny Chan 在 2020年2月29日 +0800 PM4:51,Vladimir Sitnikov ,写道: > Danny, thanks for putting things together, however, I guess the vote mail > requires clarifications before the votes can be cast :-/ > > Danny>The hashes of the artifacts are as follows: >

Re: [VOTE] Release apache-calcite-1.22.0 (release candidate 2)

2020-03-01 Thread Danny Chan
.0, we did has a tag for each release with pattern Calcite-1.22.0, so I would not follow you in this part, the original work flow is ok for me. Best, Danny Chan 在 2020年3月1日 +0800 PM2:40,dev@calcite.apache.org,写道: > > What is the error message? > AFAIK it should not require credentials to

Re: [VOTE] Release apache-calcite-1.22.0 (release candidate 2)

2020-03-02 Thread Danny Chan
Great, it seems I have missed these 2 properties: asfGitSourceUsername=test asfGitSourcePassword=test Would have a try soon ~ Best, Danny Chan 在 2020年3月2日 +0800 PM3:11,dev@calcite.apache.org,写道: > > asfGitSourceUsername=test > asfGitSourcePassword=test

Re: svn commit: r38276 - /dev/calcite/apache-calcite-1.23.0-rc1/

2020-03-02 Thread Danny Chan
I found this cmd: ./gradlew removeStaleArtifacts -Pasf How can i use this cmd to remove only one rc files ? Best, Danny Chan 在 2020年3月1日 +0800 PM4:27,volody...@apache.org,写道: > Hi Danny, > > Perhaps it was pushed accidentally, could you please remove it to avoid > confusion? >

[CANCEL] [VOTE] Release apache-calcite-1.22.0 (release candidate 2)

2020-03-02 Thread Danny Chan
: Add BindableTableScanRule into the default ruleset - [CALCITE-3826] UPDATE assigns wrong type to bind variables - [CALCITE-3830] The ‘approximate’ field should be considered when computing the digest of AggregateCall Best, Danny Chan

[VOTE] Release apache-calcite-1.22.0 (release candidate 3)

2020-03-02 Thread Danny Chan
is open for the next 72 hours and passes if a majority of at least three +1 PMC votes are cast. [ ] +1 Release this package as Apache Calcite 1.22.0 [ ] 0 I don't feel strongly about it, but I'm okay with the release [ ] -1 Do not release this package because... Here is my vote: +1 (binding) Best, Danny Chan

Re: svn commit: r38276 - /dev/calcite/apache-calcite-1.23.0-rc1/

2020-03-02 Thread Danny Chan
Thanks, the SVN command works. Best, Danny Chan 在 2020年3月2日 +0800 PM7:30,Vladimir Sitnikov ,写道: > > ./gradlew removeStaleArtifacts -Pasf > > How can i use this cmd to remove only one rc files ? > > It is configured in staleRemovalFilters block in > https://github.co

Re: [VOTE] Release apache-calcite-1.22.0 (release candidate 3)

2020-03-03 Thread Danny Chan
Thanks Julian and Stamatis, would fix the release note though ~ Best, Danny Chan 在 2020年3月4日 +0800 AM7:20,Stamatis Zampetakis ,写道: > Ubuntu 18.04.4 LTS, jdk 1.8.0_212, Gradle wrapper > > * Checked signatures and checksums OK > * Build and run unit tests (./gradlew clean build) on

Re: [VOTE] Release apache-calcite-1.22.0 (release candidate 3)

2020-03-03 Thread Danny Chan
because long time passes and there are 260+ commits, how could a release manager to keep every commit message “readable”. So I would just ignore that ~ Best, Danny Chan 在 2020年3月4日 +0800 AM7:20,Stamatis Zampetakis ,写道: > Ubuntu 18.04.4 LTS, jdk 1.8.0_212, Gradle wrapper > > * Checked signa

[RESULT] [VOTE] Release apache-calcite-1.22.0 (release candidate 3)

2020-03-04 Thread Danny Chan
Thanks to everyone who has tested the release candidate and given their comments and votes. The tally is as follows. 4 binding +1s: Danny Chan Vladimir Sitnikov Francis Chuang Julian Hyde 5 non-binding +1s: Rui Wang Feng Zhu Enrico Olivelli Ruben Q L Chunwei Lei 1 binding 0: Stamatis

Re: [RESULT] [VOTE] Release apache-calcite-1.22.0 (release candidate 3)

2020-03-05 Thread Danny Chan
It is always commitable ~ Best, Danny Chan 在 2020年3月5日 +0800 PM4:36,Ruben Q L ,写道: > Thanks Danny! > Could you please confirm when the master branch is re-opened for commits? > Best, > Ruben > > > Le jeu. 5 mars 2020 à 04:04, Danny Chan a écrit : > > > Thanks

Re: [Needs Help] How to generate the right java doc for the site ?

2020-03-05 Thread Danny Chan
Thanks, let me try the docker ~ Best, Danny Chan 在 2020年3月5日 +0800 PM7:18,Francis Chuang ,写道: > I am not sure what yours is building in Chinese, perhaps it's due to > your OS language? Can you try using docker to generate the docs? > > On 5/03/2020 10:06 pm, Danny Chan wrote: >

Re: Why can't RexLiteral.getValue2() get a double/float value?

2020-03-05 Thread Danny Chan
Literal actually does not have a exact data type, 1.23 can be both float or decimal, in order not to lose precision,we represent it as decimal internal. Xiangwei Wei 于2020年3月5日 周四下午5:09写道: > Thank you for reply. What I want is a getValue() method which returns > exactly the value of literal based

Re: rewrite an optimized RelNode

2020-03-05 Thread Danny Chan
Is your optimize an implementation ? Or heuristic or needs some metadata? Yang Liu 于2020年3月5日 周四下午3:48写道: > In Calcite, after optimization provided by the default VolcanoPlanner, we > can get an optimized RelNode, but can we have a further optimization? For > example I want to add an Elasticsearc

Re: [RESULT] [VOTE] Release apache-calcite-1.22.0 (release candidate 3)

2020-03-05 Thread Danny Chan
Mar 5, 2020, at 2:23 AM, Danny Chan wrote: > > > > It is always commitable ~ > > > > Best, > > Danny Chan > > 在 2020年3月5日 +0800 PM4:36,Ruben Q L ,写道: > >> Thanks Danny! > >> Could you please confirm when the master branch is re-opened for > c

[Needs Help] How to disable notifications for bulk operations

2020-03-05 Thread Danny Chan
+Move Best, Danny Chan

[Needs Help] How to sync the jar to mvn repository

2020-03-05 Thread Danny Chan
I release the staging repository yesterday and it appears here https://search.maven.org/artifact/org.apache.calcite/calcite-core/1.22.0/jar But how to sync it to the mvnrepository.com ? Sorry I’m first time for it. https://mvnrepository.com/artifact/org.apache.calcite/calcite-core Best, Danny

Re: [Needs Help] How to sync the jar to mvn repository

2020-03-06 Thread Danny Chan
Thanks for the feedback, Enrico Olivelli ~ Best, Danny Chan 在 2020年3月6日 +0800 PM4:00,Enrico Olivelli ,写道: > It is automatic. > Just wait. > It is not important. > Downstream projects are able to already use Calcite 1.22.0 > > Enrico > > Il giorno ven 6 mar 2020 alle or

Re: "lazy" optmization?

2020-03-06 Thread Danny Chan
Sorry to tell that Calcite runtime does not support this, the "dynamic partition pruning" or "runtime filter" called in Impala, would build a bloom filter for the join keys for the build side table and push it down to the probe table source, thus, in some cases, it can reduce the data. Yang Liu 于

[Feedback][Release] Some feedback when releasing v1.22.0

2020-03-06 Thread Danny Chan
] ~ • The calcite-core does not publish the test sources now, should we add it back ? [1] https://calcite.apache.org/javadocAggregate/ Best, Danny Chan

Re: "lazy" optmization?

2020-03-09 Thread Danny Chan
low of > data. > > > > > > Calcite can still help a little. > > > > > > One runtime optimization is where you split processing into phases. > Only > > > optimize the first part of your query. Build temp tables, analyze > them, and > >

Re: [Feedback][Release] Some feedback when releasing v1.22.0

2020-03-10 Thread Danny Chan
I already fix that Julian Hyde 于2020年3月11日 周三上午2:00写道: > Danny, > > Can you fix the tag please? > > Julian > > > > On Mar 6, 2020, at 10:26 AM, Vladimir Sitnikov < > sitnikov.vladi...@gmail.com> wrote: > > > >> The RexNode normalization and project names remove from digest did > change > > a lot

Re: [DISCUSS] get RexExecutor from RexSimplify in method reduceExpressionsInternal

2020-03-16 Thread Danny Chan
Java reflection). So, in total, the executor in RexSimplify has a fallback is because it’s expression to reduce is simple enough. Best, Danny Chan 在 2020年3月16日 +0800 PM3:57,JiaTao Tao ,写道: > In method reduceExpressionsInternal, we get RexExecutor from cluster, it can > be null: > <>

Re: [DISCUSS] get RexExecutor from RexSimplify in method reduceExpressionsInternal

2020-03-17 Thread Danny Chan
that, the constant reduction just not happens, it is better than supplying a default RexExecutor but does not really work for all expression. So I’m +0 for this. Best, Danny Chan 在 2020年3月17日 +0800 PM4:16,JiaTao Tao ,写道: > Hi Danny > > Thanks for your reply, I think Stamatis Zampetakis

Re: [DISCUSS] get RexExecutor from RexSimplify in method reduceExpressionsInternal

2020-03-19 Thread Danny Chan
This is a preference, I would prefer the default value to not throw exceptions. Best, Danny Chan 在 2020年3月18日 +0800 PM3:53,Stamatis Zampetakis ,写道: > If a Janino exception comes up then it is a bug that we have to fix since > it violates the contract of the interface. > > From my p

Re: STREAM keyword

2020-03-24 Thread Danny Chan
In Apache Flink, we have a syntax: … A JOIN B for SYSTEM_TIME AS OF A.PROC_TIME To describe a stream A join a temporal table B where we only want to join the records with the current machine time as the time point of table B. Is that the case Viliam described ? Best, Danny Chan 在 2020年3月25日

Re: Parsing Teradata SQL with Apache Calcite

2020-03-29 Thread Danny Chan
If you only want to add some extension operators for TD, modify  SqlLibraryOperators.java is okey. If you also want to interact with TD through JDBC connection, a TD SqlDialect may also need to be introduced. Best, Danny Chan 在 2020年3月28日 +0800 PM5:32,David Valenzuela Rodriguez ,写道: >

Re: Draft board report for April 2020

2020-04-02 Thread Danny Chan
if I have time (on the weekend). I think things would be better and better, Calcite is a great project and we deserve to have more active committers in the future ~ Best, Danny Chan 在 2020年4月2日 +0800 AM6:08,Stamatis Zampetakis ,写道: > Attached below is a draft of this month's board report

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

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

  1   2   3   4   >