You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@spark.apache.org by "ABHISHEK KUMAR GUPTA (Jira)" <ji...@apache.org> on 2019/11/11 12:52:00 UTC

[jira] [Created] (SPARK-29847) PostgreSQL dialect: cast to varchar

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: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org