pig脚本无法使用amazon emr工作

khbbv19g  于 2021-06-25  发布在  Pig
关注(0)|答案(1)|浏览(349)

我无法使用此脚本:

raw = LOAD 's3://xxxxxxxxx/*' AS (name:chararray, year:float, occurrences:float, books:float);
B = GROUP raw BY name;
C = FOREACH B GENERATE B.name, (SUM(B.occurrences) / SUM(B.books)) AS average;
D = ORDER C BY average DESC;
E = LIMIT D 10;
STORE E INTO 's3://xxxxxx';
jckbn6z7

jckbn6z71#

声明 C 不正确,无法访问变量 name,occurrences and books 使用 Relation B . 只能通过 relation raw . 你能换一下衣服吗 stmt C 像这样的?

C = FOREACH B GENERATE group, SUM(raw.occurrences)/SUM(raw.books) AS average;

在这里 group 参考变量 name 如果您遇到任何其他问题,请粘贴您的错误日志。

相关问题