[HIVE-13540] Casts to numeric types don't seem to work in hplsql

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.2.0
• Fix Version/s: 2.3.0
• Component/s: hpl/sql
• Assignee: Dmitry Tolpeko
• Reporter: Carter Shanklin
• Created: 18/Apr/16 21:58
• Updated: 21/Jul/17 17:45
• Resolved: 08/Jun/16 13:55

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.

Issue Links

• is related to: HIVE-14804 HPLSQL multiple db connection does not switch back to Hive