Re: Flink SQL build-in function questions.

2021-11-13 Thread Yuval Itzchakov
I recall looking for these once in the SQL standard spec, AFAIR they are not part of it. On Fri, Nov 12, 2021, 11:48 Francesco Guardiani wrote: > Yep I agree with waiting for calcite to support it. As a temporary > workaround you can define your own udfs with that functionality. > > I also wonde

Re: Flink SQL build-in function questions.

2021-11-12 Thread Francesco Guardiani
Yep I agree with waiting for calcite to support it. As a temporary workaround you can define your own udfs with that functionality. I also wonder, are the bitwise operators defined in the ansi sql specification? Or should we just follow the common sense behavior of databases supporting it? On Fri

Re: Flink SQL build-in function questions.

2021-11-12 Thread JIN FENG
Sure, I can take a try. Before starting the work, we should discuss the api of bit operation function. There are two alternatives 1. add some built in functions include bitAnd,bitNot,bitOr,bitXor 2. support &, |, ^, ~ operators in calcite first. Currently, there is a relative jira https://issues.a

Re: Flink SQL build-in function questions.

2021-11-11 Thread Martijn Visser
Hi, I don't think there's currently anyone in the community who is working on the bit operation functions. Would you be interested and able to make a contribution on that? Best regards, Martijn On Thu, 11 Nov 2021 at 03:54, JIN FENG wrote: > hi all, > I met two problems when I use FlinkSQL. >

Flink SQL build-in function questions.

2021-11-10 Thread JIN FENG
hi all, I met two problems when I use FlinkSQL. 1. Is there any plan to support bit operation functions ? Currently there is some jira mentioned about this, https://issues.apache.org/jira/browse/FLINK-14990 , https://issues.apache.org/jira/browse/FLINK-12451 But It seems that it hasn't been u