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 >>>> >>>
