I thought you knew SQL for a long time but that's cool you learned from Hive too! I only had a teeny bit of experience with it before Hive and it works in a similar way to excel in terms of the logic in macros. For me, it's just knowing what all the different terms are like SELECT and UNION etc.
I can't remember if you shared with me a post that had the different terms used. I have saved the queries I use in the free SQL software I found but I had a lot of help in setting them up.
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!