Create xml file .../spark-3.0.0-bin-hadoop2.7/conf/hive-site.xml
<configuration>
<property>
<name>hive.metastore.warehouse.dir</name>
<value>/Users/deepakjayaprakash/Downloads/spark_database/</value>
</property>
</configuration>
Save