[ https://issues.apache.org/jira/browse/SPARK-28748?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hyukjin Kwon updated SPARK-28748: --------------------------------- Target Version/s: (was: 2.2.1, 2.3.1, 2.3.2, 2.4.3) > Zeros(0) inserted as decimal (n , n) in hive tables shows as null in spark sql > ------------------------------------------------------------------------------ > > 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 > Labels: Spark-SQL, spark-sql > > Zeros(0) inserted as decimal (n , n) in hive tables shows as null in spark > sql. > Repro Steps > *Hive Shell* > # 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; > c1 0.000 > c2 0.000 > c3 0.100 > > *Spark* Shell > * spark.sqlContext.sql("select * from test_dec").show; > +----+-----+ > > |name| id| > +----+-----+ > | c1 | null | > | c2 | null | > | c3 | 0.100 | > +----+-----+ -- This message was sent by Atlassian JIRA (v7.6.14#76016) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org