hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From DU DU <will...@gmail.com>
Subject Re: PL/HQL - Procedural SQL-on-Hadoop
Date Sat, 28 Feb 2015 00:45:09 GMT
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 <dmtolpeko@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

Mime
View raw message