'NullPointerException in Apache Kylin when using JDBC
I use Kylin from Docker: https://kylin.apache.org/docs/install/kylin_docker.html
I downloaded sqoop-1.4.7.bin__hadoop-2.6.0.tar.gz
to SQOOP_HOME directory.
When I am trying to follow example here: https://kylin.apache.org/docs31/tutorial/setup_jdbc_datasource.html
Whatever database I use I get the same error, and I start to suspect that this is something general:
2022-05-12 14:51:51,205 INFO [http-bio-7070-exec-10] common.KylinConfig:493 : Creating new manager instance of class org.apache.kylin.source.SourceManager
2022-05-12 14:51:51,208 ERROR [http-bio-7070-exec-10] source.SourceManager:118 : Failed to create source: SourceType=8
java.lang.NullPointerException
at org.apache.kylin.common.util.ClassUtil.forRenamedClass(ClassUtil.java:79)
at org.apache.kylin.common.util.ClassUtil.forName(ClassUtil.java:74)
at org.apache.kylin.source.SourceManager.createSource(SourceManager.java:115)
at org.apache.kylin.source.SourceManager.getCachedSource(SourceManager.java:84)
at org.apache.kylin.source.SourceManager.getProjectSource(SourceManager.java:93)
at org.apache.kylin.rest.service.TableService.getSourceDbNames(TableService.java:272)
at org.apache.kylin.rest.controller.TableController.showHiveDatabases(TableController.java:212)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
Maybe sqoop version does not correspond to hadoop (it is 2.8.5 in the kylin container)?
JDBC settings that I used
# BigQuery
kylin.source.default=8
kylin.source.jdbc.dialect=sql
kylin.source.jdbc.driver=com.simba.googlebigquery.jdbc42.Driver
kylin.source.jdbc.sqoop-home=/home/admin/sqoop
kylin.source.jdbc.connection-url=jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=project_id;OAuthType=0;[email protected];OAuthPvtKeyPath=/home/admin/.keys/bqkey.json;AllowLargeResults=1
# PG
kylin.source.default=8
kylin.source.jdbc.connection-url=jdbc:postgresql://12.130.01.01:5432/db
kylin.source.jdbc.driver=org.postgresql.Driver
kylin.source.jdbc.dialect=postgresql
kylin.source.jdbc.user=user
kylin.source.jdbc.pass=pass
kylin.source.jdbc.sqoop-home=/home/admin/sqoop
kylin.source.jdbc.filed-delimiter=|
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|