[jira] [Created] (KYLIN-4987) Unable to build cube for JDBC MS SQL Connection

Lim Sing Yik created KYLIN-4987: --- Summary: Unable to build cube for JDBC MS SQL Connection Key: KYLIN-4987 URL: https://issues.apache.org/jira/browse/KYLIN-4987 Project: Kylin Issue Type: Bug

[jira] [Created] (KYLIN-4986) Unable to build cube for JDBC MS SQL Connection

Lim Sing Yik created KYLIN-4986: --- Summary: Unable to build cube for JDBC MS SQL Connection Key: KYLIN-4986 URL: https://issues.apache.org/jira/browse/KYLIN-4986 Project: Kylin Issue Type: Bug

Re: Build cube by JDBC

Hello, Actually the package kap-datasource-adaptor-oracle-11g-1.0.0-SNAPSHOT.jar you download from Kyligence is adapt to Enterprise version, not adapt to Kylin now. Return to your first question: ORA-00911 may caused by the backtick ` You may try your sql without backtick. Thanks,

Re: Build cube by JDBC

Hi, Thanks for your reply. Today I got the oracle jdbc plug-in from kyligence. The kap-datasource-adaptor-oracle-11g-1.0.0-SNAPSHOT.jar. When I use this jar to load data from oracle. Throws another exception. Following is my configuration: kylin.source.default=16

Re: Build cube by JDBC

Hi, Sorry for my late reply. I have reproduced that error, using oracle 11g as data source. First, I met the error " java.sql.SQLSyntaxErrorException: ORA-00911: 无效字符". This can be fixed by adding a configuration in kylin.properties, that is " kylin.source.hive.quote-enabled=false".