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