| // Licensed to the Apache Software Foundation (ASF) under one |
| // or more contributor license agreements. See the NOTICE file |
| // distributed with this work for additional information |
| // regarding copyright ownership. The ASF licenses this file |
| // to you under the Apache License, Version 2.0 (the |
| // "License"); you may not use this file except in compliance |
| // with the License. You may obtain a copy of the License at |
| // |
| // http://www.apache.org/licenses/LICENSE-2.0 |
| // |
| // Unless required by applicable law or agreed to in writing, |
| // software distributed under the License is distributed on an |
| // "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| // KIND, either express or implied. See the License for the |
| // specific language governing permissions and limitations |
| // under the License. |
| |
| package org.apache.doris.catalog; |
| |
| import org.apache.doris.analysis.AlterTableStmt; |
| import org.apache.doris.analysis.CreateDbStmt; |
| import org.apache.doris.analysis.CreateTableStmt; |
| import org.apache.doris.analysis.RecoverPartitionStmt; |
| import org.apache.doris.common.DdlException; |
| import org.apache.doris.common.ExceptionChecker; |
| import org.apache.doris.qe.ConnectContext; |
| import org.apache.doris.utframe.UtFrameUtils; |
| |
| import org.junit.AfterClass; |
| import org.junit.Assert; |
| import org.junit.BeforeClass; |
| import org.junit.Test; |
| |
| import java.io.File; |
| import java.util.List; |
| import java.util.UUID; |
| |
| public class DropPartitionTest { |
| private static String runningDir = "fe/mocked/DropPartitionTest/" + UUID.randomUUID().toString() + "/"; |
| |
| private static ConnectContext connectContext; |
| |
| @BeforeClass |
| public static void beforeClass() throws Exception { |
| UtFrameUtils.createMinDorisCluster(runningDir); |
| |
| // create connect context |
| connectContext = UtFrameUtils.createDefaultCtx(); |
| // create database |
| String createDbStmtStr = "create database test;"; |
| String createTablleStr = "create table test.tbl1(d1 date, k1 int, k2 bigint) duplicate key(d1, k1) " |
| + "PARTITION BY RANGE(d1) (PARTITION p20210201 VALUES [('2021-02-01'), ('2021-02-02'))," |
| + "PARTITION p20210202 VALUES [('2021-02-02'), ('2021-02-03'))," |
| + "PARTITION p20210203 VALUES [('2021-02-03'), ('2021-02-04'))) distributed by hash(k1) " |
| + "buckets 1 properties('replication_num' = '1');"; |
| createDb(createDbStmtStr); |
| createTable(createTablleStr); |
| } |
| |
| @AfterClass |
| public static void tearDown() { |
| File file = new File(runningDir); |
| file.delete(); |
| } |
| |
| private static void createDb(String sql) throws Exception { |
| CreateDbStmt createDbStmt = (CreateDbStmt) UtFrameUtils.parseAndAnalyzeStmt(sql, connectContext); |
| Catalog.getCurrentCatalog().createDb(createDbStmt); |
| } |
| |
| private static void createTable(String sql) throws Exception { |
| CreateTableStmt createTableStmt = (CreateTableStmt) UtFrameUtils.parseAndAnalyzeStmt(sql, connectContext); |
| Catalog.getCurrentCatalog().createTable(createTableStmt); |
| } |
| |
| private static void dropPartition(String sql) throws Exception { |
| AlterTableStmt alterTableStmt = (AlterTableStmt) UtFrameUtils.parseAndAnalyzeStmt(sql, connectContext); |
| Catalog.getCurrentCatalog().alterTable(alterTableStmt); |
| } |
| |
| @Test |
| public void testNormalDropPartition() throws Exception { |
| Database db = Catalog.getCurrentCatalog().getDb("default_cluster:test"); |
| OlapTable table = (OlapTable) db.getTable("tbl1"); |
| Partition partition = table.getPartition("p20210201"); |
| long tabletId = partition.getBaseIndex().getTablets().get(0).getId(); |
| String dropPartitionSql = " alter table test.tbl1 drop partition p20210201;"; |
| dropPartition(dropPartitionSql); |
| List<Replica> replicaList = Catalog.getCurrentCatalog().getTabletInvertedIndex().getReplicasByTabletId(tabletId); |
| partition = table.getPartition("p20210201"); |
| Assert.assertEquals(1, replicaList.size()); |
| Assert.assertNull(partition); |
| String recoverPartitionSql = "recover partition p20210201 from test.tbl1"; |
| RecoverPartitionStmt recoverPartitionStmt = (RecoverPartitionStmt) UtFrameUtils.parseAndAnalyzeStmt(recoverPartitionSql, connectContext); |
| Catalog.getCurrentCatalog().recoverPartition(recoverPartitionStmt); |
| partition = table.getPartition("p20210201"); |
| Assert.assertNotNull(partition); |
| Assert.assertEquals("p20210201", partition.getName()); |
| } |
| |
| @Test |
| public void testForceDropPartition() throws Exception { |
| Database db = Catalog.getCurrentCatalog().getDb("default_cluster:test"); |
| OlapTable table = (OlapTable) db.getTable("tbl1"); |
| Partition partition = table.getPartition("p20210202"); |
| long tabletId = partition.getBaseIndex().getTablets().get(0).getId(); |
| String dropPartitionSql = " alter table test.tbl1 drop partition p20210202 force;"; |
| dropPartition(dropPartitionSql); |
| List<Replica> replicaList = Catalog.getCurrentCatalog().getTabletInvertedIndex().getReplicasByTabletId(tabletId); |
| partition = table.getPartition("p20210202"); |
| Assert.assertTrue(replicaList.isEmpty()); |
| Assert.assertNull(partition); |
| String recoverPartitionSql = "recover partition p20210202 from test.tbl1"; |
| RecoverPartitionStmt recoverPartitionStmt = (RecoverPartitionStmt) UtFrameUtils.parseAndAnalyzeStmt(recoverPartitionSql, connectContext); |
| ExceptionChecker.expectThrowsWithMsg(DdlException.class, |
| "No partition named p20210202 in table tbl1", |
| () -> Catalog.getCurrentCatalog().recoverPartition(recoverPartitionStmt)); |
| } |
| |
| @Test |
| public void testDropPartitionAndReserveTablets() throws Exception { |
| Database db = Catalog.getCurrentCatalog().getDb("default_cluster:test"); |
| OlapTable table = (OlapTable) db.getTable("tbl1"); |
| Partition partition = table.getPartition("p20210203"); |
| long tabletId = partition.getBaseIndex().getTablets().get(0).getId(); |
| table.dropPartitionAndReserveTablet("p20210203"); |
| List<Replica> replicaList = Catalog.getCurrentCatalog().getTabletInvertedIndex().getReplicasByTabletId(tabletId); |
| partition = table.getPartition("p20210203"); |
| Assert.assertEquals(1, replicaList.size()); |
| Assert.assertNull(partition); |
| } |
| } |