Skip to main content

spark revision

 spark session 

First import Spark session from pyspark 

Define a Spark session 

spark = sparksession.bulider.appname("name").getorcreate()

spark session methods -->read, write, createDataframe, table, sql

Read the functions 


df1= spark.read.options().csv(file name )

                         .json(file name)

                         .text(file name)


options () --> multiline () --> df_multiline_json = spark.read.option("multiline", "true").json("multiline_json.json")

               delimiter --> df_pipe_delimited = spark.read.option("delimiter", "|").csv("file_without_header.csv")

               Header --> df_no_header = spark.read.csv("file_with_header.csv") # Default header=false

                          df_header = spark.read.option("header", "true").csv("file_with_header.csv")

               schema --> if there is no header, we need to construct the schema by structtype 

4. schema Option

print("\n--- schema Option ---")

custom_schema = StructType([

    StructField("person_id", IntegerType(), True),

    StructField("full_name", StringType(), True),

    StructField("age", IntegerType(), True)

])


df_with_schema = spark.read.option("header", "true").schema(custom_schema).csv("file_with_header.csv")

               inferschema --> df_infer_schema = spark.read.option("header", "true").option("inferSchema", "true").csv("file_with_header.csv")

df_infer_schema.show()

               format().load("file name") = if we need to expliity mention the file format and load the file 

df.createor ReplaceTempView("view name ")

spark.table("view name ")

we can change into 

Comments

Post a Comment

Popular posts from this blog

session 19 Git Repository

  🔁 Steps to Create a Branch in Databricks, Pull from Git, and Merge into a Collaborative Branch Create a New Branch in Databricks: Go to the Repos tab in your workspace. Navigate to the Git-linked repo. Click the Git icon (or three dots ⋮) and choose "Create Branch." Give your branch a name (e.g., feature-xyz ) and confirm. Pull the Latest Changes from Git: With your new branch selected, click the Git icon again. Select “Pull” to bring the latest updates from the remote repository into your local Databricks environment. Make Changes & Commit: Edit notebooks or files as needed in your branch. Use the "Commit & Push" option to push changes to the remote repo. Merge into the Collaborative Branch: Switch to the collaborative branch (e.g., dev or main ) in Git or from the Databricks UI. Click "Pull & Merge" . Choose the branch you want to merge into the collaborative branch. Review the c...
Post a Comment
Read more

Session 18 monitering and logging - Azure Monitor , Log analytics , and job notification

 After developing the code, we deploy it into the production environment. To monitor and logging the jobs run in the real time systems in azure  we have scheduled the jobs under the workflow , we haven't created any monitoring or any matrics . After a few times, the job failed, but we don't know because we haven't set up any monitoring, and every time we can't navigate to workspace-> workflows, under runs to see to check whether the job has been successfully running or not and in real time there will be nearly 100 jobs or more jobs to run  In real time, the production support team will monitor the process. Under the workflow, there is an option called Job notification. After setting the job notification, we can set a notification to email . if we click the date and time its takes us to the notebook which is scheduled there we can able to see the error where it happens . order to see more details, we need to under Spark tab, where we have the option to view logs ( tha...
Post a Comment
Read more

Transformation - section 6 - data flow

  Feature from Slide Explanation ✅ Code-free data transformations Data Flows in ADF allow you to build transformations using a drag-and-drop visual interface , with no need for writing Spark or SQL code. ✅ Executed on Data Factory-managed Databricks Spark clusters Internally, ADF uses Azure Integration Runtimes backed by Apache Spark clusters , managed by ADF, not Databricks itself . While it's similar in concept, this is not the same as your own Databricks workspace . ✅ Benefits from ADF scheduling and monitoring Data Flows are fully integrated into ADF pipelines, so you get all the orchestration, parameterization, logging, and alerting features of ADF natively. ⚠️ Important Clarification Although it says "executed on Data Factory managed Databricks Spark clusters," this does not mean you're using your own Azure Databricks workspace . Rather: ADF Data Flows run on ADF-managed Spark clusters. Azure Databricks notebooks (which you trigger via an "Exe...
Post a Comment
Read more