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 <france...@ververica.com> 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 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, Nov 12, 2021 at 9:54 AM JIN FENG <jinfeng1...@gmail.com> wrote: > >> 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.apache.org/jira/browse/CALCITE-3732 . >> >> The second would be better, But we should wait for the calcite community >> to support bit function operators first. >> >> On Fri, Nov 12, 2021 at 1:12 PM JIN FENG <jinfeng1...@gmail.com> wrote: >> >>> 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.apache.org/jira/browse/CALCITE-3732 . >>> >>> The second would be better, But we should wait for the calcite community >>> to support bit function operators first. >>> >>> On Thu, Nov 11, 2021 at 4:13 PM Martijn Visser <mart...@ververica.com> >>> wrote: >>> >>>> 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 <jinfeng1...@gmail.com> wrote: >>>> >>>>> 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 updated for a long time. >>>>> >>>>> 2. When I use hive module functions, percentile_approx would fail >>>>> because of https://issues.apache.org/jira/browse/FLINK-15855 . Is >>>>> there any other way to use the percentile functions ? >>>>> >>>>> >>>>> >>>>> >>>>> thanks, >>>>> >>>>> jinfeng >>>>> >>>>
