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