Dayakar Morem created HIVE-26768:
------------------------------------
Summary: 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
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}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
