Inzynierka_Gwiazdy/pig_scripts/system_table/generate_columns_whole_mocca.pig

12 lines
451 B
Pig
Raw Permalink Normal View History

sys = load 'datasets="mocca " tables="system"' using BeansTable();
sys = foreach sys generate DSID(tbid) as dsid,
DSPARAMSTRING(DSID(tbid), 'moccaid') as moccaid,
tphys,
smt,
r1,
rcob,
rchut2,
rhob,
vc;
store sys into 'name="sys_all_datasets_data"' using BeansTable();