Regarding transformation with dataframe

[Gaurav Agarwal <ga...@gmail.com>]

Hello

I have loaded 3 dataframes with 3 different Static tables. Now i got the
csv file and with the help of Spark i loaded the csv into dataframe and
named it as temporary table as "Employee".
Now i need to enrich the columns in the Employee DF and query any of 3
static table respectively with some business logic
e.x.

If(employee.firstName!=null){
String emp.FristName=employee.FirstName;

Select mgr.Name from Mgr where broker.firstName=emp.FirstName
}

Once I retrieve Mgr.Name from Mgr table then i will set the value in the
employee table/DF in the corresponding column.

Thanks