[ https://issues.apache.org/jira/browse/SPARK-28121?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16921369#comment-16921369 ]
daile edited comment on SPARK-28121 at 9/3/19 1:27 PM: ------------------------------------------------------- you can use sql like this {code:java} select hex('1234567890');{code} was (Author: 726575...@qq.com): i will work on this > String Functions: decode can not accept 'escape' and 'hex' as charset > --------------------------------------------------------------------- > > Key: SPARK-28121 > URL: https://issues.apache.org/jira/browse/SPARK-28121 > Project: Spark > Issue Type: Sub-task > Components: SQL > Affects Versions: 3.0.0 > Reporter: Yuming Wang > Priority: Major > > {noformat} > postgres=# select decode('1234567890','escape'); > decode > ------------------------ > \x31323334353637383930 > (1 row) > {noformat} > {noformat} > spark-sql> select decode('1234567890','escape'); > 19/06/20 01:57:33 ERROR SparkSQLDriver: Failed in [select > decode('1234567890','escape')] > java.io.UnsupportedEncodingException: escape > at java.lang.StringCoding.decode(StringCoding.java:190) > at java.lang.String.<init>(String.java:426) > at java.lang.String.<init>(String.java:491) > ... > spark-sql> select decode('ff','hex'); > 19/08/16 21:44:55 ERROR SparkSQLDriver: Failed in [select decode('ff','hex')] > java.io.UnsupportedEncodingException: hex > at java.lang.StringCoding.decode(StringCoding.java:190) > at java.lang.String.<init>(String.java:426) > at java.lang.String.<init>(String.java:491) > {noformat} -- This message was sent by Atlassian Jira (v8.3.2#803003) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org