Rangaswamy Narayan created HIVE-18997:
-----------------------------------------
Summary: Hive column casting from decimal to double is resulting
in NULL
Key: HIVE-18997
URL: https://issues.apache.org/jira/browse/HIVE-18997
Project: Hive
Issue Type: Bug
Components: CLI
Affects Versions: 1.1.0
Environment: i have checked this is hive CLI.
Reporter: Rangaswamy Narayan
I have hive table table1 schema of the table looks like this
{{[CREATE TABLE table1(p_decimal1 DECIMAL(38,5)) ROW FORMAT DELIMITED FIELDS
TERMINATED BY ',' STORED AS TEXTFILE] }}
and i have below value in the table
{{row : col(p_decimal1) row1 : 12345123451234512345123.45123 }}
in later stage if i execute
{{select CAST(p_decimal1 AS DOUBLE) from table1; }}
query then I am getting {{NULL}} as a output.
expected output should be non-null value.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
