Explore Courses Blog Tutorials Interview Questions
0 votes
in Big Data Hadoop & Spark by (11.4k points)

I'm writing filter function for complex JSON dataset with lot's of inner structures. Passing individual columns is too cumbersome.

So I declared the following UDF:

val records:DataFrame = = sqlContext.jsonFile("...")
def myFilterFunction(r:Row):Boolean=???
sqlc.udf.register("myFilter", (r:Row)=>myFilterFunction(r))


Intuitively I'm thinking it will work like this:


What is the actual syntax?

1 Answer

0 votes
by (32.3k points)

You have to use struct() function for constructing the row while making a call to the function, follow these steps.

Import Row,

import org.apache.spark.sql._

Define the UDF

def myFilterFunction(r:Row) = {r.get(0)==r.get(1)} 

Register the UDF

sqlContext.udf.register("myFilterFunction", myFilterFunction _)

Create the dataFrame

val records = sqlContext.createDataFrame(Seq(("sachin", "sachin"), ("aggarwal", "aggarwal1"))).toDF("text", "text2")

Use the UDF


Now, in order to pass all the columns to UDF do:

records.filter(callUdf("myFilterFunction",struct( : _*))).show 



|  text| text2|




Related questions

0 votes
1 answer
asked Jul 28, 2019 in Big Data Hadoop & Spark by Aarav (11.4k points)
0 votes
1 answer
+1 vote
1 answer

Browse Categories