I think if you want to run spark sql on CLI this configuration will be ok, but if you want to run with distributed query engine, start the JDBC/ODBC server and set the hive address info.
You can reference this description for more detail. http://spark.apache.org/docs/latest/sql-programming-guide.html#distributed-sql-engine ------------------------------------- Spark read hive table, catalog. CurrentDatabase value is the default, how the sparksession initialization, set currentDatabase value? <?xml version="1.0" encoding="UTF-8" standalone="no"?> <?xml-stylesheet type="text/xsl" href="configuration.xsl"?> <configuration> <property> <name>hive.metastore.uris</name> <value>thrift://localhost:9083</value> <description>IP address (or fully-qualified domain name) and port of the metastore host</description> </property> </configuration>
