Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-27764 Feature Parity between PostgreSQL and Spark
  3. SPARK-28033

String concatenation should low priority than other operators

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Won't Fix
    • 2.3.3
    • None
    • SQL
    • None

    Description

      Spark SQL:

      spark-sql> explain select 'four: ' || 2 + 2;
      == Physical Plan ==
      *(1) Project [null AS (CAST(concat(four: , CAST(2 AS STRING)) AS DOUBLE) + CAST(2 AS DOUBLE))#2]
      +- Scan OneRowRelation[]
      spark-sql> select 'four: ' || 2 + 2;
      NULL
      

      Hive:

      hive> select 'four: ' || 2 + 2;
      OK
      four: 4
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              yumwang Yuming Wang
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: