You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by hongbin ma <ma...@apache.org> on 2016/09/17 12:49:24 UTC
any plan to support "replace" function?
hi experts
recently we need to enable "replace" function for our customer, like
replacing all the X with Y in "123X456X". According to
https://calcite.apache.org/docs/reference.html the replace function seems
not implemented. I see there's another function called "OVERLAY", however
it's replacing with "index" instead of a "pattern".
Is there any plans to support replace function? Do I have to implement a
UDF by myself now?
--
Regards,
*Bin Mahone | 马洪宾*
Re: any plan to support "replace" function?
Posted by hongbin ma <ma...@apache.org>.
Thanks Julian, it's really helpful. Just want to make sure there's no
duplicated efforts.
On Sun, Sep 18, 2016 at 12:57 AM, Julian Hyde <jh...@apache.org> wrote:
> I find it frustrating when you ask “are there plans to…”. Calcite is a
> volunteer project. I don’t know what other contributors are doing, and I
> don’t control their time. If someone is working on something, they will
> have logged a JIRA case and marked it “in progress” or set the “fix
> version” field. If you had done a search, you would have found a JIRA case
> [1]; it has been inactive for 2 years.
>
> If you really want this function, contribute a patch.
>
> Julian
>
> [1] https://issues.apache.org/jira/browse/CALCITE-420 <
> https://issues.apache.org/jira/browse/CALCITE-420>
>
> > On Sep 17, 2016, at 5:49 AM, hongbin ma <ma...@apache.org> wrote:
> >
> > hi experts
> >
> > recently we need to enable "replace" function for our customer, like
> > replacing all the X with Y in "123X456X". According to
> > https://calcite.apache.org/docs/reference.html the replace function
> seems
> > not implemented. I see there's another function called "OVERLAY", however
> > it's replacing with "index" instead of a "pattern".
> >
> > Is there any plans to support replace function? Do I have to implement a
> > UDF by myself now?
> >
> > --
> > Regards,
> >
> > *Bin Mahone | 马洪宾*
>
>
--
Regards,
*Bin Mahone | 马洪宾*
Re: any plan to support "replace" function?
Posted by Julian Hyde <jh...@apache.org>.
I find it frustrating when you ask “are there plans to…”. Calcite is a volunteer project. I don’t know what other contributors are doing, and I don’t control their time. If someone is working on something, they will have logged a JIRA case and marked it “in progress” or set the “fix version” field. If you had done a search, you would have found a JIRA case [1]; it has been inactive for 2 years.
If you really want this function, contribute a patch.
Julian
[1] https://issues.apache.org/jira/browse/CALCITE-420 <https://issues.apache.org/jira/browse/CALCITE-420>
> On Sep 17, 2016, at 5:49 AM, hongbin ma <ma...@apache.org> wrote:
>
> hi experts
>
> recently we need to enable "replace" function for our customer, like
> replacing all the X with Y in "123X456X". According to
> https://calcite.apache.org/docs/reference.html the replace function seems
> not implemented. I see there's another function called "OVERLAY", however
> it's replacing with "index" instead of a "pattern".
>
> Is there any plans to support replace function? Do I have to implement a
> UDF by myself now?
>
> --
> Regards,
>
> *Bin Mahone | 马洪宾*