[jira] [Created] (HIVE-28143) After HIVE-27492 fix, some HPLSQL built-in functions like trim, lower are not working when used in insert statement.

[Dayakar M (Jira)]

Dayakar M created HIVE-28143:
--------------------------------

             Summary: After HIVE-27492 fix, some HPLSQL built-in functions like 
trim, lower are not working when used in insert statement.
                 Key: HIVE-28143
                 URL: https://issues.apache.org/jira/browse/HIVE-28143
             Project: Hive
          Issue Type: Bug
          Components: hpl/sql
            Reporter: Dayakar M
            Assignee: Dayakar M


After HIVE-27492 fix, some HPLSQL built-in functions like trim, lower are not 
working when used in insert statement.

Steps to reproduce:
{noformat}
CREATE TABLE result (name String);

CREATE PROCEDURE p1(s1 string)
  BEGIN\n" +
    INSERT INTO result VALUES(lower(s1));
  END;

call p1('abcd');
SELECT * FROM result;{noformat}
Error reported:
{noformat}
ERROR : Ln:3 identifier 'LOWER' must be declared.{noformat}
 



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