[SPARK-28121] String Functions: decode/encode can not accept 'escape' and 'hex' as charset

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Yuming Wang
• Created: 20/Jun/19 08:58
• Updated: 29/Dec/19 06:00

Description

postgres=# select decode('1234567890','escape');
decode
------------------------
\x31323334353637383930
(1 row)

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)