You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Vincent Ohprecio (JIRA)" <ji...@apache.org> on 2016/03/20 18:12:33 UTC
[jira] [Comment Edited] (SPARK-14031) Dataframe to csv IO, system
performance enters high CPU state and write operation takes 1 hour to
complete
[ https://issues.apache.org/jira/browse/SPARK-14031?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15203366#comment-15203366 ]
Vincent Ohprecio edited comment on SPARK-14031 at 3/20/16 5:12 PM:
-------------------------------------------------------------------
spark-shell has 4g. It looks like its affecting Stage 5. In version 1.4, 1.5, 1.6 writes are around 22 seconds. Its 60 minues with 2.0.
Here is my jstat output: https://gist.github.com/bigsnarfdude/f96c2e1f9440673157c9
Here is my inline code output: https://gist.github.com/bigsnarfdude/fad5a9ba7ac381120e93
was (Author: vohprecio):
It looks like its affecting Stage 5. In version 1.4, 1.5, 1.6 writes are around 22 seconds. Its 60 minues with 2.0.
Here is my jstat output: https://gist.github.com/bigsnarfdude/f96c2e1f9440673157c9
Here is my inline code output: https://gist.github.com/bigsnarfdude/fad5a9ba7ac381120e93
> Dataframe to csv IO, system performance enters high CPU state and write operation takes 1 hour to complete
> ----------------------------------------------------------------------------------------------------------
>
> Key: SPARK-14031
> URL: https://issues.apache.org/jira/browse/SPARK-14031
> Project: Spark
> Issue Type: Bug
> Components: Spark Shell
> Affects Versions: 2.0.0
> Environment: MACOSX 10.11.2 Macbook Pro 16g - 2.2 GHz Intel Core i7 -1TB and Ubuntu14.04 Vagrant 4 Cores 8g
> Reporter: Vincent Ohprecio
> Priority: Minor
>
> Summary
> When using spark-assembly-2.0.0/spark-shell trying to write out results of dataframe to csv, system performance enters high CPU state and write operation takes 1 hour to complete.
> * Affecting: [Stage 5:> (0 + 2) / 21]
> * Stage 5 elapsed time 3488272270000ns
> In comparison, tests where conducted using 1.4, 1.5, 1.6 with same code/data and Stage5 csv write times where between 2 - 22 seconds.
> In addition, Parquet (Stage 3) write tests 1.4, 1.5, 1.6 and 2.0 where similar between 2 - 22 seconds.
> Files
> 1. Data File is "2008.csv"
> 2. Data file download http://stat-computing.org/dataexpo/2009/the-data.html
> 3. Code https://gist.github.com/bigsnarfdude/581b780ce85d7aaecbcb
> Observation 1 - Setup
> High CPU and 58 minute average completion time
> * MACOSX 10.11.2
> * Macbook Pro 16g - 2.2 GHz Intel Core i7 -1TB
> * spark-assembly-2.0.0
> * spark-csv_2.11-1.4
> * Code: https://gist.github.com/bigsnarfdude/581b780ce85d7aaecbcb
> Observation 2 - Setup
> High CPU and waited over hour for csv write but didnt wait to complete
> * Ubuntu14.04
> * 4cores 8gb
> * spark-assembly-2.0.0
> * spark-csv_2.11-1.4
> Code Output: https://gist.github.com/bigsnarfdude/930f5832c231c3d39651
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org