[ https://issues.apache.org/jira/browse/KYLIN-3773?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Shaofeng SHI reassigned KYLIN-3773: ----------------------------------- Assignee: youcheng.zhang > Using Mysql instead of Hive as Data Source fails with LinkageError > ------------------------------------------------------------------ > > Key: KYLIN-3773 > URL: https://issues.apache.org/jira/browse/KYLIN-3773 > Project: Kylin > Issue Type: Bug > Components: RDBMS Source > Affects Versions: v2.6.0 > Reporter: Hubert STEFANI > Assignee: youcheng.zhang > Priority: Critical > Fix For: v2.6.1 > > > we are currently trying to test the KYLIN-3552 feature to rely directly on > Mysql for data source instead of Hive. > > (we tried as much as possible to add correct info in kylin.properties, add > mysql jdbc drivers, create mysql.xml in ./conf/datasources ... as mentioned > in [https://github.com/apache/kylin/pull/327/files] ) > > > > the error we entountered is ( excerpt from kylin.log ) : > > > 2019-01-14 09:48:16,223 WARN [http-bio-7070-exec-2] extensible.JdbcSource:50 > : DataSource cannot be connected. This may not be required in a MapReduce job. > java.lang.LinkageError: loader constraint violation: loader (instance of > sun/misc/Launcher$AppClassLoader) previously initiated loading for a > different type with name "org/apache/kylin/common/KylinConfig" > at java.lang.ClassLoader.defineClass1(Native Method) > at java.lang.ClassLoader.defineClass(ClassLoader.java:763) > at > java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142) > at java.net.URLClassLoader.defineClass(URLClassLoader.java:467) > at java.net.URLClassLoader.access$100(URLClassLoader.java:73) > at java.net.URLClassLoader$1.run(URLClassLoader.java:368) > at java.net.URLClassLoader$1.run(URLClassLoader.java:362) > at java.security.AccessController.doPrivileged(Native Method) > at java.net.URLClassLoader.findClass(URLClassLoader.java:361) > at java.lang.ClassLoader.loadClass(ClassLoader.java:424) > at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349) > at java.lang.ClassLoader.loadClass(ClassLoader.java:357) > at > org.apache.kylin.sdk.datasource.framework.SourceConnectorFactory.getJdbcConnector(SourceConnectorFactory.java:27) > with further trace : > 2019-01-14 09:48:16,229 ERROR [http-bio-7070-exec-2] > controller.TableController:197 : > java.lang.NullPointerException > at > org.apache.kylin.source.jdbc.extensible.JdbcExplorer.listDatabases(JdbcExplorer.java:58) > at > org.apache.kylin.rest.service.TableService.getSourceDbNames(TableService.java:280) > at > org.apache.kylin.rest.controller.TableController.showHiveDatabases(TableController.java:195) > > > the properties we use in kylin.properties are : > > # NOVAGEN -- CUSTOM CONFIGURATION FOR MYSQL AS SOURCE > kylin.source.jdbc.connection-url=jdbc:mysql://ip-172-31-36-94.eu-west-1.compute.internal:3306/decat > kylin.source.jdbc.driver=com.mysql.jdbc.Driver > kylin.source.jdbc.dialect=mysql > kylin.source.jdbc.user=root > kylin.source.jdbc.pass= > kylin.query.pushdown.runner-class-name=org.apache.kylin.query.pushdown.PushdownRunnerSDKImpl > kylin.source.default=16 > kylin.source.jdbc.sqoop-home=/usr/bin > kylin.source.jdbc.adaptor=org.apache.kylin.sdk.datasource.adaptor.MysqlAdaptor > -- This message was sent by Atlassian JIRA (v7.6.3#76005)