[jira] [Created] (SPARK-29587) Real data type is not supported in Spark SQL which is supporting in postgresql

["jobit mathew (Jira)" <ji...@apache.org>]

jobit mathew created SPARK-29587:
------------------------------------

             Summary: Real data type is not supported in Spark SQL which is supporting in postgresql
                 Key: SPARK-29587
                 URL: https://issues.apache.org/jira/browse/SPARK-29587
             Project: Spark
          Issue Type: Sub-task
          Components: SQL
    Affects Versions: 2.4.4
            Reporter: jobit mathew


Real data type is not supported in Spark SQL which is supporting in postgresql.

+*In postgresql query success*+

CREATE TABLE weather2(prcp real);

insert into weather2 values(2.5);
select * from weather2;
 
||  ||prcp||
|1|2,5|

+*In spark sql getting error*+

spark-sql> CREATE TABLE weather2(prcp real);
Error in query:
DataType real is not supported.(line 1, pos 27)

== SQL ==
CREATE TABLE weather2(prcp real)
---------------------------

Better to add the datatype "real " support in sql also

 



--
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