g1 = LOAD 'data/grptest' USING PigStorage(',') AS ( a, b , c, d);
r = FOREACH g1 GENERATE
'$myconstant' as constant,
a
;
when called like this:
pig [-x local] -param myconstant=zz <script name>
the output looks like this:
(zz,3)
(zz,5)
(zz,2)
(zz,7)...
On Wed, Oct 20, 2010 at 1:00 PM, John Hui wrote:
Hi,
I have this pig script.
1 data = LOAD '$INPUT' USING PigStorage(',') AS (app:chararray,
user:chararray , timestamp:int, duration:int);
2
3 appUserIn = FOREACH data GENERATE app, user;
5 distinctAppUserIn = DISTINCT appUserIn;
6
7 groupOnApp = GROUP distinctAppUserIn BY app;
8
9 result = FOREACH groupOnApp GENERATE group, COUNT(distinctAppUserIn);
10
11 STORE result INTO '$OUTPUT' USING PigStorage();
I would like to add a constant to the output such a a timestamp pass into
the pig script. So idealy I could do FOREACH groupOnApp GENERATE group,
COUNT(distinctAppUserIn), *'time_constant'*;
Is this possible in Pig?
thanks,
John
--
Konstantin Ignatyev
PS: If this is a typical day on planet earth, humans will add fifteen
million tons of carbon to the atmosphere, destroy 115 square miles of
tropical rainforest, create seventy-two miles of desert, eliminate between
forty to one hundred species, erode seventy-one million tons of topsoil, add
2,700 tons of CFCs to the stratosphere, and increase their population by
263,000
Bowers, C.A. The Culture of Denial: Why the Environmental Movement Needs a
Strategy for Reforming Universities and Public Schools. New York: State
University of New York Press, 1997: (4) (5) (p.206)
