Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
4.0.0
-
None
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.
Attachments
Issue Links
- links to