更改pig架构

mwg9r5ms  于 2021-06-21  发布在  Pig
关注(0)|答案(1)|浏览(274)

我正在尝试从以下内容更改架构:

describe JOINED_WITH_PARENT;
JOINED_WITH_PARENT: {ROWS_TUPLES::id: chararray,ROWS_TUPLES::url: chararray,ROWS_TUPLES::score: chararray,ROWS_TUPLES::parentId: chararray,ROWS_TUPLES::title: chararray,ROWS_TUPLES::body: chararray,GROUPED_PARENT_ID::group: chararray,GROUPED_PARENT_ID::ROWS_TUPLES: {(id: chararray,url: chararray,score: chararray,parentId: chararray,title: chararray,body: chararray)}}

收件人:

JOINED_WITH_PARENT: {id: chararray,url: chararray,:score: parentId: chararray,title: chararray,body: chararray,group: chararray, answers: {(id: chararray,url: chararray,score: chararray,parentId: chararray,title: chararray,body: chararray)}}

我正考虑在连接了\u和\u parent的\u上执行foreach,并尝试以下操作,但语法似乎不正确。我走对了吗?任何帮助都将不胜感激

A = FOREACH JOINED_WITH_PARENT GENERATE 
   id as (id:chararray),
   score as (score:chararray),
   parentId as (parentId:chararray),
   title as (title:chararray),
   body as (body:chararray),
   group as (group:chararray),
   answers as tuple(chararray,chararray,chararray,chararray,chararray)GROUPED_PARENT_ID::ROWS_TUPLES;
92dk7w1h

92dk7w1h1#

如果只想投影字段,则不应指定类型,并且在从联接投影时,需要指定“源”关系,如下所示:

A = FOREACH JOINED_WITH_PARENT GENERATE 
   ROWS_TUPLES::id as id,
   ROWS_TUPLES::score as score,
   ...
   GROUPED_PARENT_ID::ROWS_TUPLES as answers;

相关问题