@After
  public void tearDown() throws Exception {
    try {
      if (driver != null) {
        dropTable(BASIC_TABLE);
        dropTable(COMPLEX_TABLE);
        dropTable(PARTITIONED_TABLE);
        dropTable(SPECIFIC_SIZE_TABLE);
        dropTable(PARTITIONED_DATE_TABLE);
        dropTable(AllTypesTable.ALL_PRIMITIVE_TYPES_TABLE);
        executeStatementOnDriver("drop database if exists " + SPECIFIC_DATABASE + " cascade",
                driver);
      }
    } finally {
      FileUtils.deleteDirectory(new File(TEST_DATA_DIR));
    }
  }
Execute Hive CLI statement
@param cmd arbitrary statement to execute
hcatalog/hcatalog-pig-adapter/src/test/java/org/apache/hive/hcatalog/pig/AbstractHCatLoaderTest.java