[
https://issues.apache.org/jira/browse/HIVE-28143?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Krisztian Kasa resolved HIVE-28143.
-----------------------------------
Fix Version/s: 4.1.0
Resolution: Fixed
Merged to master. Thanks [~Dayakar] for the patch.
> 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
> Affects Versions: 4.0.0
> Reporter: Dayakar M
> Assignee: Dayakar M
> Priority: Major
> Labels: hive-4.1.0-must, pull-request-available
> Fix For: 4.1.0
>
>
> 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)
