If you have a situation that you can easily get the result using SQL/ SQL…
Author: user
PySpark : Generate a sequence number based on a specific order of the DataFrame
You can also use the row_number() function with over() clause to generate a sequence number based on a specific order…
PySpark : Generates a unique and increasing 64-bit integer ID for each row in a DataFrame
pyspark.sql.functions.monotonically_increasing_id A column that produces 64-bit integers with a monotonic increase. The created ID is assured to be both singular…
PySpark : Inserting row in Apache Spark Dataframe.
In PySpark, you can insert a row into a DataFrame by first converting the DataFrame to a RDD (Resilient Distributed…
PySpark : How to write Scala code in spark shell ?
To write Scala code in the Spark shell, you can simply start the Spark shell by running the command “spark-shell”…
PySpark : What happens once you do a spark submit command ?
When you submit a Spark application using the spark-submit command, a series of steps occur to start and execute the…
PySpark : What is predicate pushdown in Spark and how to enable it ?
Predicate pushdown is a technique used in Spark to filter data as early as possible in the query execution process,…
PySpark : How would you set the number of executors in any spark ? On what basis we will set the number of executors in a Spark?
The number of executors in a Spark-based application can be set by passing the –num-executors command line argument to the…
PySpark-What is map side join and How to perform map side join in Pyspark
Map-side join is a method of joining two datasets in PySpark where one dataset is broadcast to all executors, and…
Installing Apache Spark standalone on Linux
Installing Spark on a Linux machine can be done in a few steps. The following is a detailed guide on…
SQL : How to execute large dynamic query in SQL
There are a few ways to execute large dynamic queries in SQL, but one common method is to use a…