I have a file which contains employee data and I want to filter out the results using Spark SQL. So I've tried filter as well as where clause and I found they both works same.
example:
val items = List(1, 2, 3)
using filter
employees.filter($"emp_id".isin(items:_*)).show
using where
employees.where($"emp_id".isin(items:_*)).show
Got the same result in both the cases.
Can anyone tell me why am I getting the same result using filter and where?