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

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.1.0, 4.0.1
• Component/s: hpl/sql
• Labels: hive-4.0.1-merged hive-4.0.1-must pull-request-available
• Target Version/s: 4.1.0
• Assignee: Dayakar M
• Reporter: Dayakar M
• Created: 21/Mar/24 13:29
• Updated: 24/Sep/24 02:15
• Resolved: 01/Aug/24 11:45

Description

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

Steps to reproduce:

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;

Error reported:

ERROR : Ln:3 identifier 'LOWER' must be declared.

 

Issue Links

• links to: GitHub Pull Request #5182