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

Casts to numeric types don't seem to work in hplsql

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.2.0
    • Fix Version/s: 2.3.0
    • Component/s: hpl/sql
    • Labels:
      None

      Description

      Maybe I'm doing this wrong? But it seems to be broken.

      Casts to string types seem to work fine, but not numbers.

      This code:

      temp_int     = CAST('1' AS int);
      print temp_int
      temp_float   = CAST('1.2' AS float);
      print temp_float
      temp_double  = CAST('1.2' AS double);
      print temp_double
      temp_decimal = CAST('1.2' AS decimal(10, 4));
      print temp_decimal
      temp_string = CAST('1.2' AS string);
      print temp_string
      

      Produces this output:

      [vagrant@hdp250 hplsql]$ hplsql -f temp2.hplsql
      which: no hbase in (/usr/lib64/qt-3.3/bin:/usr/lib/jvm/java/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/opt/puppetlabs/bin:/usr/local/share/jmeter/bin:/home/vagrant/bin)
      WARNING: Use "yarn jar" to launch YARN applications.
      null
      null
      null
      null
      1.2
      

      The software I'm using is not anything released but is pretty close to the trunk, 2 weeks old at most.

        Attachments

        1. HIVE-13540.1.patch
          35 kB
          Dmitry Tolpeko

          Issue Links

            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:
                  Resolved: