[jira] [Commented] (CARBONDATA-583) Replace Function is not working for string/char

[Akash R Nilugal (Jira)]

    [ https://issues.apache.org/jira/browse/CARBONDATA-583?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15800422#comment-15800422 ]

sandeep purohit commented on CARBONDATA-583:
--------------------------------------------

[~nareshpr] yes regexp_replace function already available in org.apache.spark.sql.functions package so if we want to use that in place of replace then we document it somewhere, Most of time user try replace directly as other database.

> Replace Function is not working  for string/char
> ------------------------------------------------
>
>                 Key: CARBONDATA-583
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-583
>             Project: CarbonData
>          Issue Type: Bug
>          Components: data-load
>    Affects Versions: 1.0.0-incubating
>         Environment: cluster
>            Reporter: Anurag Srivastava
>            Assignee: Rahul Kumar
>            Priority: Minor
>          Time Spent: 40m
>  Remaining Estimate: 0h
>
> I am running "replace" function but it is giving error : "undefined function replace".
> Query : select replace('aaabbccaabb', 'aaa', 't');
> Expected Result : "tbbccaabb"
> Result : Error: org.apache.spark.sql.AnalysisException: undefined function replace; line 1 pos 30 (state=,code=0)

--
This message was sent by Atlassian JIRA
(v6.3.4#6332)