Spark SQL basicOperator add Intersect operator

Hi all,
I want to submit a basic operator Intersect
For example , in sql case 
select * from table1
intersect
select * from table2
So ,i want use this operator support this function in Spark SQL  
This operator will return the  the intersection of SparkPlan child table RDD .