[SPARK-2235][SQL]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 .
JIRA:https://issues.apache.org/jira/browse/SPARK-2235
Does hive support this?  if so we should add a test to HiveQuerySuite too.