I’ve been doing a lot of prototyping with Hive lately and I really wanted to use an emulator to do the work. For awhile, I was trying to do the prototyping using Powershell but kept getting NotSupported exceptions.
I finally decided to simply program against Hive itself which has turned out to work just great. I’m using Visual Studio to write my HQL as .sql files and getting a nice color coded editing experience, since HQL and SQL are fundamentally the same as far as keywords.
Then, I have a cmd line open with a Hive prompt and I run my HQL queries as follows:
hive> source c:\hdp\temp\test2.sql;
Working great! Fast and free – I like it…