spark集成clickhouse报错： .ClassNotFound Failed to find data source: clickhouse. Please find packages at

小辉懂编程

已于 2023-09-25 15:45:08 修改

阅读量804

点赞数

分类专栏：报错问题文章标签： spark clickhouse 大数据

于 2023-09-25 15:41:02 首次发布

本文链接：https://blog.youkuaiyun.com/m0_69097184/article/details/133273657

版权

文章讲述了在使用Spark与ClickHouse集成时遇到的ClassNotFoundException，原因在于连接代码的顺序错误。作者强调了正确的代码配置顺序：driver->url->user->password->dbtable。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

报错描述

1.报错信息

Exception in thread "main" java.lang.ClassNotFoundException: Failed to find data source: clickhouse. Please find packages at http://spark.apache.org/third-party-projects.html
   at org.apache.spark.sql.execution.datasources.DataSource$.lookupDataSource(DataSource.scala:689)
   at org.apache.spark.sql.execution.datasources.DataSource$.lookupDataSourceV2(DataSource.scala:743)
   at org.apache.spark.sql.DataFrameReader.load(DataFrameReader.scala:266)
   at org.apache.spark.sql.DataFrameReader.load(DataFrameReader.scala:226)
   at org.zhibiaocul.DomeThree$.main(DomeThree.scala:25)
   at org.zhibiaocul.DomeThree.main(DomeThree.scala)
Caused by: java.lang.ClassNotFoundException: clickhouse.DefaultSource
   at java.net.URLClassLoader.findClass(URLClassLoader.java:387)
   at java.lang.ClassLoader.loadClass(ClassLoader.java:418)