Check this, FIELDS TERMINATED BY ';' ... View more

Its better to make use of UDFs in this condition. Check the below link, it has a UDF for the same, http://stackoverflow.com/questions/12959001/how-to-filter-records-with-a-null-value-in-pig Hope this helps. Regards, Arun ... View more

@Rohini G For a fresher, it is better to start with video tutorials. Many videos related to Big data and Haddop are available on youtube. ... View more

Hello Everyone, Sharing few of the useful links which i came across, http://hortonworks.com/hadoop-tutorial/how-to-use-basic-pig-commands/ http://events.linuxfoundation.org/sites/events/files/slides/Pig_for_DataScience_0.pdf https://books.google.co.in/books?id=w7LjCwAAQBAJ&pg=PA94&lpg=PA94&dq=learning+pig+UDF&source=bl&ots=WQ-Ud3PHTS&sig=qHEW9cXQzwUDLdoxeaYBX28sT7c&hl=en&sa=X&ved=0ahUKEwj8qYy9_sLPAhUBtJQKHRaxAPk4RhDoAQhHMAc#v=onepage&q=learning%20pig%20UDF&f=false https://www.pluralsight.com/courses/pig-latin-getting-started http://chimera.labs.oreilly.com/books/1234000001811/ch05.html#registering_udfs http://archive.cloudera.com/cdh/2/pig/udf.pdf thanks @Michael Young @Mahesh Mallikarjunappa ... View more

@Viraj Vekaria It's better you go for single node vm if you are just looking for learning purpose . Check the links below, http://hortonworks.com/downloads/#data-platform http://www.cloudera.com/downloads.html ... View more

@Rushikesh Deshmukh Flatten un-nests tuples as well as bags. consider a relation that has a tuple of the form (a, (b, c)). The expression GENERATE $0, flatten($1), will cause that tuple to become (a, b, c). You can refer to the below link to know more and have better understanding of other operators, just in case if you need them. https://www.qubole.com/resources/cheatsheet/pig-function-cheat-sheet/ ... View more

@Mahesh Mallikarjunappa Thanks for your suggestions. I am going through data available online. Soon will consolidate useful links and post it here. ... View more

@Michael Young Thanks for the quick reply. I am using Java based UDFs for Pig. I have already gone through few of the links shared by you. Mortardata examples looks interesting, will look into them. Thanks for your support.. ... View more