Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-30374

Feature Parity between PostgreSQL and Spark (ANSI/SQL)

    XMLWordPrintableJSON

    Details

    • Type: Umbrella
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 3.0.0
    • Fix Version/s: None
    • Component/s: SQL
    • Labels:
      None

      Description

      Among the feature parity between Spark/PostgreSQL (SPARK-27764), this umbrella holds issues for the ANSI/SQL standard.

        Attachments

          Issue Links

          1.
          Support ANSI SQL Boolean-Predicate syntax Sub-task Resolved jiaan.geng
          2.
          ANSI SQL: NTH_VALUE function Sub-task In Progress Unassigned
          3.
          ANSI SQL: LATERAL derived table(T491) Sub-task Closed Unassigned
          4.
          ANSI SQL: Character literals Sub-task Resolved Unassigned
          5.
          ANSI SQL: OVERLAY function(T312) Sub-task Resolved jiaan.geng
          6.
          Support ANSI SQL: LIKE ... ESCAPE syntax Sub-task Resolved jiaan.geng
          7.
          ANSI-F053: Overlaps datetimes predicate support Sub-task Open Unassigned
          8.
          Support ANSI SQL CREATE SEQUENCE Sub-task Open Unassigned
          9.
          Forbid reserved keywords as identifiers when ANSI mode is on Sub-task Resolved Takeshi Yamamuro
          10.
          ANSI SQL: Recursive query Sub-task In Progress Unassigned
          11.
          Support LOCALTIMESTAMP when ANSI mode enabled Sub-task Resolved Unassigned
          12.
          Support CURRENT_TIME and LOCALTIME when ANSI mode enabled Sub-task Resolved Unassigned
          13.
          Test both ANSI mode and Spark mode Sub-task Open Unassigned
          14.
          ANSI SQL: Nested bracketed comments Sub-task Resolved jiaan.geng
          15.
          ANSI SQL: delete and update does not support in Spark Sub-task Resolved Unassigned
          16.
          ANSI SQL: Collation Support Sub-task Open Unassigned
          17.
          ANSI SQL: unique predicate Sub-task Open Unassigned
          18.
          ANSI SQL: OVERLAY function support byte array(T312) Sub-task Resolved jiaan.geng
          19.
          ANSI SQL(E021-05): OCTET_LENGTH function Sub-task Resolved Unassigned
          20.
          Support ANSI SQL:SIMILAR TO ... ESCAPE syntax Sub-task In Progress Unassigned
          21.
          ANSI SQL: Unicode escapes in literals Sub-task Open Unassigned
          22.
          Support ANSI SQL:member predicate Sub-task Open Unassigned
          23.
          ANSI SQL: Top-level <result offset clause> in <query expression> Sub-task In Progress Unassigned
          24.
          Support Aggregate Expressions with filter Sub-task Resolved jiaan.geng
          25.
          define reserved keywords after SQL standard Sub-task Resolved Takeshi Yamamuro
          26.
          Support Filter expression allows simultaneous use of DISTINCT Sub-task Resolved jiaan.geng
          27.
          Support Filter expression uses IN/EXISTS predicate sub-queries Sub-task Open Unassigned
          28.
          Support Filter expression reference the outer query Sub-task Open Unassigned
          29.
          Support dec as shorthand for decimal Sub-task Resolved Kent Yao
          30.
          SELECT INTO syntax Sub-task Open Unassigned
          31.
          adds support for `filter` clause Sub-task Resolved Unassigned
          32.
          Support WITH clause in subqueries Sub-task Resolved Peter Toth
          33.
          DIV support decimal type Sub-task Resolved Marco Gaido
          34.
          Fully support correlation names in the FROM clause Sub-task Open Unassigned
          35.
          Real data type is not supported in Spark SQL which is supporting in postgresql Sub-task Resolved Kent Yao
          36.
          Throw exception on overflow for integers Sub-task Resolved Marco Gaido
          37.
          The exact math method should be called only when there is a corresponding function in Math Sub-task Resolved Gengliang Wang
          38.
          Support option to throw exception if overflow occurs during Decimal arithmetic Sub-task Resolved Marco Gaido
          39.
          Spark should support select <columnname> into <table> from <table> where <condition> as PostgreSQL supports Sub-task Resolved Unassigned
          40.
          When one or more DISTINCT aggregate expressions operate on the same field, the DISTINCT aggregate expression allows the use of the FILTER clause Sub-task Resolved Unassigned
          41.
          When there are multiple DISTINCT aggregate expressions acting on different fields, any DISTINCT aggregate expression allows the use of the FILTER clause Sub-task Resolved Unassigned
          42.
          [SQL] ANSI SQL: Throw exception on format invalid and overflow when casting String to IntegerType. Sub-task Resolved Unassigned
          43.
          Lead/Lag window function throws AnalysisException without ORDER BY clause Sub-task In Progress Unassigned
          44.
          first_value/last_value window function throws ParseException Sub-task Resolved Unassigned
          45.
          ANSI SQL: FIRST_VALUE function Sub-task Closed Unassigned
          46.
          ANSI SQL: LAST_VALUE function Sub-task Closed Unassigned
          47.
          AnalysisException that window RangeFrame not match RowFrame Sub-task Open Unassigned
          48.
          Spark SQL can't display bracketed comments well in generated golden files Sub-task Resolved jiaan.geng
          49.
          Support IGNORE | RESPECT) NULLS for LEAD/LAG/NTH_VALUE/FIRST_VALUE/LAST_VALUE Sub-task Open Unassigned
          50.
          Add documents information for window function. Sub-task Resolved jiaan.geng
          51.
          Support grant/revoke access privileges like postgresql Sub-task Open Unassigned
          52.
          Eliminate distinct that with filter clause Sub-task Open Unassigned

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                maropu Takeshi Yamamuro
              • Votes:
                1 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated: