A guide is better than no guide. I like the part about adding suffix strings to variables. Two things I would changes
* Add commas before the variable * Do not use single letters for aliases. Some versions of hive will throw exceptions. Plus seeing tables a, b, c, d joined together is annoying to read.