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

Casting strings to integers in HPL/SQL differs from Hive behavior

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Patch Available
    • Priority: Major
    • 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.

      In HPL/SQL: cast('10.0' as integer); results in:
      Unhandled exception in HPL/SQL
      java.lang.NumberFormatException: For input string: "10.0"
      at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
      at java.lang.Long.parseLong(Long.java:589)
      at java.lang.Long.parseLong(Long.java:631)
      at org.apache.hive.hplsql.Var.cast(Var.java:181)

      In Hive:
      hive> select cast('10.0' as integer);
      10
      Time taken: 4.563 seconds, Fetched: 1 row(s)
      hive> select cast('10.3' as integer);
      10

        Attachments

        1. HIVE-17028.1.patch
          2 kB
          Dmitry Tolpeko

          Activity

            People

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

              Dates

              • Created:
                Updated: