About CommunityOverCode Asia 2024 Share on calcite

is currently working on, please tell me, I am very willing to learn, and then share and discuss at CommunityOverCode Asia 2024 Best wishes, Cancai Cai

Re: Questions about numeric type conversion

Hi Julian, Thank you for your answer Best regards, Cancai Cai Julian Hyde 于2024年6月10日周一 05:38写道： > I believe that there are many overlapping problems, many of which are that > each DBMS has its own semantics. > > In order to emulate a particular DBMS, we need to understand its

Questions about numeric type conversion

erts numeric types to double for comparison. I am not a database developer, I am curious about where the difficulty is here, if someone can tell me, I will be very grateful and happy that I will learn something new. Best wishes, Cancai Cai

About calcite’s processing of metadata information

similar things in spark sql, I don’t know if calcite can ). Or do you have any good plans? Thank you. Best regards, Cancai cai

Re: Optimize the type conversion of spark array function and map function in calcite

Thank you for your suggestion, spark sql is open source Best wishes, Cancai Cai Mihai Budiu 于2024年4月16日周二 00:36写道： > Is the spark SQL implementation open-source? > If it is, the algorithm they use may be inferred from the code. > > Mihai > ____ >

Optimize the type conversion of spark array function and map function in calcite

Finally, thank you for reading Best wishes, Cancai Cai

Re: PRs to merge in 1.27

Hi, Mihai, Hello, thank you very much. Since I was quite busy some time ago, I didn't have time to follow up on my PR. I would be very grateful if you would review my PR and make suggestions for improvement. I will be very happy to follow up and merge it into 1.37. [1] [CALCITE-6325]

Re: How to better support the adaptation of the same functions in different dialects

I've asked a lot of questions recently, and I hope I won't cause too much trouble to the community. On 2024/03/14 10:32:09 Cancai Cai wrote: > Hello, everyone in the calcite community. > > Recently, I have been adapting the behavior of functions in different > dialects to the calci

How to better support the adaptation of the same functions in different dialects

ag is passed into Sqlfunctions) I would like to ask everyone what you think? Seriously, adaptation functions are not fun, but I want to help the community improve this problem. Best wishes, Cancai Cai [1] :https://issues.apache.org/jira/browse/CALCITE-5831 [2]: https://issues.apache.org/jira/browse/CALCITE-6325

Re: [Question] Regarding the loading conflict between SqlStdOperatorTable and SqlLibraryOperators

Hello, I conducted debugging, and the result is as you said. I may need some time to think about how to modify this part of the code. Thank you very much for your suggestion. Best regards， Cancai Cai Benchao Li 于2024年3月11日周一 21:09写道： > I didn't go deep into CALCITE-6259, so I might not a

Re: [Question] Regarding the loading conflict between SqlStdOperatorTable and SqlLibraryOperators

It seems like I can't find a suitable way to solve this problem, can you give me some suggestions? Best regards, Cancai Cai Benchao Li 于2024年3月5日周二 19:26写道： > It's not a class loading problem, it's an operator lookup mechanism, > which is a by design behavior, you can see details

Re: [ANNOUNCE] Sergey Nuyanzin joins Calcite PMC

Congratulations, Sergey!

[Question] Regarding the loading conflict between SqlStdOperatorTable and SqlLibraryOperators

nk you all. Best wishes. Cancai Cai

Re: [DISCUSS] Ensuring that Calcite is consistent with other SQL systems

For udf pushdown, I think we can refer to spark sql jdbc[1]. I tried it with spark sql, which pushed my desired udf down to the corresponding jdbc data source, which required some minor changes. Best wishes, Cancai Cai [1] https://github.com/apache/spark/tree/master/sql/core/src/main/scala/org

Re: [DISCUSS] Ensuring that Calcite is consistent with other SQL systems

wishes, Cancai Cai

Re: Reviewing blog repository

so cool , it will be very useful for beginners and users. thank you very much Best regards, Cancai cai Zhengqiang Duan 于2024年2月25日周日 19:08写道： > @Jiajun, thank you very much for putting together such a great study > material. > > Best regards, > Zhengqiang > > Jiajun Xie

Re: Some questions about calcite

Hi, Tanner Clary I also found that some sql functions return java's double.NaN when it is empty, instead of sql's null. Maybe I will raise a jira to discuss this. Best wishes, Cancai Cai Cancai Cai 于2024年2月24日周六 00:32写道： > Tanner Clary, > > Thank you very much for your help. I didn

Re: Some questions about calcite

again for your help. I am very sorry that I have caused a lot of trouble to you. Best wishes, Cancai Cai Tanner Clary 于2024年2月24日周六 00:10写道： > Cancai, > > I have authored a commit that shows you how to allow functions with > non-null operands to return null [1]. Feel free to use thi

Re: Some questions about calcite

Maybe I also overlooked some issues in the whole jira case Cancai Cai On 2024/02/23 02:01:53 Cancai Cai wrote: > I am still happy to implement them. As far as adapting the log2 function is > concerned, at present I may just not be able to guarantee that log2(0) > returns null, a

Re: Some questions about calcite

ding extreme scenarios, I will continue to adapt the type of discourse in the next jira, because I am not sure whether my current writing method is appropriate in the next jira. Cancai Cai 于2024年2月23日周五 09:50写道： > Hi, everyone > Thank you very much for your answers. In fact, my doubts may n

Re: Some questions about calcite

of mathematics or SQL. rule. If mysql is lazy from the beginning, should we still follow it instead of just adapting to an extreme situation? Best wishes. Cancai Cai On 2024/02/23 00:45:13 Tanner Clary wrote: > I feel like I'm missing something about this whole issue. We have > implemented so many fun

Some questions about calcite

When I was working CALCITE-6224 , I encountered some problems and I always had some doubts in my heart. I thought about it for a long time, maybe I think I already understand the doubts in my heart. As @mihaibudiu said, Java grammar has its own

Re: About Negative testing for adapting to different databases

Hi， Thank your for yout reply Best wishes, Cancai Cai Julian Hyde 于2024年2月9日周五 05:17写道： > Functions have slightly different behaviors on different databases. > Solving the problem starts with logging a jira case, and having a > discussion about the specification. > >

About Negative testing for adapting to different databases

sults caused by different databases and different versions) . I think we can add a negative test in calcite to tell users and developers how calcite handles the negatvie test of this kind of function, but I am not sure whether it needs to be adapted. Best wishes, Cancai Cai

Thank you everyone

learned a lot and know that I have many shortcomings. I will improve them. Thank you again. Best wishes, Cancai Cai

Re: About SqlFunctions.java slimming in calcite

with a String Function Best, Cancai Cai Forward Xu 于2024年1月30日周二 14:06写道： > hi Tanner, > Thank you very much for your reply. > In the ISO/IEC SQL standard, scalar functions can be classified into the > following types: > 1. String functions: Functions for manipulating string data, s

Re: Refactor reference.md

>> 500 functions. > >> > >> Julian > >> > >> > >>> On Jan 24, 2024, at 9:46 AM, Mihai Budiu wrote: > >>> > >>> I think we should make a separate document for the functions, and in > >>> general give more detail

Refactor reference.md

nce.md document to enhance its completeness. This would allow users to easily access the documentation for the respective database functions. Thanks as always, Cancai Cai https://www.postgresql.org/docs/16/functions-formatting.html#FUNCTIONS-FORMATTING-DATETIME-TABLE