Is this what you are looking for ? -
A = LOAD '$in' USING PigStorage('\t') AS (...
B = foreach A generate *, '20120322' as date;
STORE B into ...
Thanks,
Thejas
On 3/22/12 1:13 PM, Mohit Anchlia wrote:
Yes that's exactly what I am asking. Reading from flat file and then
inserting it into the database. And I want to insert date before storing.
for eg I want to add date before A gets stored:
A = LOAD '$in' USING PigStorage('\t') AS (...
STORE A into ...
On Thu, Mar 22, 2012 at 12:54 PM, Jonathan Coveney<[email protected]>wrote:
Do you mean you're reading a relation from Hadoop, and want to append the
date to the row before inserting it? I'm not quite sure what you're asking
for.
2012/3/22 Mohit Anchlia<[email protected]>
Sorry I mean to ask if there is any way to insert date into the ALIAS so
that I can use it before storing it into DB.
On Thu, Mar 22, 2012 at 12:47 PM, Mohit Anchlia<[email protected]
wrote:
I am reading bunch of columns from a flat file and inserting it into
the
database. Is there a way to also insert date?
