I started using HiveSQL when it used to be SteemSQL, so it would be about 3-4 years. I probably should have clarified that. I just generally like to refer to Hive as a rebranding of Steem and consider it as the original chain. :)
See if this cheatsheet can be helpful.
Posted Using LeoFinance Beta
IMHO, your cheatsheet is not the most helpful to share about HiveSQL because it only allows users to issue SELECT statements.
Any command from the last two columns (except joins) will be rejected.
Yes, you are right. It is not necessarily a cheatsheet for HiveSQL, but SQL in general. I should have mentioned that.
It actually is good idea to create a cheatsheet specific to only HiveSQL that can help new users.
That's a great cheatsheet! Thank you, I'll be downloading that. I found you can also rename the columns after the SELECT command which is really helpful for uploading your csv files to tax/accountancy calculator websites like Koinly should you need to. They only accept certain tables with certain formats but it's been a lifesaver!