hadoop - PIG:错误1200:<第15行，第66列>输入的 '=='输入不匹配，预期为RIGHT

Question

执行测试语句时出现错误

F = foreach D generate flatten(group),SUM(r1.description == 'COLLECTION' ? r1.scoring : null),SUM(r1.lookup_descrition== 'Probability' ? r1.scoring: null);

错误讯息

2017-01-13 09:12:42,368 [main] ERROR org.apache.pig.tools.grunt.Grunt - ERROR 1200: <line 15, column 66>  mismatched input '==' expecting RIGHT_PAREN

Answer 1

缺少空格r1.lookup_descrition==

F = foreach D generate flatten(group),
          SUM(r1.description == 'COLLECTION' ? r1.scoring : null),
          SUM(r1.lookup_descrition == 'Probability' ? r1.scoring : null);