Hadoop PIG Helper GROUP error

2013-06-20T20:23:39

I am using Hortonworks Sandbox 1.2 and I am pretty new to Hadoop platform.

So here is the error, while I was following the tutorial included by sandbox. In the PIG section, I inserted GROUP code by using PIG Helper. It inserts a code like

GROUP %VAR% BY %VAR%

And my code seems like this after I complete tutorial.

a = LOAD 'nyse_stocks' USING org.apache.hcatalog.pig.HCatLoader();
b = FILTER a BY stock_symbol == 'IBM';
c = GROUP b BY all;
d = FOREACH c GENERATE AVG(b.stock_volume);
DUMP d;

It gives error below :

[main] ERROR org.apache.pig.tools.grunt.Grunt - ERROR 1200: mismatched input ';' expecting LEFT_PAREN

I do everything like it is told in tutorial. So where's the error?

EDIT : I added the PIG logs below.

2013-06-24 04:56:16,869 [main] INFO org.apache.pig.Main - Apache Pig version 0.10.1.21 (rexported) compiled Dec 24 2012, 03:01:24
2013-06-24 04:56:16,870 [main] INFO org.apache.pig.Main - Logging error messages to: /hadoop/mapred/taskTracker/sandbox/jobcache/job_201306240450_0001/attempt_201306240450_0001_m_000000_0/work/pig_1372064176867.log
2013-06-24 04:56:20,224 [main] INFO org.apache.pig.backend.hadoop.executionengine.HExecutionEngine - Connecting to hadoop file system at: hdfs://sandbox:8020
2013-06-24 04:56:22,862 [main] INFO org.apache.pig.backend.hadoop.executionengine.HExecutionEngine - Connecting to map-reduce job tracker at: sandbox:50300
2013-06-24 04:56:25,672 [main] WARN org.apache.hadoop.hive.conf.HiveConf - DEPRECATED: Configuration property hive.metastore.local no longer has any effect. Make sure to provide a valid value for hive.metastore.uris if you are connecting to a remote metastore.
2013-06-24 04:56:25,959 [main] INFO hive.metastore - Trying to connect to metastore with URI thrift://sandbox:9083
2013-06-24 04:56:27,956 [main] INFO hive.metastore - Waiting 1 seconds before next connection attempt.
2013-06-24 04:56:28,957 [main] INFO hive.metastore - Connected to metastore.
2013-06-24 04:56:30,552 [main] ERROR org.apache.pig.tools.grunt.Grunt - ERROR 1200: mismatched input ';' expecting LEFT_PAREN
Details at logfile: /hadoop/mapred/taskTracker/sandbox/jobcache/job_201306240450_0001/attempt_201306240450_0001_m_000000

Copyright License:
Author:「Canburak Tümer」,Reproduced under the CC 4.0 BY-SA copyright license with link to original source & disclaimer.
Link to:https://stackoverflow.com/questions/17213576/hadoop-pig-helper-group-error

About “Hadoop PIG Helper GROUP error” questions

I am using Hortonworks Sandbox 1.2 and I am pretty new to Hadoop platform. So here is the error, while I was following the tutorial included by sandbox. In the PIG section, I inserted GROUP code by
I am an absolute beginner in Hadoop, and I am only doing some simple testing, however, I do not find error messages very informative. I have set up my Hadoop environment in a single-node mode on a
I am getting ConnectionRefused error when I am running pig in mapreduce mode. Details: I have installed Pig from tarball( pig-0.14), and exported the classpath in bashrc. I have all the Hadoop (...
Using Pig 0.10.1, I have the following script: br = LOAD 'cfs:///somefile'; SPLIT br INTO s0 IF (sp == 1), not_s0 OTHERWISE; SPLIT not_s0 INTO s1 IF (adp >= 1.0), not_s1 OTHERWISE; SPLIT not_s...
I have data that looks like this STN--- WBAN YEARMODA TEMP DEWP SLP STP VISIB WDSP MXSPD GUST MAX MIN PRCP SNDP FRSHTT 030050 99999 19291029 ...
Whenever i run any apache pig code from the terminal everythig goes well and i get the result. So i conclude that my installation for Pig 0.15.0 and Hadoop 2.7.0 is alright. The problem is when i r...
I have been trying to execute the following command in grunt ...........................................................................................................................................
I have a pig script I got from Hortonworks that works fine with pig-0.9.2.15 with Hadoop-1.0.3.16. But when I run it with pig-0.12.1(recompiled with -Dhadoopversion=23) or pig-0.13.0 on Hadoop-2.4....
I have installed oozie on my system and I have also installed pig. Now I want ozzie to run workflow from pig which is installed on my system not from the ozzie sharelib. Please help, as I get ...
Using Hadoop's PIG-Latin to find the number of occurrences of unique search strings from a search engine log file.(click here to view the sample log file) Please help me out. Thanks in advance. Pig

Copyright License:Reproduced under the CC 4.0 BY-SA copyright license with link to original source & disclaimer.