unix - 从Pig中的元组中提取键值对

Question

我有一个数据如下的文件:

{"PASSWORD_MATCH_RATE":"0.00","PASSWORD_MATCH_COUNT":0,"PASSWORD_INVALIDATE_SUCCESS_COUNT":0,"NOTES":"dfh"}

在一个 pig 脚本中，我想按如下方式转储数据:

PASSWORD_MATCH_RATE,0.00

PASSWORD_MATCH_COUNT,0

PASSWORD_INVALIDATE_SUCCESS_COUNT,0

NOTES,dfh

有人可以提供任何帮助吗？

Answer 1

这将拆分您的输入。你可以试试这个吗？

A = LOAD 'file' using TextLoader() as (line:chararray);
F = FOREACH A GENERATE REPLACE(line,'"','') as (line1:chararray);
F1 = FOREACH F GENERATE FLATTEN(TOKENIZE(line1)) AS (line2:chararray);
F2 = FOREACH F1 GENERATE REPLACE(line2,':',',');