- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Handing nullls as alias at pig level
- Labels:
-
Apache Hadoop
-
Apache Hive
-
Apache Pig
Created ‎01-25-2017 07:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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??
Created ‎01-26-2017 02:38 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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}
Created ‎01-26-2017 02:38 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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}
