Mohit, Is date a field in your dataset, or current date or something else? Few options
1. You could let Database implicitly create a date field if you need the INSERT date 2. As Thejas suggested, simply insert it as '20120322' as date. I don't think DB has any dependency on understanding Pig types. It would be similar to loading a CSV file into a database. Thanks, Prashant On Thu, Mar 22, 2012 at 2:34 PM, Thejas Nair <[email protected]> wrote: > 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? >>>>> >>>>> >>>> >>> >> >
