页面树结构
转至元数据结尾
转至元数据起始

(此文档仅供参考)

通过数据源的"文件"导出excel文件到高速缓存库中,导入失败,报错如下:

 ERROR service(smartbi.datapackage.DataPackageServlet:109) - ClickHouse exception, code: 62, host: ip, port: 8123; Code: 62, e.displayText() = DB::Exception: Syntax error: failed at position 14: 'smartbimpp'.'testSheet1'('column1' Nullable(String) , 'column2' Nullable(String) , 'column3' Nullable(String) , 'column4' Nullable(String) , 'SPV' Nullable(Str. Expected one of: identifier, IF NOT EXISTS

ru.yandex.clickhouse.except.ClickHouseException: ClickHouse exception, code: 62, host: ip, port: 8123; Code: 62, e.displayText() = DB::Exception: Syntax error: failed at position 14: 'smartbimpp'.'testSheet1'('column1' Nullable(String) , 'column2' Nullable(String) , 'column3' Nullable(String) , 'column4' Nullable(String) , 'SPV' Nullable(Str. Expected one of: identifier, IF NOT EXISTS

	at ru.yandex.clickhouse.except.ClickHouseExceptionSpecifier.specify(ClickHouseExceptionSpecifier.java:58) ~[_JDBC_clickhouse-jdbc-0.1.35.jar:?]
	at ru.yandex.clickhouse.except.ClickHouseExceptionSpecifier.specify(ClickHouseExceptionSpecifier.java:28) ~[_JDBC_clickhouse-jdbc-0.1.35.jar:?]
	at ru.yandex.clickhouse.ClickHouseStatementImpl.getInputStream(ClickHouseStatementImpl.java:528) ~[_JDBC_clickhouse-jdbc-0.1.35.jar:?]
	at ru.yandex.clickhouse.ClickHouseStatementImpl.executeUpdate(ClickHouseStatementImpl.java:156) ~[_JDBC_clickhouse-jdbc-0.1.35.jar:?]
	at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) ~[commons-dbcp-1.4.jar:1.4]
	at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) ~[commons-dbcp-1.4.jar:1.4]
	at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) ~[commons-dbcp-1.4.jar:1.4]
	at smartbi.log.PreparedStatementWarp.executeUpdate(PreparedStatementWarp.java:327) ~[smartbi-Common.jar:?]
	at smartbi.datapackage.importer.BaseImporter.createTableInternal(BaseImporter.java:525) ~[classes/:?]
	at smartbi.datapackage.importer.BaseImporter.createTable(BaseImporter.java:432) ~[classes/:?]
	at smartbi.datapackage.importer.BaseImporter.doImport(BaseImporter.java:161) ~[classes/:?]
	at smartbi.datapackage.service.DataPackageService.insertData(DataPackageService.java:857) ~[classes/:?]
	at smartbi.datapackage.DataPackageServlet.processRequest(DataPackageServlet.java:222) ~[classes/:?]
	at smartbi.datapackage.DataPackageServlet.service(DataPackageServlet.java:106) [classes/:?]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) [servlet-api.jar:?]
	at smartbi.extension.Extension.processMatchServlet(Extension.java:474) [smartbi-ExtensionManager.jar:?]
	at smartbi.extension.ExtensionFilter.processInternal(ExtensionFilter.java:229) [smartbi-ExtensionManager.jar:?]
	at smartbi.extension.ExtensionFilter.access$000(ExtensionFilter.java:47) [smartbi-ExtensionManager.jar:?]
	at smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilter.java:168) [smartbi-ExtensionManager.jar:?]
	at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:158) [smartbi-ExtensionManager.jar:?]
	at smartbi.framework.rmi.TransactionFilter.doFilter(Smartbi:50) [smartbi-Framework.jar:?]
	at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:158) [smartbi-ExtensionManager.jar:?]
	at smartbi.security.patch.PatchFilter.doFilter(PatchFilter.java:73) [classes/:?]
	at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:158) [smartbi-ExtensionManager.jar:?]
	at smartbi.dingding.filter.DDLoginFilter.doFilter(DDLoginFilter.java:119) [classes/:?]
	at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:158) [smartbi-ExtensionManager.jar:?]
	at smartbi.extension.ExtensionFilter.doFilterInternal(ExtensionFilter.java:189) [smartbi-ExtensionManager.jar:?]
	at smartbi.extension.ExtensionFilter.doFilter(ExtensionFilter.java:70) [smartbi-ExtensionManager.jar:?]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.57]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.57]
	at smartbi.freequery.filter.TraceFilter.doFilter(TraceFilter.java:61) [smartbi-FreeQuery.jar:?]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.57]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.57]
	at smartbi.framework.RedisSessionFilter.doFilter(Smartbi:125) [smartbi-Framework.jar:?]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.57]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.57]
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) [catalina.jar:8.5.57]
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [catalina.jar:8.5.57]
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543) [catalina.jar:8.5.57]
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [catalina.jar:8.5.57]
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) [catalina.jar:8.5.57]
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690) [catalina.jar:8.5.57]
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) [catalina.jar:8.5.57]
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [catalina.jar:8.5.57]
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:615) [tomcat-coyote.jar:8.5.57]
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote.jar:8.5.57]
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:818) [tomcat-coyote.jar:8.5.57]
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1626) [tomcat-coyote.jar:8.5.57]
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:8.5.57]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_191]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_191]
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:8.5.57]
	at java.lang.Thread.run(Thread.java:748) [?:1.8.0_191]
Caused by: java.lang.Throwable: Code: 62, e.displayText() = DB::Exception: Syntax error: failed at position 14: 'smartbimpp'.'testSheet1'('column1' Nullable(String) , 'column2' Nullable(String) , 'column3' Nullable(String) , 'column4' Nullable(String) , 'SPV' Nullable(Str. Expected one of: identifier, IF NOT EXISTS

	at ru.yandex.clickhouse.except.ClickHouseExceptionSpecifier.specify(ClickHouseExceptionSpecifier.java:53) ~[_JDBC_clickhouse-jdbc-0.1.35.jar:?]
	... 52 more


解决方案:

此问题是由于高速缓存库中引用标识符设置为 ' ,执行SQL评价为'smartbimpp'.'表名',clickhouse不支持这种语法出现报错,可修改为 ` ,如下图。



  • 无标签