Are there any github link for source code? Any there any documents for writing the sproc? What's performance than regular HQL statements? Is there a plan to support spark SQL? will
On Fri, Feb 27, 2015 at 3:36 PM, Dmitry Tolpeko <dmtolp...@gmail.com> wrote: > 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 > -- Thanks, Will
