@Test(expected = NoSuchObjectException.class)
  public void testDropTableNoSuchTable() throws Exception {
    Table table = testTables[2];

    client.dropTable(table.getDbName(), "no_such_table", true, false);
  }
This test creates and queries a table and then drops it. Good for testing the happy path
standalone-metastore/metastore-server/src/test/java/org/apache/hadoop/hive/metastore/client/TestTablesCreateDropAlterTruncate.java