Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-33507 Improve and fix cache behavior in v1 and v2
  3. SPARK-33950

ALTER TABLE .. DROP PARTITION doesn't refresh cache

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 3.0.1, 3.1.0, 3.2.0
    • 3.0.2, 3.1.0, 3.2.0
    • SQL

    Description

      Here is the example to reproduce the issue:

      spark-sql> CREATE TABLE tbl1 (col0 int, part0 int) USING parquet PARTITIONED BY (part0);
      spark-sql> INSERT INTO tbl1 PARTITION (part0=0) SELECT 0;
      spark-sql> INSERT INTO tbl1 PARTITION (part0=1) SELECT 1;
      spark-sql> CACHE TABLE tbl1;
      spark-sql> SELECT * FROM tbl1;
      0	0
      1	1
      spark-sql> ALTER TABLE tbl1 DROP PARTITION (part0=0);
      spark-sql> SELECT * FROM tbl1;
      0	0
      1	1
      

       

      Attachments

        Issue Links

          Activity

            People

              maxgekk Max Gekk
              maxgekk Max Gekk
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: