smartbix.SmartbiXException: SQL错误: insert into `smartbimpp`.`I8aaa81f9018720bd20bd143c0187271b83360fd3_temp` select `column1` as `column1`, `column2` as `column2`, toString(toYear( toDate(`T0`.`column2`) )) || '-' || if(toMonth(toDate(`T0`.`column2`)) < 10, '0' || toString(toMonth(toDate(`T0`.`column2`))), toString(toMonth(toDate(`T0`.`column2`)))) || '-' || if(toDayOfMonth( toDate(`T0`.`column2`) ) < 10, '0' || toString(toDayOfMonth( toDate(`T0`.`column2`) )), toString(toDayOfMonth( toDate(`T0`.`column2`) ))) as `column2_Day`, toString(toYear( toDate(`T0`.`column2`) )) || '-' || if(toMonth(toDate(`T0`.`column2`)) < 10, '0' || toString(toMonth(toDate(`T0`.`column2`))), toString(toMonth(toDate(`T0`.`column2`)))) as `column2_Month`, toString(toYear( toDate(`T0`.`column2`) )) as `column2_Year`, `column3` as `column3`, `column4` as `column4`, `column5` as `column5`, `column6` as `column6`, `column7` as `column7`, `column8` as `column8`, `column9` as `column9`, `column10` as `column10`, `column11` as `column11`, `column12` as `column12`, `column13` as `column13`, `column14` as `column14`, `column15` as `column15`, `column16` as `column16`, `column17` as `column17`, `column18` as `column18`, `T0`.`viewId` as `viewId` from (select `sdpkgb20bb42b001872714f0a97ec0`.`column1` as `column1`, `sdpkgb20bb42b001872714f0a97ec0`.`column2` as `column2`, `sdpkgb20bb42b001872714f0a97ec0`.`column3` as `column3`, `sdpkgb20bb42b001872714f0a97ec0`.`column4` as `column4`, `sdpkgb20bb42b001872714f0a97ec0`.`column5` as `column5`, `sdpkgb20bb42b001872714f0a97ec0`.`column6` as `column6`, `sdpkgb20bb42b001872714f0a97ec0`.`column7` as `column7`, `sdpkgb20bb42b001872714f0a97ec0`.`column8` as `column8`, `sdpkgb20bb42b001872714f0a97ec0`.`column9` as `column9`, `sdpkgb20bb42b001872714f0a97ec0`.`column10` as `column10`, `sdpkgb20bb42b001872714f0a97ec0`.`column11` as `column11`, `sdpkgb20bb42b001872714f0a97ec0`.`column12` as `column12`, `sdpkgb20bb42b001872714f0a97ec0`.`column13` as `column13`, `sdpkgb20bb42b001872714f0a97ec0`.`column14` as `column14`, `sdpkgb20bb42b001872714f0a97ec0`.`column15` as `column15`, `sdpkgb20bb42b001872714f0a97ec0`.`column16` as `column16`, `sdpkgb20bb42b001872714f0a97ec0`.`column17` as `column17`, `sdpkgb20bb42b001872714f0a97ec0`.`column18` as `column18`, '订单' as `viewId` from `smartbimpp`.`sdpkgb20bb42b001872714f0a97ec0` `sdpkgb20bb42b001872714f0a97ec0`)`T0` -> ClickHouse exception, code: 60, host: 172.17.11.220, port: 31823; Code: 60, e.displayText() = DB::Exception: Table smartbimpp.sdpkgb20bb42b001872714f0a97ec0 doesn't exist (version 21.6.6.51 (official build)) at smartbix.SmartbiXException.create(SmartbiXException.java:68) at smartbix.smartbi.service.GridDataServiceHandler.handle(GridDataServiceHandler.java:118) at sun.reflect.GeneratedMethodAccessor1167.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at smartbixlibs.org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:634) at smartbixlibs.org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:624) at smartbixlibs.org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:72) at smartbixlibs.org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) at smartbixlibs.org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97) at smartbixlibs.org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708) at smartbix.dataprocess.service.DatabaseResultService$$EnhancerBySpringCGLIB$$3eed19b4.executeUpdateSql() at smartbix.augmenteddataset.repository.service.AugmentedDatabaseResultService.executeUpdateSql(AugmentedDatabaseResultService.java:137) at smartbix.augmenteddataset.extract.AugmentedMppLoadService.loadData(AugmentedMppLoadService.java:196) at smartbix.augmenteddataset.extract.SingleThreadedExtractor$1.call(SingleThreadedExtractor.java:308) at smartbix.augmenteddataset.extract.SingleThreadedExtractor$1.call(SingleThreadedExtractor.java:246) at smartbix.augmenteddataset.extract.ExtractTaskWrapper.call(ExtractTaskWrapper.java:40) at smartbix.util.ThreadUtil$SubmitRunnable.call(ThreadUtil.java:220) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: ru.yandex.clickhouse.except.ClickHouseException: ClickHouse exception, code: 60, host: 172.17.11.220, port: 31823; Code: 60, e.displayText() = DB::Exception: Table smartbimpp.sdpkgb20bb42b001872714f0a97ec0 doesn't exist (version 21.6.6.51 (official build)) at ru.yandex.clickhouse.except.ClickHouseExceptionSpecifier.specify(ClickHouseExceptionSpecifier.java:59) at ru.yandex.clickhouse.except.ClickHouseExceptionSpecifier.specify(ClickHouseExceptionSpecifier.java:29) at ru.yandex.clickhouse.ClickHouseStatementImpl.checkForErrorAndThrow(ClickHouseStatementImpl.java:1099) at ru.yandex.clickhouse.ClickHouseStatementImpl.getInputStream(ClickHouseStatementImpl.java:778) at ru.yandex.clickhouse.ClickHouseStatementImpl.getLastInputStream(ClickHouseStatementImpl.java:692) at ru.yandex.clickhouse.ClickHouseStatementImpl.executeUpdate(ClickHouseStatementImpl.java:434) at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) at smartbix.dataprocess.service.DatabaseResultService.executeUpdateSql(DatabaseResultService.java:545) at smartbix.dataprocess.service.DatabaseResultService$$FastClassBySpringCGLIB$$7e915f15.invoke() at smartbixlibs.org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793) at smartbixlibs.org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at smartbixlibs.org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) at smartbixlibs.org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:102) at smartbix.smartbi.service.GridDataServiceHandler.handle(GridDataServiceHandler.java:93) ... 23 more Caused by: java.lang.Throwable: Code: 60, e.displayText() = DB::Exception: Table smartbimpp.sdpkgb20bb42b001872714f0a97ec0 doesn't exist (version 21.6.6.51 (official build)) at ru.yandex.clickhouse.except.ClickHouseExceptionSpecifier.specify(ClickHouseExceptionSpecifier.java:54) ... 39 more