Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-13076 Implement FK/PK "rely novalidate" constraints for better CBO
  3. HIVE-13350

Support Alter commands for Rely/NoRely novalidate for PK/FK constraints

    XMLWordPrintableJSON

Details

    Description

      Support commands like :
      ALTER TABLE table2 ADD CONSTRAINT pkt2 primary key (a) disable novalidate;
      ALTER TABLE table3 ADD CONSTRAINT fk1 FOREIGN KEY ( x ) REFERENCES table2(a) DISABLE NOVALIDATE RELY;
      ALTER TABLE table6 ADD CONSTRAINT fk4 FOREIGN KEY ( y ) REFERENCES table1(a) DISABLE NOVALIDATE;

      Attachments

        1. HIVE-13350.1.patch
          1.19 MB
          Hari Sankar Sivarama Subramaniyan
        2. HIVE-13350.2.patch
          1.21 MB
          Hari Sankar Sivarama Subramaniyan
        3. HIVE-13350.final.patch
          1.21 MB
          Hari Sankar Sivarama Subramaniyan

        Issue Links

          Activity

            People

              hsubramaniyan Hari Sankar Sivarama Subramaniyan
              hsubramaniyan Hari Sankar Sivarama Subramaniyan
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: