lifehack – My IT Cheat Code

HDInsight – Allow other user to see full entry on TEZ View

Ambari -> YARN -> Advanced -> yarn.admin.aclAdd the user

Open/Explore/Export ORC file

Cheat Codebigdata-file-viewer Today I need to explore some of the ORC file that has been loaded by someone to datalake. I can do my usual stun by creating external table on Hive and run my checking. So I was googling around and managed to reach to this tool. And I love it!Downloaded the latest releasedContinue reading “Open/Explore/Export ORC file”

DBeaver – Use Space instead of TAB

Cheat CodeWindows -> Preferences -> General -> Editors -> Text Editor -> Insert spaces for tabs Your welcome!I’ve been pulling my hair lately because when I try to get view definitions of our hive views, the definition is screwed. Some part of the view definition are truncated.Apparently if you have more than 1 level indentContinue reading “DBeaver – Use Space instead of TAB”

DBeaver – Hive connection keep disconnecting

Cheat CodeSET Keep-Alive settings to 60 seconds I love DBeaver! It’s a GUI tool to run queries and connect to various databases. One of the reasons I really like this tool is because they can auto discover driver required to connect to our databases (Hive, SQL, Drill, yada yada.. you name it!) and download itContinue reading “DBeaver – Hive connection keep disconnecting”

Want to take screenshot and auto save it to disk so you don’t miss it?

Cheat CodeGreenshot! I need to take screenshit… I mean Screenshot, and alot of them for whatever reason I can think of.Been using Windows buildin tool Snipping Tool, it’s super convenient to use it. My muscle memory on hands know it best (Windows Key + “SN”) then KACHA! Screenshot taken.The problem is, i need to pasteContinue reading “Want to take screenshot and auto save it to disk so you don’t miss it?”

Send money overseas with cheaper fees!

Cheat CodeTransferwise.com Just another non IT cheat here… I’ve been sending money to support my family member and over years I’ve tried various remittance services. From super bloody fee sucking banking backed service, to super annoying P2P transfer. It revolves around either reliable but super expensive fees with bad exchange rate, on the extreme endContinue reading “Send money overseas with cheaper fees!”