How to query external hive Metastore From Spark

In this Blog we will learn how can we access tables from hive metastore in spark,so now just lets get started

• start your hive metastore as  as service with following command
• hive –service metastore by default it will start metastore on port 9083

• go to your spark client and tell driver to conncet to metastore listening on port 9083  when starting the hive thrift server with following command
• $SPARK_HOME/sbin/start-thriftserver.sh –driver-java-options “-Dhive.metastore.uris=thrift://localhost:9083”

as you can see show tables show all the tables that are in hive metastore now they are available to spark-client

i hope this blog will help