ABHISHEK KUMAR GUPTA created SPARK-29847:
--------------------------------------------
Summary: PostgreSQL dialect: cast to varchar
Key: SPARK-29847
URL: https://issues.apache.org/jira/browse/SPARK-29847
Project: Spark
Issue Type: Sub-task
Components: SQL
Affects Versions: 3.0.0
Reporter: ABHISHEK KUMAR GUPTA
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*
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]