fix unit tests
added partial select test
clean up
remove yaml file for cassandra unit