singlecluster/templates/hive/conf/hive-site.xml

<configuration>
	<property>
		<name>hive.metastore.warehouse.dir</name>
		<value>/hive/warehouse</value>
	</property>
	<property>
		<name>hive.metastore.uris</name>
		<value>thrift://localhost:9083</value>
	</property>
	<property>
		<name>hive.server2.enable.impersonation</name>
		<value>true</value>
		<description>Set this property to enable impersonation in Hive Server 2</description>
	</property>
	<property>
		<name>hive.server2.enable.doAs</name>
		<value>false</value>
		<description>Set this property to enable impersonation in Hive Server 2</description>
	</property>
	<property>
		<name>hive.execution.engine</name>
		<value>mr</value>
		<description>Chooses execution engine. Options are: mr(default), tez, or spark</description>
	</property>
	<property>
		<name>hive.metastore.schema.verification</name>
		<value>false</value>
		<description>Modify schema instead of reporting error</description>
	</property>
	<property>
		<name>datanucleus.autoCreateTables</name>
		<value>True</value>
	</property>
	<property>
		<name>hive.metastore.integral.jdo.pushdown</name>
		<value>true</value>
	</property>
</configuration>