[jira] [Updated] (HIVE-18997) Hive column casting from decimal to double is resulting in NULL
[
https://issues.apache.org/jira/browse/HIVE-18997?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rangaswamy Narayan updated HIVE-18997:
--
Environment: Hive CLI and cloudera 5.8.3 distribution (was: i have
checked this is hive CLI. )
> 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: Hive CLI and cloudera 5.8.3 distribution
>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)
[jira] [Updated] (HIVE-18997) Hive column casting from decimal to double is resulting in NULL
[
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)
