Hi everyone, PL/HQL 0.3.1 released today. There are some features I hope you find interesting:
1) Stored procedures and SQL user-defined functions CREATE PROCEDURE and CREATE FUNCTION statements are supported so you can define procedures and functions in your scripts, and when added to .plhqlrc they can look as real stored objects. 2) Calling PL/HQL functions from Hive queries You can use PL/HQL functions in Hive queries. PL/HQL automatically puts function definitions to distributed cache, registers Hive UDF and executes functions. You can also call PL/HQL functions from Hive CLI if you manually register UDF and execute ADD FILE for PL/HQL scripts. See, http://plhql.org/udf 3) Multiple connections You can work with multiple databases from a single PL/HQL script. For example, run queries in Hive, but lookup and log to RDBMS. MAP OBJECT statement allows you to assign a table to a connection (again you can do that in plhqlrc). Then PL/HQL will automatically use appropriate connection. In the next releases, procedural features will be extended to cover more existing dialects, on-the-fly SQL conversion will be improved. Also federation features will be added - like saving query results to RDBMS (actually any JDBC source), use RDBMS tables as map-join tables in Hive queries and so on. Early adopters are very welcome. Please contact me at dmtolp...@gmail.com Thanks, Dmitry Tolpeko PL/HQL - Procedural SQL-on-Hadoop, www.plhql.org On Fri, Mar 6, 2015 at 6:23 PM, Ronak Bhatt <ronakb...@gmail.com> wrote: > plhql is a great initiative and will certainly help with more adoption of > the eco-system...Good job Dimtry > > -r > > *-r* > > > > > On Fri, Mar 6, 2015 at 1:07 AM, Dmitry Tolpeko <dmtolp...@gmail.com> > wrote: > >> run dos2unix for plhql file. Sorry for this issue, it will be fixed. >> >> Dmitry >> >> On Fri, Mar 6, 2015 at 11:27 AM, r7raul1...@163.com <r7raul1...@163.com> >> wrote: >> >>> I type plhql --version .... but meet error bash: /usr/plhql/plhql: >>> /bin/bash^M: bad interpreter: No such file or directory >>> >>> ------------------------------ >>> r7raul1...@163.com >>> >>> >>> *From:* Dmitry Tolpeko <dmtolp...@gmail.com> >>> *Date:* 2015-02-28 04:36 >>> *To:* user <user@hive.apache.org> >>> *Subject:* PL/HQL - Procedural SQL-on-Hadoop >>> 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 >>> >>> >> >
