[SPARK-29846] PostgreSQL dialect: cast to char

• Type: Sub-task
• Status: Closed
• Priority: Minor
• Resolution: Won't Do
• Affects Version/s: 3.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: jobit mathew
• Created: 11/Nov/19 12:44
• Updated: 29/Mar/20 02:09
• Resolved: 29/Mar/20 02:08

Description

Make SparkSQL's cast to char behavior be consistent with PostgreSQL when

spark.sql.dialect is configured as PostgreSQL.

spark-sql> select cast ('10.2222222222222222222222333333333333333' as char(5));
10.2222222222222222222222333333333333333
Time taken: 0.062 seconds, Fetched 1 row(s)
spark-sql>

postgresql
select cast ('10.2222222222222222222222333333333333333' as char(5));
 

	bpchar
1	10.22

Issue Links

• relates to: SPARK-31147 forbid CHAR type in non-Hive-Serde tables