You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Dayakar Morem (Jira)" <ji...@apache.org> on 2022/11/22 18:32:00 UTC
[jira] [Updated] (HIVE-26768) HPLSQL UDF is not working if it is applied on a column of type varchar/char/decimal in a table.

     [ https://issues.apache.org/jira/browse/HIVE-26768?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dayakar Morem updated HIVE-26768:
---------------------------------
    Description: 
HPLSQL UDF is not working if it is applied on a column of type varchar/char/decimal in a table.

For example:

 
{code:java}
CREATE TABLE result (s varchar(20));
INSERT INTO result VALUES('alice');
INSERT INTO result VALUES('bob');
CREATE FUNCTION hello(p string)
 RETURNS STRING
BEGIN
 RETURN 'hello ' || p;
END;

SELECT hello(s) FROM result; {code}
 

--> It should return below

 
{code:java}
+----------------+
|      _c0       |
+----------------+
| Hello, Alice  |
| Hello, Smith  |
+----------------+
{code}
 

But actual result is 

 
{code:java}
+----------------+
|      _c0       |
+----------------+
| Hello,  |
| Hello,  |
+----------------+
{code}
 

  was:
HPLSQL UDF is not working if it is applied on a column of type varchar/char/decimal in a table.

For example:

 
{code:java}
CREATE TABLE result (s varchar(20));
INSERT INTO result VALUES('alice');
INSERT INTO result VALUES('bob');
CREATE FUNCTION hello(p char(10)) RETURNS STRING BEGIN RETURN 'hello ' || p; END;
SELECT hello(s) FROM result;
{code}
 

--> It should return below

 
{code:java}
+----------------+
|      _c0       |
+----------------+
| Hello, Alice  |
| Hello, Smith  |
+----------------+
{code}
 

But actual result is 

 
{code:java}
+----------------+
|      _c0       |
+----------------+
| Hello,  |
| Hello,  |
+----------------+
{code}
 


> HPLSQL UDF is not working if it is applied on a column of type varchar/char/decimal in a table.
> -----------------------------------------------------------------------------------------------
>
>                 Key: HIVE-26768
>                 URL: https://issues.apache.org/jira/browse/HIVE-26768
>             Project: Hive
>          Issue Type: Bug
>          Components: Hive
>            Reporter: Dayakar Morem
>            Assignee: Dayakar Morem
>            Priority: Major
>
> HPLSQL UDF is not working if it is applied on a column of type varchar/char/decimal in a table.
> For example:
>  
> {code:java}
> CREATE TABLE result (s varchar(20));
> INSERT INTO result VALUES('alice');
> INSERT INTO result VALUES('bob');
> CREATE FUNCTION hello(p string)
>  RETURNS STRING
> BEGIN
>  RETURN 'hello ' || p;
> END;
> SELECT hello(s) FROM result; {code}
>  
> --> It should return below
>  
> {code:java}
> +----------------+
> |      _c0       |
> +----------------+
> | Hello, Alice  |
> | Hello, Smith  |
> +----------------+
> {code}
>  
> But actual result is 
>  
> {code:java}
> +----------------+
> |      _c0       |
> +----------------+
> | Hello,  |
> | Hello,  |
> +----------------+
> {code}
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)