pig.registerQuery("AP = FILTER A BY emp_state == 'AP';");
pig.registerQuery("STORE TN INTO 'employee' USING org.apache.howl.pig.HowlStorer('emp_country=IN,emp_state=TN');");
pig.registerQuery("STORE KA INTO 'employee' USING org.apache.howl.pig.HowlStorer('emp_country=IN,emp_state=KA');");
pig.registerQuery("STORE KL INTO 'employee' USING org.apache.howl.pig.HowlStorer('emp_country=IN,emp_state=KL');");
pig.registerQuery("STORE AP INTO 'employee' USING org.apache.howl.pig.HowlStorer('emp_country=IN,emp_state=AP');");
pig.executeBatch();
driver.run("select * from employee");
ArrayList<String> results = new ArrayList<String>();
driver.getResults(results);
assertEquals(4, results.size());
Collections.sort(results);