[
https://issues.apache.org/jira/browse/HIVE-11055?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14641539#comment-14641539
]
wangchangchun commented on HIVE-11055:
--------------------------------------
FOURTH:
Create procedure()
begin
INSERT INTO TMP_EDR_MAX_CONSPT1 SELECT STARTTIME,
SERVICENAME,SUBSCRIBERSN,SUBSCRIBEDATETIME,VALIDFROMDATETIME, EXPIREDATETIME
FROM TDR_PCC_SUBSCRIPTION
end;
FIfth:
create procedure testexception()
begin
DECLARE
booknum int;
total int;
percent int;
SET booknum = 10;
SET total = 0;
SET percent = booknum / total;
EXCEPTION WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('Error');
end;
CALL testexception();
> HPL/SQL - Implementing Procedural SQL in Hive (PL/HQL Contribution)
> -------------------------------------------------------------------
>
> Key: HIVE-11055
> URL: https://issues.apache.org/jira/browse/HIVE-11055
> Project: Hive
> Issue Type: Improvement
> Reporter: Dmitry Tolpeko
> Assignee: Dmitry Tolpeko
> Fix For: 2.0.0
>
> Attachments: HIVE-11055.1.patch, HIVE-11055.2.patch,
> HIVE-11055.3.patch, HIVE-11055.4.patch, hplsql-site.xml
>
>
> There is PL/HQL tool (www.plhql.org) that implements procedural SQL for Hive
> (actually any SQL-on-Hadoop implementation and any JDBC source).
> Alan Gates offered to contribute it to Hive under HPL/SQL name
> (org.apache.hive.hplsql package). This JIRA is to create a patch to
> contribute the PL/HQL code.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
