How to "update" a column using pig latin

apache-pig, hadoop

Solution

This issue is tracked in this JIRA: PIG-1693 There needs to be a way in foreach to indicate "and all the rest of the fields"

Currently I don't know anything simpler than doing what you say or not loading Z and adding a new column Z with the star expression.

Problem

Imagine I have the following table available to me: ``` A: { x: int, y: int, z: int, ...99 other columns... } ``` I now want to transform this, such that `z` is set to `NULL` where `x > y`, with the resulting dataset to be stored as `B`. and I want to do it without having to explicitly mention all the other columns, as this becomes a maintenance nightmare. Is there a simple solution?

Original source