Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Handing nullls as alias at pig level

Solved Go to solution
Highlighted

Handing nullls as alias at pig level

Rising Star

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??

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Handing nullls as alias at pig level

Expert Contributor

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}

View solution in original post

1 REPLY 1
Highlighted

Re: Handing nullls as alias at pig level

Expert Contributor

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}

View solution in original post

Don't have an account?
Coming from Hortonworks? Activate your account here