Handing nullls as alias at pig level

kumarvaibhav199 — Wed, 25 Jan 2017 15:43:30 GMT

Hi All,

I have my table structure and in hive like below .

Create table hv (x int,y int,z int ,w int )

PIGLATIN used to load the table

A = LOAD 'XYZ.CSV.GZ' using pigstorage AS (x,y,w)

this time Z col is missing from the file so i wan to keep the value of z as null in PIGLATIN and i donot want to change my hive table structure .How to generate the values as null for this column in pig??

Re: Handing nullls as alias at pig level

eberezitsky — Thu, 26 Jan 2017 22:38:25 GMT

Hi @Vaibhav Kumar,

If you want to create a bag matching target table's structure, you can do as following:

a = load 'file.csv' as PigStorage(',') as (x,y,w);
b = foreach a generate x, y, (int)null as z, w;
describe b;
--    b: {x: int,y: int,z: int,w: int}

question Re: Handing nullls as alias at pig level in Archives of Support Questions (Read Only)

Handing nullls as alias at pig level

Re: Handing nullls as alias at pig level