I got this from Carlos Guestrin. Hadoop Mortar is an interesting software as service framework which allows running python and pig scripts on top of Hadoop:
It has a very nice "Illustrate" functionality which helps debug the code even before it is actually executed. Reminds a little the functionality of data wrangler.
Some cons: you have to know SQL/Pig. So in that sense the UI does not simplify Pig programming. Some queries preview make take the same time of executing the full query and thus you do not always gain much from the preview.