I am just curious why would you want to do that. Because you can use the nulls from pig in the same way as empty values. At the end, if you output them back, you won't get null values, you would get empty values only. You can test this by doing a dump/STORE on the EMPTY relation.
Regards Prav On Thu, Feb 27, 2014 at 1:08 PM, Arpit Maheshwari < [email protected]> wrote: > Hi All, > > I am trying to create an alias in pig, which should read records from a csv > file which contains some empty records. But Pig is treating those empty > values(separated by commas) as NULL values. I used the same comma separated > empty values to load data into hive tables where it loads them as empty > values and not NULL. > > > > Code: > > EMPTY = LOAD 'empty.csv' using PigStorage(',') AS (trn_id:chararray, > trn_date_purchase:chararray, trn_customer_name:chararray, > cc_type:chararray); > > empty.csv has a single record which is given below: > > ,,,test > > > > Could you please suggest how should I insert the empty values into the pig > alias. > > -- > > *Warm Regards,* > > *-Arpit Maheshwari* >
