Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Pig >> mail # user >> Inserting date


Copy link to this message
-
Re: Inserting date
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?
>>>>
>>>
>>
>