have to write some pig script
I'm very familiar to Pig script, currently using Pig for my statistic calculating. Installed many VMs for testing such as: Cloudera, Oracle BigDataLite, HortonWorks.
I'm an experienced Big Data dev and I've worked on Hadoop MapReduce, Hive, Pig before. Just let me know the schema of your dataset and transformation you wish to do on the data.