Need to count the total number of employee visited all the location where one employee visited.
This needs to be done by using scala data frame.
I am sharing two attachments. One is with problem statement and other one is with the exact input and output.
This has to be done on 1 billions of record and performance must need to take care.