You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Hyukjin Kwon (JIRA)" <ji...@apache.org> on 2019/08/16 04:43:00 UTC
[jira] [Updated] (SPARK-28748) 0 as decimal (n , n) in Hive tables
shows as NULL in Spark
[ 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: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org