[
https://issues.apache.org/jira/browse/SPARK-28748?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hyukjin Kwon updated SPARK-28748:
---------------------------------
Summary: 0 as decimal (n , n) in Hive tables shows as NULL in Spark (was:
Zeros(0) inserted as decimal (n , n) in hive tables shows as null in spark sql)
> 0 as decimal (n , n) in Hive tables shows as NULL in Spark
> ----------------------------------------------------------
>
> Key: SPARK-28748
> URL: https://issues.apache.org/jira/browse/SPARK-28748
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 2.1.0, 2.2.1, 2.3.1, 2.3.2, 2.4.3
> Reporter: Rohit Sindhu
> Priority: Minor
>
> Zeros(0) inserted as decimal (n , n) in hive tables shows as null in spark
> sql.
> Repro Steps
> *Hive Shell*
> {code}
> create table test_dec (name string , id decimal(3,3));
> insert into test_dec values ('c1' , 0) , ('c2' , 0.0) , ('c3' , 0.1);
> select * from test_dec;
> {code}
> {code}
> c1 0.000
> c2 0.000
> c3 0.100
> {code}
> *Spark* Shell
> {code}
> spark.sqlContext.sql("select * from test_dec").show;
> {code}
> {code}
> +----+-----+
>
> |name| id|
> +----+-----+
> | c1| null|
> | c2| null|
> | c3|0.100|
> +----+-----+
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.14#76016)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
