[ https://issues.apache.org/jira/browse/SPARK-28121?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Yuming Wang updated SPARK-28121: -------------------------------- Description: {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} was: {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) {noformat} > String Functions: decode can not accept 'escape' 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 (v7.6.14#76016) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org