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

DEFAULT option is not supported in Spark

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Duplicate
    • 3.0.0
    • None
    • SQL
    • None

    Description

      PostgreSQL supports default option as below

      **CREATE TABLE update_test (
      a INT DEFAULT 10,
      b INT
      );
      INSERT INTO update_test VALUES (5, 10);
      INSERT INTO update_test(b) VALUES (15);
      SELECT * FROM update_test;

      Attachments

        Issue Links

          is duplicated by

          Sub-task - The sub-task of the issue SPARK-27953 Save default constraint with Column into table properties when create Hive table

          • Major - Major loss of function.
          • Resolved
          relates to

          Improvement - An improvement or enhancement to an existing feature or task. SPARK-19842 Informational Referential Integrity Constraints Support in Spark

          • Major - Major loss of function.
          • Open

          Activity

            People

              Unassigned Unassigned
              abhishek.akg ABHISHEK KUMAR GUPTA
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: