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