[jira] [Commented] (SPARK-28123) String Functions: Add support btrim
[ https://issues.apache.org/jira/browse/SPARK-28123?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17274141#comment-17274141 ] Apache Spark commented on SPARK-28123: -- User 'beliefer' has created a pull request for this issue: https://github.com/apache/spark/pull/31390 > String Functions: Add support btrim > --- > > Key: SPARK-28123 > URL: https://issues.apache.org/jira/browse/SPARK-28123 > Project: Spark > Issue Type: Sub-task > Components: SQL >Affects Versions: 3.2.0 >Reporter: Yuming Wang >Priority: Major > > ||Function||Return Type||Description||Example||Result|| > |{{btrim(_{{string}}_}}{{bytea}}{{, > _{{bytes}}_}}{{bytea}}{{)}}|{{bytea}}|Remove the longest string containing > only bytes appearing in _{{bytes}}_from the start and end of > _{{string}}_|{{btrim('\000trim\001'::bytea, '\000\001'::bytea)}}|{{trim}}| > More details: https://www.postgresql.org/docs/11/functions-binarystring.html -- This message was sent by Atlassian Jira (v8.3.4#803005) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Commented] (SPARK-28123) String Functions: Add support btrim
[ https://issues.apache.org/jira/browse/SPARK-28123?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17262551#comment-17262551 ] Apache Spark commented on SPARK-28123: -- User 'beliefer' has created a pull request for this issue: https://github.com/apache/spark/pull/31128 > String Functions: Add support btrim > --- > > Key: SPARK-28123 > URL: https://issues.apache.org/jira/browse/SPARK-28123 > Project: Spark > Issue Type: Sub-task > Components: SQL >Affects Versions: 3.2.0 >Reporter: Yuming Wang >Priority: Major > > ||Function||Return Type||Description||Example||Result|| > |{{btrim(_{{string}}_}}{{bytea}}{{, > _{{bytes}}_}}{{bytea}}{{)}}|{{bytea}}|Remove the longest string containing > only bytes appearing in _{{bytes}}_from the start and end of > _{{string}}_|{{btrim('\000trim\001'::bytea, '\000\001'::bytea)}}|{{trim}}| > More details: https://www.postgresql.org/docs/11/functions-binarystring.html -- This message was sent by Atlassian Jira (v8.3.4#803005) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Commented] (SPARK-28123) String Functions: Add support btrim
[ https://issues.apache.org/jira/browse/SPARK-28123?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17260271#comment-17260271 ] Apache Spark commented on SPARK-28123: -- User 'beliefer' has created a pull request for this issue: https://github.com/apache/spark/pull/31080 > String Functions: Add support btrim > --- > > Key: SPARK-28123 > URL: https://issues.apache.org/jira/browse/SPARK-28123 > Project: Spark > Issue Type: Sub-task > Components: SQL >Affects Versions: 3.2.0 >Reporter: Yuming Wang >Priority: Major > > ||Function||Return Type||Description||Example||Result|| > |{{btrim(_{{string}}_}}{{bytea}}{{, > _{{bytes}}_}}{{bytea}}{{)}}|{{bytea}}|Remove the longest string containing > only bytes appearing in _{{bytes}}_from the start and end of > _{{string}}_|{{btrim('\000trim\001'::bytea, '\000\001'::bytea)}}|{{trim}}| > More details: https://www.postgresql.org/docs/11/functions-binarystring.html -- This message was sent by Atlassian Jira (v8.3.4#803005) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Commented] (SPARK-28123) String Functions: Add support btrim
[ https://issues.apache.org/jira/browse/SPARK-28123?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17260268#comment-17260268 ] Apache Spark commented on SPARK-28123: -- User 'beliefer' has created a pull request for this issue: https://github.com/apache/spark/pull/31080 > String Functions: Add support btrim > --- > > Key: SPARK-28123 > URL: https://issues.apache.org/jira/browse/SPARK-28123 > Project: Spark > Issue Type: Sub-task > Components: SQL >Affects Versions: 3.2.0 >Reporter: Yuming Wang >Priority: Major > > ||Function||Return Type||Description||Example||Result|| > |{{btrim(_{{string}}_}}{{bytea}}{{, > _{{bytes}}_}}{{bytea}}{{)}}|{{bytea}}|Remove the longest string containing > only bytes appearing in _{{bytes}}_from the start and end of > _{{string}}_|{{btrim('\000trim\001'::bytea, '\000\001'::bytea)}}|{{trim}}| > More details: https://www.postgresql.org/docs/11/functions-binarystring.html -- This message was sent by Atlassian Jira (v8.3.4#803005) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Commented] (SPARK-28123) String Functions: Add support btrim
[ https://issues.apache.org/jira/browse/SPARK-28123?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17253403#comment-17253403 ] jiaan.geng commented on SPARK-28123: I will do this work! > String Functions: Add support btrim > --- > > Key: SPARK-28123 > URL: https://issues.apache.org/jira/browse/SPARK-28123 > Project: Spark > Issue Type: Sub-task > Components: SQL >Affects Versions: 3.0.0 >Reporter: Yuming Wang >Priority: Major > > ||Function||Return Type||Description||Example||Result|| > |{{btrim(_{{string}}_}}{{bytea}}{{, > _{{bytes}}_}}{{bytea}}{{)}}|{{bytea}}|Remove the longest string containing > only bytes appearing in _{{bytes}}_from the start and end of > _{{string}}_|{{btrim('\000trim\001'::bytea, '\000\001'::bytea)}}|{{trim}}| > More details: https://www.postgresql.org/docs/11/functions-binarystring.html -- This message was sent by Atlassian Jira (v8.3.4#803005) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Commented] (SPARK-28123) String Functions: Add support btrim
[ https://issues.apache.org/jira/browse/SPARK-28123?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17011353#comment-17011353 ] Takeshi Yamamuro commented on SPARK-28123: -- Instead of adding a new func for binary, better to support binary types in trim like overlay? > String Functions: Add support btrim > --- > > Key: SPARK-28123 > URL: https://issues.apache.org/jira/browse/SPARK-28123 > Project: Spark > Issue Type: Sub-task > Components: SQL >Affects Versions: 3.0.0 >Reporter: Yuming Wang >Priority: Major > > ||Function||Return Type||Description||Example||Result|| > |{{btrim(_{{string}}_}}{{bytea}}{{, > _{{bytes}}_}}{{bytea}}{{)}}|{{bytea}}|Remove the longest string containing > only bytes appearing in _{{bytes}}_from the start and end of > _{{string}}_|{{btrim('\000trim\001'::bytea, '\000\001'::bytea)}}|{{trim}}| > More details: https://www.postgresql.org/docs/11/functions-binarystring.html -- This message was sent by Atlassian Jira (v8.3.4#803005) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org
[jira] [Commented] (SPARK-28123) String Functions: Add support btrim
[ https://issues.apache.org/jira/browse/SPARK-28123?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16899349#comment-16899349 ] EdisonWang commented on SPARK-28123: seems it is the same with trim() on both sides? > String Functions: Add support btrim > --- > > Key: SPARK-28123 > URL: https://issues.apache.org/jira/browse/SPARK-28123 > Project: Spark > Issue Type: Sub-task > Components: SQL >Affects Versions: 3.0.0 >Reporter: Yuming Wang >Priority: Major > > ||Function||Return Type||Description||Example||Result|| > |{{btrim(_{{string}}_}}{{bytea}}{{, > _{{bytes}}_}}{{bytea}}{{)}}|{{bytea}}|Remove the longest string containing > only bytes appearing in _{{bytes}}_from the start and end of > _{{string}}_|{{btrim('\000trim\001'::bytea, '\000\001'::bytea)}}|{{trim}}| > More details: https://www.postgresql.org/docs/11/functions-binarystring.html -- This message was sent by Atlassian JIRA (v7.6.14#76016) - To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org