Let me introduce PL/HQL, an open source tool that implements procedural SQL on Hadoop. It is going to support all major procedural syntaxes. The tool can be used with any SQL-on-Hadoop solution.
Motivation: - Writing the driver code using well-known procedural SQL (not bash) that enables Hadoop to even more wider audience - Allowing dynamic SQL, iterations, flow-of-control and SQL exception handling - Facilitating migration of RDBMS workload to Hadoop Plans (besides extending syntax): - Supporting CREATE PROCEDURE/FUNCTION/PACKAGE to reuse code - Allowing connections to multiple databases (i.e. lookup tables in relational databases) - On-the-fly SQL conversion (SELECT i.e.), compatibility layers More details can be found at http://www.plhql.org/ It is just the first release PL/HQL 0.01 to show that such project exists and get any initial feedback. Thank you, Dmitry Tolpeko
