hadoop Apache Pig问题-在此之前使用订单限制数据不起作用

idv4meu8  于 2023-03-01  发布在  Hadoop
关注(0)|答案(1)|浏览(119)

我有一个问题。当我加载输入数据,然后我计算数据,排序数据的名称,然后我试图得到前3个数据,但有一些问题。这里是日志文件转储数据;

(Tainan,57)
(Taipei,121)
(Hsinchu,53)
(Hualien,44)
(Taitung,50)
(Taoyuan,72)
(Pingtung,59)
(Taichung,63)
(Kaohsiung,89)

然后按$1描述使用订单数据:

(Taipei,121)
(Kaohsiung,89)
(Taoyuan,72)
(Taichung,63)
(Pingtung,59)
(Tainan,57)
(Hsinchu,53)
(Taitung,50)
(Hualien,44)

但当我尝试使用命令时:数据=限值数据3;扔掉它,它有问题.

HadoopVersion   PigVersion  UserId  StartedAt   FinishedAt  Features
3.2.2   0.17.0  hadoop  2021-05-05 19:49:54 2021-05-05 19:49:55 GROUP_BY,ORDER_BY,LIMIT

Some jobs have failed! Stop running all dependent jobs

Job Stats (time in seconds):
JobId   Maps    Reduces MaxMapTime  MinMapTime  AvgMapTime  MedianMapTime   MaxReduceTime   MinReduceTime   AvgReduceTimMedianReducetime    Alias   Feature Outputs
job_local586139516_0006 1   1   n/a n/a n/a n/a n/a n/a n/a n/a q11 SAMPLER 
job_local708055803_0005 1   1   n/a n/a n/a n/a n/a n/a n/a n/a a,c0,l,q10  GROUP_BY    

Failed Jobs:
JobId   Alias   Feature Message Outputs
job_local1801700609_0007    q11 ORDER_BY,COMBINER   Message: Job failed!    

Input(s):
Successfully read 608 records from: "file:///home/hadoop/mid/profile.txt"

Output(s):

Counters:
Total records written : 0
Total bytes written : 0
Spillable Memory Manager spill count : 0
Total bags proactively spilled: 0
Total records proactively spilled: 0

Job DAG:
job_local708055803_0005 ->  job_local586139516_0006,
job_local586139516_0006 ->  job_local1801700609_0007,
job_local1801700609_0007    ->  null,
null

2021-05-05 19:49:55,716 [main] WARN  org.apache.hadoop.metrics2.impl.MetricsSystemImpl - JobTracker metrics system already initialized!
2021-05-05 19:49:55,718 [main] WARN  org.apache.hadoop.metrics2.impl.MetricsSystemImpl - JobTracker metrics system already initialized!
2021-05-05 19:49:55,720 [main] WARN  org.apache.hadoop.metrics2.impl.MetricsSystemImpl - JobTracker metrics system already initialized!
2021-05-05 19:49:55,736 [main] WARN  org.apache.hadoop.metrics2.impl.MetricsSystemImpl - JobTracker metrics system already initialized!
2021-05-05 19:49:55,745 [main] WARN  org.apache.hadoop.metrics2.impl.MetricsSystemImpl - JobTracker metrics system already initialized!
2021-05-05 19:49:55,749 [main] WARN  org.apache.hadoop.metrics2.impl.MetricsSystemImpl - JobTracker metrics system already initialized!
2021-05-05 19:49:55,755 [main] INFO  org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.MapReduceLauncher - Some jobs have failed! Stop running all dependent jobs
2021-05-05 19:49:55,758 [main] ERROR org.apache.pig.tools.grunt.Grunt - ERROR 1066: Unable to open iterator for alias q12
Details at logfile: /home/hadoop/mid/pig_1620215111006.log
daupos2t

daupos2t1#

我刚刚解决了这个问题,遇到这个问题的人只要把自己的java版本改成java8就可以了,如果你的java版本太高,比如java11,就会出现这个错误。

相关问题