You can refer to the cursor columns using cur_name.col_name syntax
Great job!
r7raul1...@163.com
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
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
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 wrote:
> run dos2unix for plhql file. Sorry for this issue, it will be fixed.
>
> Dmitry
>
> On Fri, Mar 6, 2015 at 11:27 AM, r7r
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
wrote:
> I type plhql --version but meet error bash: /usr/plhql/plhql:
> /bin/bash^M: bad interpreter: No such file or directory
>
> --
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
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 i
Venkat,
The goal of this project is to execute existing PL/SQL in Hive as much as
possible, not to migrate. In case when some design restrictions are faced
the code has to be redesigned, but hopefully most of the remaining code
remained untouched, no need to convert everything to bash/Python etc.
Is there a simple way to migrate from PL/SQL to PL/HQL?
Regards,
Venkat
From: Dmitry Tolpeko [mailto:dmtolp...@gmail.com]
Sent: Friday, February 27, 2015 1:36 PM
To: user@hive.apache.org
Subject: PL/HQL - Procedural SQL-on-Hadoop
Let me introduce PL/HQL, an open source tool that implements proce
>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 statem
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 wrote:
> Let me introduce PL/HQL, an open source tool that implemen
