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

ALTER TABLE .. RENAME TO PARTITION doesn't refresh cache

    XMLWordPrintableJSON

    Details

    • Type: Sub-task
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.0.1, 3.1.0, 3.2.0
    • Fix Version/s: 3.0.2, 3.1.1, 3.2.0
    • Component/s: SQL
    • Labels:

      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 PARTITION (part0 = 0) RENAME TO PARTITION (part0 = 2);
      spark-sql> SELECT * FROM tbl1;
      0	0
      1	1
      

       

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                maxgekk Max Gekk
                Reporter:
                maxgekk Max Gekk
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: