Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-28143

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

    XMLWordPrintableJSON

Details

    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

          Activity

            People

              Dayakar Dayakar M
              Dayakar Dayakar M
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated: