Run with:
df = spark.read.parquet("sales.parquet") df.filter("amount > 1000").groupBy("region").count().show() You can register DataFrames as temporary views and run SQL: beginning apache spark 3 pdf
Example:
df.createOrReplaceTempView("sales") result = spark.sql("SELECT region, COUNT(*) FROM sales WHERE amount > 1000 GROUP BY region") This makes Spark accessible to analysts familiar with SQL. 4.1 Reading and Writing Data Supported formats: Parquet, ORC, Avro, JSON, CSV, text, JDBC, and more. Run with: df = spark
spark-submit first_spark_app.py spark-submit \ --master yarn \ --deploy-mode cluster \ --num-executors 10 \ --executor-memory 8G \ --executor-cores 4 \ my_etl_job.py Chapter 10: Common Pitfalls and Best Practices | Pitfall | Solution | |----------------------------------|----------------------------------------------| | Using RDDs unnecessarily | Prefer DataFrames + Catalyst optimizer | | Too many shuffles | Use repartition sparingly; leverage bucketing | | Ignoring AQE | Enable it; let Spark 3 optimize dynamically | | Collecting large DataFrames | Use take() or sample() instead of collect() | | Not handling skew | Enable AQE skewJoin or salt the join key | | Long‑running streaming without watermark | Always set watermarks for event‑time processing | Conclusion Apache Spark 3 represents a mature, powerful, and developer‑friendly engine for all data processing needs. Its unified approach – from batch to streaming, from SQL to machine learning – reduces complexity while delivering industry‑leading performance. Its unified approach – from batch to streaming,
General rule: 2–3 tasks per CPU core.