From issues-return-199798-archive-asf-public=cust-asf.ponee.io@hive.apache.org Fri Oct 2 14:52:02 2020 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mailroute1-lw-us.apache.org (mailroute1-lw-us.apache.org [207.244.88.153]) by mx-eu-01.ponee.io (Postfix) with ESMTPS id 94A59180630 for ; Fri, 2 Oct 2020 16:52:02 +0200 (CEST) Received: from mail.apache.org (localhost [127.0.0.1]) by mailroute1-lw-us.apache.org (ASF Mail Server at mailroute1-lw-us.apache.org) with SMTP id C6D12123996 for ; Fri, 2 Oct 2020 14:52:01 +0000 (UTC) Received: (qmail 392 invoked by uid 500); 2 Oct 2020 14:52:01 -0000 Mailing-List: contact issues-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hive.apache.org Delivered-To: mailing list issues@hive.apache.org Received: (qmail 372 invoked by uid 99); 2 Oct 2020 14:52:01 -0000 Received: from mailrelay1-us-west.apache.org (HELO mailrelay1-us-west.apache.org) (209.188.14.139) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 02 Oct 2020 14:52:01 +0000 Received: from jira-he-de.apache.org (static.172.67.40.188.clients.your-server.de [188.40.67.172]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id 90975408BC for ; Fri, 2 Oct 2020 14:52:00 +0000 (UTC) Received: from jira-he-de.apache.org (localhost.localdomain [127.0.0.1]) by jira-he-de.apache.org (ASF Mail Server at jira-he-de.apache.org) with ESMTP id 149EF780222 for ; Fri, 2 Oct 2020 14:52:00 +0000 (UTC) Date: Fri, 2 Oct 2020 14:52:00 +0000 (UTC) From: "ASF GitHub Bot (Jira)" To: issues@hive.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Work logged] (HIVE-24217) HMS storage backend for HPL/SQL stored procedures MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/HIVE-24217?focusedWorklogId=3D= 493978&page=3Dcom.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpa= nel#worklog-493978 ] ASF GitHub Bot logged work on HIVE-24217: ----------------------------------------- Author: ASF GitHub Bot Created on: 02/Oct/20 14:51 Start Date: 02/Oct/20 14:51 Worklog Time Spent: 10m=20 Work Description: zeroflag commented on a change in pull request #154= 2: URL: https://github.com/apache/hive/pull/1542#discussion_r498868959 ########## File path: standalone-metastore/metastore-common/src/main/thrift/hive_metas= tore.thrift ########## @@ -2830,6 +2848,11 @@ PartitionsResponse get_partitions_req(1:PartitionsRe= quest req) void add_replication_metrics(1: ReplicationMetricList replicationMetricL= ist) throws(1:MetaException o1) ReplicationMetricList get_replication_metrics(1: GetReplicationMetricsRe= quest rqst) throws(1:MetaException o1) GetOpenTxnsResponse get_open_txns_req(1: GetOpenTxnsRequest getOpenTxnsR= equest) + + void create_stored_procedure(1: string catName, 2: StoredProcedure proc)= throws(1:NoSuchObjectException o1, 2:MetaException o2) + StoredProcedure get_stored_procedure(1: string catName, 2: string db, 3:= string name) throws (1:MetaException o1, 2:NoSuchObjectException o2) + void drop_stored_procedure(1: string catName, 2: string dbName, 3: strin= g funcName) throws (1:MetaException o1, 2:NoSuchObjectException o2) + list get_all_stored_procedures(1: string catName) throw= s (1:MetaException o1) Review comment: You mean putting (1: string catName, 2: string dbName, 3: string fun= cName) into a request object? I can do that. But if we have only one parame= ter, like in the last case that would be an overkill in my opinion. ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: users@infra.apache.org Issue Time Tracking ------------------- Worklog Id: (was: 493978) Time Spent: 1h (was: 50m) > HMS storage backend for HPL/SQL stored procedures > ------------------------------------------------- > > Key: HIVE-24217 > URL: https://issues.apache.org/jira/browse/HIVE-24217 > Project: Hive > Issue Type: Bug > Components: Hive, hpl/sql, Metastore > Reporter: Attila Magyar > Assignee: Attila Magyar > Priority: Major > Labels: pull-request-available > Attachments: HPL_SQL storedproc HMS storage.pdf > > Time Spent: 1h > Remaining Estimate: 0h > > HPL/SQL procedures are currently stored in text files. The goal of this J= ira is to implement a Metastore backend for storing and loading these proce= dures. This is an incremental step towards having fully capable stored proc= edures in Hive. > =C2=A0 > See the attached design for more information. -- This message was sent by Atlassian Jira (v8.3.4#803005)