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

["Krisztian Kasa (Jira)" <ji...@apache.org>]

     [ 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)