Cat Miller from Mortar Data offers a quick intro to Pig Latin from a SQLish perspective:
Pig is similar enough to SQL to be familiar, but divergent enough to be
disorienting to newcomers. The goal of this guide is to ease the friction in
adding Pig to an existing SQL skillset.
Pig and SQL similarities are in the operations they both support. But the whole model is different. Pig is an imperative data manipulation tool, while SQL is a declarative query language.
Original title and link: A Brief Guide to Pig Latin for the SQL Guy ( ©myNoSQL)