[SPARK-4599] [Build] [SQL] add hive profile in root pom

This is what it was after #2685 , but seems reset by #3159 
We can have hive-thriftserver always included when we have -Phive