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

["Dayakar Morem (Jira)" <ji...@apache.org>]

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)