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

Port test cases from PostgreSQL to Spark SQL

    XMLWordPrintableJSON

    Details

    • Type: Umbrella
    • Status: Resolved
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 3.0.0
    • Fix Version/s: None
    • Component/s: SQL
    • Labels:
      None
    • Target Version/s:

      Description

      To improve the test coverage, we can port the regression tests from the other popular open source projects to Spark SQL. PostgreSQL is one of the best SQL systems. Below are the links to the test cases and results. 

      Spark SQL does not support all the feature sets of PostgreSQL. In the current stage, we should first comment out these test cases and create the corresponding JIRAs in SPARK-27764. We can discuss and prioritize which features we should support. Also, these PostgreSQL regression tests could also expose the existing bugs of Spark SQL. We should also create the JIRAs and track them in SPARK-27764

        Attachments

          Issue Links

          1.
          Add aggregates.sql - Part1 Sub-task Resolved Xiao Li
          2.
          Add aggregates.sql - Part2 Sub-task Resolved Yuming Wang
          3.
          Add aggregates.sql - Part3 Sub-task Resolved Yuming Wang
          4.
          Add aggregates.sql - Part4 Sub-task Resolved Yuming Wang
          5.
          Add boolean.sql Sub-task Resolved Yuming Wang
          6.
          Add case.sql Sub-task Resolved Yuming Wang
          7.
          Add comments.sql Sub-task Resolved Yuming Wang
          8.
          Add date.sql Sub-task Resolved Yuming Wang
          9.
          Port int2.sql Sub-task Resolved Yuming Wang
          10.
          Add int4.sql Sub-task Resolved Yuming Wang
          11.
          Port int8.sql Sub-task Resolved Yuming Wang
          12.
          Port with.sql Sub-task Resolved Peter Toth
          13.
          Add text.sql Sub-task Resolved Yuming Wang
          14.
          Add float4.sql Sub-task Resolved Yuming Wang
          15.
          Add float8.sql Sub-task Resolved Yuming Wang
          16.
          Add strings.sql Sub-task Resolved Yuming Wang
          17.
          Add timestamp.sql Sub-task Resolved Yuming Wang
          18.
          Add numeric.sql Sub-task Resolved Yuming Wang
          19.
          Add join.sql Sub-task Resolved Yuming Wang
          20.
          Port select.sql Sub-task Resolved Yuming Wang
          21.
          PostgreSQL test should change some default config Sub-task Resolved Yuming Wang
          22.
          Port select_distinct.sql Sub-task Resolved Yuming Wang
          23.
          Port select_having.sql Sub-task Resolved Yuming Wang
          24.
          Port select_implicit.sql Sub-task Resolved Yuming Wang
          25.
          Port union.sql Sub-task Resolved Yuming Wang
          26.
          Add window.sql - Part 1 Sub-task Resolved Dylan Guedes
          27.
          Add window.sql - Part 2 Sub-task Resolved Dylan Guedes
          28.
          Add window.sql - Part 3 Sub-task Resolved Dylan Guedes
          29.
          Add window.sql - Part 4 Sub-task Resolved Dylan Guedes
          30.
          Add create_view.sql Sub-task Resolved Takeshi Yamamuro
          31.
          Port interval.sql Sub-task Resolved Maxim Gekk
          32.
          Add limit.sql Sub-task Resolved Takeshi Yamamuro
          33.
          Add groupingsets.sql Sub-task Resolved Takeshi Yamamuro
          34.
          Add insert.sql Sub-task Resolved Takeshi Yamamuro

            Activity

              People

              • Assignee:
                yumwang Yuming Wang
                Reporter:
                smilegator Xiao Li
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: