Reduce and aggregate actions in Apache Spark - Mini Project: Build & Apply

Reduce and aggregate actions

📖 Scenario: You work at a small online store. You have a list of sales records showing the product name and the quantity sold. You want to find out the total quantity sold for each product.

🎯 Goal: Build a Spark program that sums the quantities sold for each product using reduce and aggregate actions.

📋 What You'll Learn

Create an RDD with the exact sales data given

Create a variable for the minimum quantity threshold

Use reduceByKey to sum quantities for each product

Print the final aggregated result

💡 Why This Matters

🌍 Real World

Summing sales quantities per product is a common task in retail analytics to understand product performance.

💼 Career

Data scientists and analysts often use reduce and aggregate actions in Spark to process large datasets efficiently.

1

Create the sales data RDD

Create a Spark RDD called sales_rdd from the list of tuples: [('apple', 10), ('banana', 5), ('apple', 3), ('banana', 7), ('orange', 8)].

Apache Spark

from pyspark.sql import SparkSession

spark = SparkSession.builder.appName('ReduceAggregate').getOrCreate()
sc = spark.sparkContext

# Create sales_rdd from the given list
# Your code here

Hint

Use sc.parallelize() to create an RDD from the list of tuples.

2

Set the minimum quantity threshold

Create a variable called min_quantity and set it to 5.

Apache Spark

from pyspark.sql import SparkSession

spark = SparkSession.builder.appName('ReduceAggregate').getOrCreate()
sc = spark.sparkContext

sales_rdd = sc.parallelize([('apple', 10), ('banana', 5), ('apple', 3), ('banana', 7), ('orange', 8)])

# Create min_quantity variable and set it to 5
# Your code here

Hint

Just assign the number 5 to the variable min_quantity.

3

Sum quantities for each product using reduceByKey

Use reduceByKey on sales_rdd with a lambda function that adds two quantities to create a new RDD called total_sales_rdd.

Apache Spark

from pyspark.sql import SparkSession

spark = SparkSession.builder.appName('ReduceAggregate').getOrCreate()
sc = spark.sparkContext

sales_rdd = sc.parallelize([('apple', 10), ('banana', 5), ('apple', 3), ('banana', 7), ('orange', 8)])

min_quantity = 5

# Use reduceByKey with lambda to sum quantities and create total_sales_rdd
# Your code here

Hint

Use reduceByKey(lambda x, y: x + y) to add quantities for each product.

4

Print the total sales result

Print the list of tuples from total_sales_rdd.collect() to show the total quantity sold for each product.

Apache Spark

from pyspark.sql import SparkSession

spark = SparkSession.builder.appName('ReduceAggregate').getOrCreate()
sc = spark.sparkContext

sales_rdd = sc.parallelize([('apple', 10), ('banana', 5), ('apple', 3), ('banana', 7), ('orange', 8)])

min_quantity = 5

total_sales_rdd = sales_rdd.reduceByKey(lambda x, y: x + y)

# Print the collected results from total_sales_rdd
# Your code here

Hint

Use print(total_sales_rdd.collect()) to display the final sums.

Practice

1.

What does the reduce action do in Apache Spark?

easy

A. It filters elements based on a condition.

B. It creates a new RDD by mapping each element.

C. It combines all elements of an RDD using a specified function to produce a single result.

D. It sorts the elements in the RDD.

Solution

1. Step 1: Understand the purpose of reduce

   The reduce action combines all elements of an RDD by applying a function that takes two elements and returns one, repeating until one result remains.

2. Step 2: Compare with other actions

   Filtering selects elements, mapping transforms elements, and sorting orders elements, none of which combine all elements into one.

3. Final Answer:

   It combines all elements of an RDD using a specified function to produce a single result. -> Option C

4. Quick Check:

   Reduce = combine all elements [OK]

Hint: Reduce combines all data into one value using a function [OK]

Common Mistakes:

• Confusing reduce with filter or map actions
• Thinking reduce sorts data
• Assuming reduce returns an RDD instead of a single value

2.

Which of the following is the correct syntax to use reduce on an RDD named rdd to sum all elements?

rdd.reduce(_____)

easy

A. lambda x: x * 2

B. lambda x, y: x + y

C. lambda x, y: x * y

D. lambda x: x + 1

Solution

