@Test
  public void testDropStoredProc() throws Exception {
    objectStore.createDatabase(new DatabaseBuilder()
            .setName(DB1)
            .setDescription("description")
            .setLocation("locationurl")
            .build(conf));

    StoredProcedure toBeDeleted = new StoredProcedure();
    toBeDeleted.setSource("print 'Hello world'");
    toBeDeleted.setCatName("hive");
    toBeDeleted.setOwnerName("user1");
    toBeDeleted.setName("greetings");
    toBeDeleted.setDbName(DB1);
    objectStore.createOrUpdateStoredProcedure(toBeDeleted);
    Assert.assertNotNull(objectStore.getStoredProcedure("hive", DB1, "greetings"));
    objectStore.dropStoredProcedure("hive", DB1, "greetings");
    Assert.assertNull(objectStore.getStoredProcedure("hive", DB1, "greetings"));
  }
Helper method for setting and checking the SSL configuration parameters.
@param useSSL whether or not SSL is enabled
@param trustStorePath truststore path, corresponding to the value for {@link MetastoreConf.ConfVars#DBACCESS_SSL_TRUSTSTORE_PATH}
@param trustStorePassword truststore password, corresponding to the value for {@link MetastoreConf.ConfVars#DBACCESS_SSL_TRUSTSTORE_PASSWORD}
@param trustStoreType truststore type, corresponding to the value for {@link MetastoreConf.ConfVars#DBACCESS_SSL_TRUSTSTORE_TYPE}
standalone-metastore/metastore-server/src/test/java/org/apache/hadoop/hive/metastore/TestObjectStore.java