Pig: mismatched input '.' expecting RIGHT_PAREN

[sammsundar4905]

Hi,

Please provide solution for the below issue while am trying to find the average value of a data set.

//loading data

mydata = LOAD '/user/sammsundar4905/datasets/hly175.csv' using PigStorage(',') AS (obsdate:chararray, rain:double, temper:double, wetb:double, dewpt: double, vapp:double, rhum:double, msl:double);

//average

agtemp = AVG(mydata.temper) as avr;

getting the below error:

> [main] ERROR org.apache.pig.tools.grunt.Grunt - ERROR 1200: <line 2, column 19> mismatched input '.' expecting RIGHT_PAREN