@Test
public void testDelete() throws Exception {
SecondaryIndexDao d = new SecondaryIndexDao(getDataSource(getConnectString(getHiveDatabaseName())));
int initialSize = d.loadAll().size();
int id = d.create(createSecondaryIndex());
assertEquals(initialSize+1,d.loadAll().size());
SecondaryIndex s = createSecondaryIndex(id);
s.setResource(createResource());
d.delete(s);
assertEquals(initialSize,d.loadAll().size());
}