在Pig中处理NULL值有几种方法:
A = LOAD 'data' AS (col1: int, col2: chararray);
B = FOREACH A GENERATE COALESCE(col1, -1) AS col1, COALESCE(col2, 'N/A') AS col2;
A = LOAD 'data' AS (col1: int, col2: chararray);
B = FILTER A BY NOT IsEmpty(col1) AND NOT IsEmpty(col2);
A = LOAD 'data' AS (col1: int, col2: chararray);
B = FOREACH A GENERATE (col1 IS NULL ? -1 : col1) AS col1, (col2 IS NULL ? 'N/A' : col2) AS col2;
这些方法可以根据具体情况选择合适的处理方式来处理NULL值。
亿速云「云服务器」,即开即用、新一代英特尔至强铂金CPU、三副本存储NVMe SSD云盘,价格低至29元/月。点击查看>>
推荐阅读:SQLServer中怎么处理NULL值