hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "" <>
Subject Re: Re: PL/HQL - Procedural SQL-on-Hadoop
Date Tue, 26 May 2015 09:33:20 GMT
You can refer to the cursor columns using cur_name.col_name syntax

Great job!
From: Dmitry Tolpeko
Date: 2015-05-01 03:43
To: user
Subject: Re: PL/HQL - Procedural SQL-on-Hadoop
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.

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


Dmitry Tolpeko
PL/HQL - Procedural SQL-on-Hadoop,

On Fri, Mar 6, 2015 at 6:23 PM, Ronak Bhatt <> wrote:
plhql is a great initiative and will certainly help with more adoption of the eco-system...Good
job Dimtry



On Fri, Mar 6, 2015 at 1:07 AM, Dmitry Tolpeko <> wrote:
run dos2unix for plhql file. Sorry for this issue, it will be fixed.


On Fri, Mar 6, 2015 at 11:27 AM, <> wrote:
I type plhql --version  ....   but meet error bash: /usr/plhql/plhql: /bin/bash^M: bad interpreter:
No such file or directory
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

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):

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

It is just the first release PL/HQL 0.01 to show that such project exists and get any initial

Thank you,

Dmitry Tolpeko

View raw message