1. Step 1: Identify the function signature for reduce

   The function passed to reduce must take two arguments and return one combined result.

2. Step 2: Choose the function that sums two elements

   Only lambda x, y: x + y takes two arguments and sums them, suitable for summing all elements.

3. Final Answer:

   lambda x, y: x + y -> Option B

4. Quick Check:

   Reduce needs two-arg function for combining [OK]

Hint: Reduce function must take two inputs and combine them [OK]

Common Mistakes:

• Using single-argument lambda instead of two-argument
• Using multiplication when sum is needed
• Passing a function that does not return a single value

3.

Given the following code, what is the output?

rdd = sc.parallelize([1, 2, 3, 4])
result = rdd.aggregate(0, (lambda acc, x: acc + x), (lambda acc1, acc2: acc1 + acc2))
print(result)

medium

A. 24

B. 0

C. Error

D. 10

Solution

1. Step 1: Understand aggregate parameters

   The initial value is 0. The first lambda adds each element to the accumulator. The second lambda combines accumulators from partitions by summing.

2. Step 2: Calculate the sum of elements

   Sum of [1, 2, 3, 4] is 10. The aggregate returns this sum.

3. Final Answer:

   10 -> Option D

4. Quick Check:

   Aggregate sums elements starting at 0 [OK]

Hint: Aggregate with zero start and sum functions returns total sum [OK]

Common Mistakes:

• Confusing aggregate with reduce output
• Ignoring initial zero value
• Expecting product instead of sum

4.

Identify the error in this Spark code snippet:

rdd = sc.parallelize([1, 2, 3])
result = rdd.reduce(lambda x: x + 1)
print(result)

medium

A. The lambda function should take two arguments, not one.

B. The RDD is empty, so reduce will fail.

C. The reduce function cannot be used with integers.

D. The print statement is missing parentheses.

Solution

1. Step 1: Check lambda function signature for reduce

   The reduce function requires a function with two parameters to combine elements pairwise.

2. Step 2: Identify the incorrect lambda

   The lambda lambda x: x + 1 takes only one argument, causing a runtime error.

3. Final Answer:

   The lambda function should take two arguments, not one. -> Option A

4. Quick Check:

   Reduce needs two-argument function [OK]

Hint: Reduce lambda must have two parameters to combine elements [OK]

Common Mistakes:

• Using single-argument lambda in reduce
• Assuming reduce works on empty RDD without error
• Misreading print syntax in Python 3

5.

You have an RDD of tuples representing (category, value):

data = [("A", 2), ("B", 3), ("A", 5), ("B", 7), ("C", 1)]
rdd = sc.parallelize(data)

Which approach correctly uses aggregateByKey to find the sum of values per category?

hard

A. rdd.aggregateByKey(0, lambda acc, v: acc + v, lambda acc1, acc2: acc1 + acc2).collect()

B. rdd.reduce(lambda x, y: x + y).collect()

C. rdd.aggregate(0, lambda acc, x: acc + x[1], lambda acc1, acc2: acc1 + acc2).collect()

D. rdd.mapValues(lambda v: v).reduceByKey(lambda x, y: x * y).collect()

Solution

1. Step 1: Understand aggregateByKey usage

   aggregateByKey starts with zero per key, adds values with first lambda, then merges partitions with second lambda.

2. Step 2: Check each option

   rdd.aggregateByKey(0, lambda acc, v: acc + v, lambda acc1, acc2: acc1 + acc2).collect() correctly uses aggregateByKey with zero start and sum functions per key. rdd.reduce(lambda x, y: x + y).collect() is invalid syntax for key-value RDD. rdd.aggregate(0, lambda acc, x: acc + x[1], lambda acc1, acc2: acc1 + acc2).collect() uses aggregate on whole RDD, not per key. rdd.mapValues(lambda v: v).reduceByKey(lambda x, y: x * y).collect() multiplies values, not sums.

3. Final Answer:

   rdd.aggregateByKey(0, lambda acc, v: acc + v, lambda acc1, acc2: acc1 + acc2).collect() -> Option A

4. Quick Check:

   aggregateByKey sums values per key [OK]

Hint: Use aggregateByKey with zero start and sum lambdas for per-key sums [OK]

Common Mistakes:

• Using aggregate instead of aggregateByKey for key-value RDD
• Using reduce without key awareness
• Multiplying instead of summing values