Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
1.1.0
-
None
-
None
-
Hive CLI and cloudera 5.8.3 distribution
Description
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.