In Hive we can use following precedence order to set the configurable properties.
1. Hive SET command has the highest priority
2. -hiveconf option from Hive Command Line
3. hive-site.xml file
4. hive-default.xml file
5. hadoop-site.xml file
6. hadoop-default.xml file