[ https://issues.apache.org/jira/browse/HIVE-18997?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rangaswamy Narayan updated HIVE-18997: -------------------------------------- Component/s: distribution > 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, distribution > Affects Versions: 1.1.0 > Environment: i have checked this is hive CLI. > Reporter: Rangaswamy Narayan > Priority: Major > > 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)