Mailing-List: contact dev-help@datafu.incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@datafu.incubator.apache.org
Content-Type: multipart/alternative;
 boundary="===============8887062010539807118=="
MIME-Version: 1.0
Subject: Re: Review Request 25564: DATAFU-69: Create SelectFieldByName UDF -
 which, given a field who's value contains a field name, and *,
 returns the value of the field referenced by the field name
From: "Russell Jurney" <russell.jurney@gmail.com>
To: "Jonathan Coveney" <jcoveney@gmail.com>,
 "Jakob Homan" <jghoman@apache.org>,
 "Sam Shah" <shahsam@umich.edu>,
 "Matthew Hayes" <matthew.terence.hayes@gmail.com>
Cc: "DataFu" <dev@datafu.incubator.apache.org>,
 "Russell Jurney" <russell.jurney@gmail.com>
Date: Tue, 28 Oct 2014 19:28:01 -0000
Message-ID: <20141028192801.7137.55705@reviews.apache.org>
Auto-Submitted: auto-generated
Sender: "Russell Jurney" <noreply@reviews.apache.org>
References: <20141002161926.19041.5125@reviews.apache.org>
In-Reply-To: <20141002161926.19041.5125@reviews.apache.org>
Reply-To: "Russell Jurney" <russell.jurney@gmail.com>

--===============8887062010539807118==
MIME-Version: 1.0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 7bit


-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/25564/
-----------------------------------------------------------

(Updated Oct. 28, 2014, 7:28 p.m.)


Review request for DataFu, Jonathan Coveney, Jakob Homan, Matthew Hayes, and Sam Shah.


Changes
-------

Updated patch with new name, SelectStringFieldByName


Repository: datafu


Description
-------

Example use:
group_fields = LOAD '/e8/smalldata/group_fields.txt' AS (groupField:chararray); 
with_group = CROSS group_fields, hour_rounded;
with_group = FOREACH with_group GENERATE group_fields::groupField AS groupField, 
hour_rounded::sourceNameOrIp AS sourceNameOrIp,
hour_rounded::destinationNameOrIp AS destinationNameOrIp,
...;
with_value_substitution = FOREACH with_group GENERATE ChooseFieldByValue(groupField, *) AS groupValue:tuple(value:chararray), *;
with_value_substitution = FOREACH with_value_substitution GENERATE 
FLATTEN(groupValue) AS groupValue:chararray,
groupField,
foo,
bar,
...;
all_success = FOREACH (GROUP with_value_substitution BY (groupField, groupValue, day)) GENERATE
FLATTEN(group) AS (seriesType, groupValue, day),
(int)COUNT_STAR(with_value_substitution) AS connections:int;


Diffs (updated)
-----

  datafu-pig/src/main/java/datafu/pig/util/SelectStringFieldByName.java PRE-CREATION 
  datafu-pig/src/test/java/datafu/test/pig/util/SelectStringFieldByNameTest.java PRE-CREATION 

Diff: https://reviews.apache.org/r/25564/diff/


Testing
-------

This UDF was used to replace a very inefficient pig script where macros that did many individual GROUP BY's took many minutes to plan.

Testing: unit tests and used on real data on a cluster.


Thanks,

Russell Jurney


--===============8887062010539807118==--