You are viewing a plain text version of this content. The canonical link for it is here.
Posted to gitbox@hive.apache.org by GitBox <gi...@apache.org> on 2021/04/12 09:45:37 UTC
[GitHub] [hive] zeroflag opened a new pull request #2166: HIVE-24997. HPL/SQL udf doesn't work in tez container mode (amagyar)
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
---------------------------------------------------------------------
To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org
For additional commands, e-mail: gitbox-help@hive.apache.org
[GitHub] [hive] zeroflag commented on pull request #2166: HIVE-24997. HPL/SQL udf doesn't work in tez container mode (amagyar)
Posted by GitBox <gi...@apache.org>.
zeroflag commented on pull request #2166:
URL: https://github.com/apache/hive/pull/2166#issuecomment-818578215
cc: @mustafaiman
--
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
---------------------------------------------------------------------
To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org
For additional commands, e-mail: gitbox-help@hive.apache.org
[GitHub] [hive] mustafaiman commented on pull request #2166: HIVE-24997. HPL/SQL udf doesn't work in tez container mode (amagyar)
Posted by GitBox <gi...@apache.org>.
mustafaiman commented on pull request #2166:
URL: https://github.com/apache/hive/pull/2166#issuecomment-819072149
👍
--
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
---------------------------------------------------------------------
To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org
For additional commands, e-mail: gitbox-help@hive.apache.org
[GitHub] [hive] kasakrisz merged pull request #2166: HIVE-24997. HPL/SQL udf doesn't work in tez container mode (amagyar)
Posted by GitBox <gi...@apache.org>.
kasakrisz merged pull request #2166:
URL: https://github.com/apache/hive/pull/2166
--
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
---------------------------------------------------------------------
To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org
For additional commands, e-mail: gitbox-help@hive.apache.org