[HIVE-26768] HPLSQL UDF is not working if it is applied on a column of type varchar/char/decimal in a table.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0
• Component/s: Hive
• Labels: pull-request-available
• Assignee: Dayakar M
• Reporter: Dayakar M
• Created: 22/Nov/22 18:16
• Updated: 02/Dec/22 17:57
• Resolved: 29/Nov/22 05:13

Description

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

For example:

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; 

 

--> It should return below

+----------------+
|      _c0       |
+----------------+
| Hello, alice  |
| Hello, bob  |
+----------------+

 

But actual result is 

+----------------+
|      _c0       |
+----------------+
| Hello,   |
| Hello,   |
+----------------+

 

Issue Links

• links to: GitHub Pull Request #3808