[jira] [Work logged] (HIVE-24997) HPL/SQL udf doesn't work in tez container mode

["ASF GitHub Bot (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-24997?focusedWorklogId=580850&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-580850 ]

ASF GitHub Bot logged work on HIVE-24997:
-----------------------------------------

                Author: ASF GitHub Bot
            Created on: 12/Apr/21 09:45
            Start Date: 12/Apr/21 09:45
    Worklog Time Spent: 10m 
      Work Description: zeroflag opened a new pull request #2166:
URL: https://github.com/apache/hive/pull/2166


   HPLSQL supports stored function calls from HiveQL selects:
   
   For example:
   
   ```
   create function hello(s string) returns string;
   begin
     return 'hello ' || s;
   end;
   ```
   
   The above stored function can be used in a select:
   
   ```
   select hello(name) from employees;
   ```
   
   HPLSQL translates this to a UDF call.
   
   ```
   SELECT hplsql('hello(:1)', name) FROM users;
   ```
   
   The hplsql UDF is going to call the hplsql interpreter to evaluate the hello function. The earlier implementation used to look up the interpreter from the session state. But this only works if the evaluation happens in compile time and the UDF is running inside the HS2 process. This is not true for general therefore the UDF should instantiate a new interpreter and use that to eval the function call.


-- 
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: 580850)
    Remaining Estimate: 0h
            Time Spent: 10m

> HPL/SQL udf doesn't work in tez container mode
> ----------------------------------------------
>
>                 Key: HIVE-24997
>                 URL: https://issues.apache.org/jira/browse/HIVE-24997
>             Project: Hive
>          Issue Type: Sub-task
>          Components: hpl/sql
>    Affects Versions: 4.0.0
>            Reporter: Attila Magyar
>            Assignee: Attila Magyar
>            Priority: Major
>             Fix For: 4.0.0
>
>          Time Spent: 10m
>  Remaining Estimate: 0h
>
> Since  HIVE-24230  it assumes the UDF is evaluated on HS2 which is not true in general. The SessionState is only available at compile time evaluation but later on a new interpreter should be instantiated.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)