>Are there any github link for source code? Will be added soon >Any there any documents for writing the sproc? Please see the reference at plhql.org. Briefly, just put your code without enclosing CREATE PROC/FUNC statements (they will be supported soon)
>What's performance than regular HQL statements? It is comparable as the tool holds Hive JDBC connection and just submits queries (but faster comparing with lauching hive from bash for each query) >Is there a plan to support spark SQL? Now you can use any SQL-on-Hadoop configuring a proper JDBC connection. Dmitry On Sat, Feb 28, 2015 at 3:45 AM, DU DU <will...@gmail.com> wrote: > 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 >
