io.prestosql.tests.hive.TestCreateDropSchema Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of presto-product-tests Show documentation

There is a newer version: 350

/*
 * Licensed 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 io.prestosql.tests.hive;

import com.google.inject.Inject;
import com.google.inject.name.Named;
import io.prestosql.tempto.ProductTest;
import io.prestosql.tempto.hadoop.hdfs.HdfsClient;
import org.testng.annotations.Test;

import static io.prestosql.tempto.assertions.QueryAssert.assertThat;
import static io.prestosql.tempto.query.QueryExecutor.query;
import static io.prestosql.tests.utils.QueryExecutors.onHive;
import static io.prestosql.tests.utils.QueryExecutors.onPresto;
import static org.testng.Assert.assertFalse;
import static org.testng.Assert.assertTrue;

public class TestCreateDropSchema
        extends ProductTest
{
    @Inject
    private HdfsClient hdfsClient;

    @javax.inject.Inject
    @Named("databases.hive.warehouse_directory_path")
    private String warehouseDirectory;

    @Test
    public void testCreateDropSchema()
    {
        onHive().executeQuery("DROP DATABASE IF EXISTS test_drop_schema CASCADE");

        onPresto().executeQuery("CREATE SCHEMA test_drop_schema");
        assertTrue(hdfsClient.exist(warehouseDirectory + "/test_drop_schema.db"));

        onPresto().executeQuery("CREATE TABLE test_drop_schema.test_drop (col1 int)");
        assertThat(() -> query("DROP SCHEMA test_drop_schema"))
                .failsWithMessage("Schema not empty: test_drop_schema");

        onPresto().executeQuery("DROP TABLE test_drop_schema.test_drop");

        onPresto().executeQuery("DROP SCHEMA test_drop_schema");
        assertFalse(hdfsClient.exist(warehouseDirectory + "/test_drop_schema.db"));
    }
}