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*
