final PersistenceManager manager = resource.getPersistenceManager();
RegularStatement regularStatement = select().countAll().from("system","schema_keyspaces")
.where(eq("keyspace_name","test_keyspace"));
//When
final Map<String,Object> map = manager.nativeQuery(regularStatement).first();
//Then
assertThat(map.get("count")).isEqualTo(1L);
}