[SPARK-29847] PostgreSQL dialect: cast to varchar

• Type: Sub-task
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 3.1.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: ABHISHEK KUMAR GUPTA
• Created: 11/Nov/19 12:51
• Updated: 29/Mar/20 02:07

Description

In Spark

jdbc:hive2://10.18.19.208:23040/default> select cast('10.345bbbbbb' as varchar(10));
-------------------------------

CAST(10.345bbbbbb AS STRING)

-------------------------------

10.345*bbbbbb*

-------------------------------

 

In PostgreSQL

select cast('10.345bbbbbb' as varchar(10));

   varchar   varchar1 10.345bbbb