如何将两组元组提取到一个变量中

Question

我需要将LOG_COUNT1和LOG_COUNT2提取到一组结构为police_force, date, crime_count的两条记录中

joined_tbl: {group: chararray,LOG_COUNT1: {(police_force: chararray,date: chararray,crime_count: long)},LOG_COUNT2: {(police_force: chararray,date: chararray,crime_count: long)}}

Answer 1

Try，

F1 = FOREACH joined_tbl GENERATE group, FLATTEN(LOG_COUNT1) ;
F2 = FOREACH joined_tbl GENERATE group, FLATTEN(LOG_COUNT2) ;
U = UNION F1, F2 ;
# merged_tbl = FOREACH (GROUP U BY group) GENERATE group AS group, U.(police_force, date, crime_count) AS LOG_COUNT;
DUMP U;