Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-30374 Feature Parity between PostgreSQL and Spark (ANSI/SQL)
  3. SPARK-29587

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

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • 2.4.4
    • 3.0.0
    • SQL
    • None

    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

       

      Attachments

        Activity

          People

            Qin Yao Kent Yao 2
            jobitmathew jobit mathew
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: