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

This is what it was after #2685 , but seems reset by #3159 
In some cases we want to build one but not the other. For instance Scala 2.11 does not yet support the thirftserver due to a dependency conflict.