[ https://issues.apache.org/jira/browse/SPARK-7299?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Reynold Xin resolved SPARK-7299. -------------------------------- Resolution: Fixed Fix Version/s: 1.4.0 Assignee: Liang-Chi Hsieh > saving Oracle-source DataFrame to Hive changes scale > ---------------------------------------------------- > > Key: SPARK-7299 > URL: https://issues.apache.org/jira/browse/SPARK-7299 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 1.3.1 > Reporter: Ken Geis > Assignee: Liang-Chi Hsieh > Fix For: 1.4.0 > > > When I load data from Oracle, save it to a table, then select from it, the > scale is changed. > For example, I have a column defined as NUMBER(12, 2). I insert 19999 into > the column. When I write that to a table and select from it, the result is > 199.99. > Some databases (e.g. H2) will return this as 19999.00, but Oracle returns it > as 19999. I believe that when the file is written out to parquet, the scale > information is taken from the schema, not the value. In an Oracle (at least) > JDBC DataFrame, the scale may be different from row to row. -- This message was sent by Atlassian JIRA (v6.3.4#6332) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org