pgHIVE is both a dream AND a reality… The current iteration of the project is a complex beast written in Python that is rather hard to deal with in a developers bundle and/or installer.

My friend Joey Terrano is architecting the next generation that is a C based PostgreSQL Foreign Data Wrapper that uses JNI to interface with the HIVE JDBC driver. This has the promise of robust simplicity. We’d love to hear more from the real JT.