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

This is what it was after #2685 , but seems reset by #3159