What are the limitations of pig?
Ans.1. When something goes wrong, it just gives execution error in udf, it does not show the type of error like syntax error or type error, logical error.
Atleast a developer should get the different types of error when developer has a syntax error.
2.The commands are not executed unless either you dump or store an intermediate or final result. This increases the iteration between debug and resolving the issue.
3. low latncy query are not supportable in pig. this is not suitable for oltp and olap.
4. If we want to do random writes to update small portion of data, we can not use pig.