public class TestImplicitSplitOnTuple {
@Test
public void testImplicitSplitterOnTuple() throws IOException {
PigServer pigServer = new PigServer(LOCAL);
Data data = Storage.resetData(pigServer);
data.set("input",
tuple("1", "1001", "101"),
tuple("1", "1002", "103"),
tuple("1", "1003", "102"),
tuple("1", "1004", "102"),
tuple("2", "1005", "101"),
tuple("2", "1003", "101"),
tuple("2", "1002", "123"),
tuple("3", "1042", "101"),
tuple("3", "1005", "101"),
tuple("3", "1002", "133"));
pigServer.registerQuery(
"inp = LOAD 'input' USING mock.Storage() AS (memberId:long, shopId:long, score:int);"+
"tuplified = FOREACH inp GENERATE (memberId, shopId) AS tuplify, score;"+
"D1 = FOREACH tuplified GENERATE tuplify.memberId as memberId, tuplify.shopId as shopId, score AS score;"+
"D2 = FOREACH tuplified GENERATE tuplify.memberId as memberId, tuplify.shopId as shopId, score AS score;"+
"J = JOIN D1 By shopId, D2 by shopId;"+
"K = FOREACH J GENERATE D1::memberId AS member_id1, D2::memberId AS member_id2, D1::shopId as shop;"+
"L = ORDER K by shop;"+
"STORE L into 'output' using mock.Storage;");
List<Tuple> list = data.get("output");
assertEquals("list: "+list, 20, list.size());
assertEquals("(1,1,1001)", list.get(0).toString());
assertEquals("(1,1,1002)", list.get(1).toString());
assertEquals("(1,2,1002)", list.get(2).toString());
assertEquals("(1,3,1002)", list.get(3).toString());