String table1="join1";
String tblpay = "{\"name\":\"join1\",\"columns\":\"username,friends,wall,status\",\"primarykey\":\"username\",\"storage\":\"unit.cassandra\"}";
String db = "jointest";
JsonObject pload = new JsonObject(tblpay);
pload.putString("db", db);
try {
metasvc.writeMetaEntity(EntityType.TABLE, pload.toString());
} catch (StorageDoesNotExistException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
String insertPay = "{\"columns\":\"username,friends,wall,status\",\"values\":\"'rogerfederer','rafa#haas#tommy#sachin#beckham','getting ready for my next#out of wimbledon#out of french','looking fwd to my next match'\"}";
datasvc.writeRow(db, "join1", new JsonObject(insertPay));
String table2="join2";
tblpay = "{\"name\":\"join2\",\"columns\":\"username,first,last,lastlogin,paid,address,email\",\"primarykey\":\"username\",\"storage\":\"unit.mysql\"}";
pload = new JsonObject(tblpay);
pload.putString("db", db);
try {
metasvc.writeMetaEntity(EntityType.TABLE, pload.toString());
} catch (StorageDoesNotExistException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
String str = datasvc.doJoin(db, table1, table2, "username", "rogerfederer");