-- load system table from a single dataset
sys = load 'datasets="mocca 01f4f7bfadd9ee5ab2568d73ee7b9dda" tables="system"' using BeansTable();
-- generate only the needed columns for this test
sys = foreach sys generate DSID(tbid) as dsid,
							DSPARAMSTRING(DSID(tbid), 'moccaid') as moccaid,
                            tphys;
-- store the data
store sys into 'name="test_data_for_join_01f4f7bfadd9ee5ab2568d73ee7b9dda"' using BeansTable();