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

This is what it was after #2685 , but seems reset by #3159 
What's the purpose of this? there are already profiles covering activation of Hive itself below; this profile is supposed to be about thriftserver and is so named.