Carter Shanklin created HIVE-13540: -------------------------------------- Summary: Casts to numeric types don't seem to work in hplsql Key: HIVE-13540 URL: https://issues.apache.org/jira/browse/HIVE-13540 Project: Hive Issue Type: Bug Components: hpl/sql Reporter: Carter Shanklin Assignee: Dmitry Tolpeko
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: {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 {code} Produces this output: {code} [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 {code} The software I'm using is not anything released but is pretty close to the trunk, 2 weeks old at most. -- This message was sent by Atlassian JIRA (v6.3.4#6332)