mvn clean package
scp target/spark-hive-solr-demo-1.0-SNAPSHOT.jar hadoop01:/tmp/

runuser -l hdfs -c 'spark-submit --class io.woolford.Main --master=yarn-cluster /tmp/spark-hive-solr-demo-1.0-SNAPSHOT.jar --files=/etc/hive/conf/hive-site.xml'

runuser -l hdfs -c 'spark-submit --class io.woolford.Main --master=yarn-cluster --files=/usr/hdp/current/spark-client/conf/hive-site.xml /tmp/spark-hive-solr-demo-1.0-SNAPSHOT.jar'

<configuration>
	<property>
	  <name>hive.metastore.warehouse.dir</name>
	  <value>/apps/hive/warehouse</value>
	</property>
	<property>
	  <name>javax.jdo.option.ConnectionURL</name>
	  <value>jdbc:mysql://sandbox.hortonworks.com/metastore</value>
	  <description>the URL of the MySQL database</description>
	</property>
	
	<property>
	  <name>javax.jdo.option.ConnectionDriverName</name>
	  <value>com.mysql.jdbc.Driver</value>
	</property>
	
	<property>
	  <name>javax.jdo.option.ConnectionUserName</name>
	  <value>root</value>
	</property>
	
	<property>
	  <name>javax.jdo.option.ConnectionPassword</name>
	  <value>hadoop</value>
	</property>
	
	<property>
	  <name>datanucleus.autoCreateSchema</name>
	  <value>false</value>
	</property>
	
	<property>
	  <name>datanucleus.fixedDatastore</name>
	  <value>true</value>
	</property>
	
	<property>
	  <name>datanucleus.autoStartMechanism</name>
	  <value>SchemaTable</value>
	</property>
    
    <property>
      <name>hive.metastore.uris</name>
      <value>thrift://sandbox.hortonworks.com:9083</value>
    </property>
</configuration>

	<property>
	  <name>javax.jdo.option.ConnectionPassword</name>
	  <value>hadoop</value>
	</property>

su hdfs

vi firstname_lastname.txt

$ cat firstname_lastname.txt 
Barack,Obama
Donald,Trump

hive
CREATE TABLE sanjay (
	firstname string,
	lastname string
)
ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
LOCATION '/apps/hive/warehouse/sanjay';

hdfs dfs -copyFromLocal firstname_lastname.txt /apps/hive/warehouse/sanjay

hive> select * from sanjay;

Barack	Obama
Donald	Trump