127. Databricks | Pyspark| SQL Coding Interview:LeetCode-1045: Customers Who Bought All Products

No video

127. Databricks | Pyspark| SQL Coding Interview:LeetCode-1045: Customers Who Bought All Products

Рет қаралды 1,916

Күн бұрын

Azure Databricks Learning: Coding Interview Exercise: Pyspark and Spark SQL
=================================================================================
Coding exercises are very common in most Big Data interviews. It is important to develop coding skills before appearing for Spark/Databricks interviews.
In this video, I have explained a coding scenario to find the customers who bought all the products available. This is also one of the common coding exercises asked in MAANG/FAANG/GAMAM companies such as Google, Apple, Microsoft, Amazon, Meta, etc.
Consider the following tables:
Products Table:
+-----------+
|product_key|
+-----------+
| 5|
| 6|
+-----------+
Customers Table:
+-----------+-----------+
|customer_id|product_key|
+-----------+-----------+
| 1| 5|
| 2| 6|
| 3| 5|
| 3| 6|
| 1| 6|
+-----------+-----------+
Output:
+-------------+
| Customer_Id |
+-------------+
| 1 |
| 3 |
+-------------+
In this example, customer 1 and 3 bought all the products (5 and 6), so they are included in the output. Watch the video to understand the approach and solution for this coding problem, which can be very useful in your Big Data interviews."
To get more understanding, watch this video
• 127. Databricks | Pysp...
#Leetcode1045,#LeetcodeSQL1045, #LeetcodeCustomersBoughtAllProducts, #LeetCodeSQL, #HackerRankSQL,#MAANG/FAANG/GAMAM,#FAANGCodingQuestion, #SQLCoding, #PysparkCoding, #CodingInterviewQuestion, #ApacheSparkInterview, #SparkCodingExercise, #DatabricksCodingInterview,#SparkWindowFunctions,#SparkDevelopment,#DatabricksDevelopment, #DatabricksPyspark,#PysparkTips, #DatabricksTutorial, #AzureDatabricks, #Databricks, #Databricksforbeginners,#datascientists, #datasciencecommunity,#bigdataengineers,#machinelearningengineers

Пікірлер: 12

@sravankumar1767 2 ай бұрын

After a long time came with new concept .Thanks Raja

@rajasdataengineering7585 2 ай бұрын

Thanks Sravan! 🙂

@vishnupriyaarora Ай бұрын

Hello Raja, what's the best way to reach you?

@selvavinayaganmuthukumaran1332 2 ай бұрын

Hi Sir, do u have any git repo for all these notebook. It would be helpful if you could share these notebooks for reference

@rawat7203 2 ай бұрын

Hi Sir My Way: count_product = product_df.distinct().count() grp_df = customer_df.groupBy('customer_id').agg(countDistinct('product_key').alias('count_of_product')) list_customers = grp_df.filter(col('count_of_product')==count_product).select('customer_id') list_customers.show() SQL: select customer_id from customers group by customer_id having count(distinct(product_key)) = (select count(product_key) from products);

@rajasdataengineering7585 2 ай бұрын

Thank you for sharing your approach!