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

HPL/SQL requires single quotes for string literals, resulting in surprising behavior

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Patch Available
    • Priority: Critical
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: hpl/sql
    • Labels:
      None

      Description

      This bug is part of a series of issues and surprising behavior I encountered writing a reporting script that would aggregate values and give rows different classifications based on an the aggregate. Addressing some or all of these issues would make HPL/SQL more accessible to newcomers.

      Consider this script:

      CREATE FUNCTION test1()
        RETURNS STRING
      DECLARE
        VAR ret string;
      BEGIN
        ret := 'VALUE IS SET';
        print(ret);
      END;
      
      CREATE FUNCTION test2()
        RETURNS STRING
      DECLARE
        VAR ret string;
      BEGIN
        ret := "VALUE IS SET";
        print(ret);
      END;
      
      test1();
      test2();
      

      The output of this script is:
      VALUE IS SET
      ret

      Hive accepts both quoting styles. It would be better if HPL/SQL did as well, or threw an error for th
      e unsupported style.

      Version = 3.0.0-SNAPSHOT r71f52d8ad512904b3f2c4f04fe39a33f2834f1f2

        Attachments

        1. HIVE-17027.1.patch
          3 kB
          Dmitry Tolpeko

          Activity

            People

            • Assignee:
              dmtolpeko Dmitry Tolpeko
              Reporter:
              cartershanklin Carter Shanklin
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated: