開発
#data
spark-optimization
Optimize Apache Spark jobs with partitioning, caching, shuffle optimization, and memory tuning. Use when improving Spark performance, debugging slow jobs, or scaling data processing pipelines.
DeepseekModel
キュレーション済みスキル
品質 優秀 · 90
v1.0.0
取得
https://deepseekmodel.com/api/download.php?id=wshobson-agents-plugins-data-engineering-skills-spark-optimization-skill-md&format=skill
ダウンロード .skill
標準形式。system_prompt と model_config を収録し、任意の Agent で利用可能
.skill ファイルの system_prompt フィールドの実際の内容。
name spark-optimization description Optimize Apache Spark jobs with partitioning, caching, shuffle optimization, and memory tuning. Use when improving Spark performance, debugging slow jobs, or scaling data processing pipelines. Apache Spark Optimization Production patterns for optimizing Apache Spark jobs including partitioning strategies, memory management, shuffle optimization, and performance tuning. When to Use This Skill Optimizing slow Spark jobs Tuning memory and executor configuration Implementing efficient partitioning strategies Debugging Spark performance issues Scaling Spark pipelines for large datasets Reducing shuffle and data skew Core Concepts 1. Spark Execution Model Driver Program ↓ Job (triggered by action) ↓ Stages (separated by shuffles) ↓ Tasks (one per partition) 2. Key Performance Factors Factor Impact Solution Shuffle Network I/O, disk I/O Minimize wide transformations Data Skew Uneven task duration Salting, broadcast joins Serialization CPU overhead Use Kryo, columnar formats Memory GC pressure, spills Tune executor memory Partitions Parallelism Right-size partitions Quick Start from pyspark.sql import SparkSession from pyspark.sql import functions as F # Create optimized Spark session spark = (SparkSession.builder .appName( "OptimizedJob" ) .config( "spark.sql.adaptive.enabled" , "true" ) .config( "spark.sql.adaptive.coalescePartitions.enabled" , "true" ) .config( "spark.sql.adaptive.skewJoin.enabled" , "true" ) .config( "spark.serializer" , "org.apache.spark.serializer.KryoSerializer" ) .config( "spark.sql.shuffle.partitions" , "200" ) .getOrCreate()) # Read with optimized settings df = (spark.read . format ( "parquet" ) .option( "mergeSchema" , "false" ) .load( "s3://bucket/data/" )) # Efficient transformations result = (df . filter (F.col( "date" ) >= "2024-01-01" ) .select( "id" , "amount" , "category" ) .groupBy( "category" ) .agg(F. sum ( "amount" ).alias( "total" ))) result.write.mode( "overwrite" ).parquet( "s3://bucket/output/" ) Detailed patterns and worked examples Detailed pattern documentation lives in references/details.md . Read that file when the navigation tier above is insufficient. Best Practices Do's Enable AQE - Adaptive query execution handles many issues Use Parquet/Delta - Columnar formats with compression Broadcast small tables - Avoid shuffle for small joins Monitor Spark UI - Check for skew, spills, GC Right-size partitions - 128MB - 256MB per partition Don'ts Don't collect large data - Keep data distributed Don't use UDFs unnecessarily - Use built-in functions Don't over-cache - Memory is limited Don't ignore data skew - It dominates job time Don't use .count() for existence - Use .take(1) or .isEmpty()
このスキルを起動するキーワード。クリックでコピーできます。
このスキルにはトリガーワードがありません。
ダウンロードした .skill に含まれるフィールド。
| フィールド | 説明 |
|---|---|
| format | フォーマット識別子(skill/v1) |
| skill_id | スキル固有 ID |
| name | スキル名 |
| version | バージョン |
| description | 説明 |
| category | カテゴリ(配列) |
| trigger_words | トリガーワード |
| tags | タグ |
| source | ソース |
| source_url | ソース URL(本ページ) |
| exported_at | エクスポート日時(ダウンロード毎) |
| system_prompt | システムプロンプト本文 |
| model_config | モデル設定:provider / model / temperature / max_tokens / top_p |
| examples | サンプル |
| install_guide | 各プラットフォームの導入説明(Coze / Dify / Claude / カスタム) |