hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "r7raul1984@163.com" <r7raul1...@163.com>
Subject Re: PL/HQL - Procedural SQL-on-Hadoop
Date Fri, 06 Mar 2015 08:27:17 GMT
I type plhql --version  ....   but meet error bash: /usr/plhql/plhql: /bin/bash^M: bad interpreter:
No such file or directory 



r7raul1984@163.com
 
From: Dmitry Tolpeko
Date: 2015-02-28 04:36
To: user
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
Mime
View raw message