[ https://issues.apache.org/jira/browse/CARBONDATA-583?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15798030#comment-15798030 ]
Naresh P R commented on CARBONDATA-583: --------------------------------------- Hi, Can u try to use spark regexp_replace function instead of adding new udf. eg., select regexp_replace('aaabbccaabb', 'aaa', 't'); which will return expected output : "tbbccaabb" > 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: 20m > 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)