pig:output 1列

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

假设我有一个数据文件:

abc,def,ghi
jkl,mno,pqr
stu,vwx,yz

我怎样才能只输出一列,这样就可以得到下面的结果?

abc
jkl
stu

这是我的主意:

A = load 'data'  AS (c1,c2,c3);
dump A.c1

我得到这个错误:

2014-12-06 17:14:19,424 [main] ERROR org.apache.pig.tools.grunt.Grunt - ERROR 1000: Error during parsing. Encountered " <PATH> "data.c1 "" at line 2, column 6.
Was expecting one of:
    <EOF> 
    "cat" ...
    "clear" ...
    "fs" ...
    "sh" ...
    "cd" ...
    "cp" ...
    "copyFromLocal" ...
mum43rcc

mum43rcc1#

你能这样试试吗?

A = LOAD 'data' USING PigStorage(',') AS (c1,c2,c3);
B = FOREACH A GENERATE c1;
DUMP B;

输出:

(abc)
(jkl)
(stu)

相关问题