spark读取Hive出错： Database 'hxh' not found;

提示spark读取hive找不到库

Exception in thread "main" org.apache.spark.sql.catalyst.analysis.NoSuchDatabaseException: Database 'hxh' not found;
	at org.apache.spark.sql.catalyst.catalog.ExternalCatalog.requireDbExists(ExternalCatalog.scala:40)
	at org.apache.spark.sql.catalyst.catalog.InMemoryCatalog.tableExists(InMemoryCatalog.scala:323)
	at org.apache.spark.sql.catalyst.catalog.ExternalCatalog.requireTableExists(ExternalCatalog.scala:45)
	at org.apache.spark.sql.catalyst.catalog.InMemoryCatalog.getTable(InMemoryCatalog.scala:314)
	at org.apache.spark.sql.catalyst.catalog.SessionCatalog.lookupRelation(SessionCatalog.scala:681)
	at org.apache.spark.sql.SparkSession.table(SparkSession.scala:609)
	at org.apache.spark.sql.SparkSession.table(SparkSession.scala:605)
	at org.apache.spark.sql.DataFrameReader.table(DataFrameReader.scala:591)
	at com.hxh.spark.SqlNetworkWordCount$.main(SqlNetworkWordCount.scala:44)
	at com.hxh.spark.SqlNetworkWordCount.main(SqlNetworkWordCount.scala)

解决方案：

加上enableHiveSupport()即可，否则默认不读hive-site.xml。

val sparkConf = new SparkConf().setAppName("SqlNetworkWordCount").setMaster("local[*]").enableHiveSupport().getOrCreate()

最后

以上就是自由牛排为你收集整理的spark读取Hive出错： Database 'hxh' not found;的全部内容，希望文章能够帮你解决spark读取Hive出错： Database 'hxh' not found;所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。