You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Yuming Wang (JIRA)" <ji...@apache.org> on 2019/08/16 10:21:00 UTC
[jira] [Commented] (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:comment-tabpanel&focusedCommentId=16908937#comment-16908937 ]
Yuming Wang commented on SPARK-28748:
-------------------------------------
We fixed it by upgrade built-in Hive to 2.3.5 and we has ported test: SPARK-28460
!image-2019-08-16-18-18-19-279.png!
> 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
> Attachments: image-2019-08-16-18-18-19-279.png
>
>
> 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