In the Hadoop Definitive Guide it's said that Pig Latin doesn't suit for all data processing task. But It only cites "to perform queries of small amount of data in a large set" as a example.
Which other examples are bad scenarios of use for Pig Latin?