You could ignore the errors, the errors said Tableau tried to create temporary table in Kylin, but Kylin is read-only system. So "Not Support SQL" is the right message.
As I said, Tableau was not only loading metadata which was only 18M, but also issued "select * from fact table" which may be billions rows. 2017-07-20 10:07 GMT+08:00 shendandan <[email protected]>: > Hi,all > Can anyone help me answer my question? > I can use tableau normally after loading the metadate, but why are > there so many errors in kylin.log when tableau loads metadata? > > Thanks, > Dandan > > > > > At 2017-07-19 10:11:52, "沈丹丹" <[email protected]> wrote: > > But the metadata is only 18M, why does it cost much resources. > And there are many errors in kylin.log when tableau loads the metadata. > > 2017-07-19 09:34:48,415 INFO [Query d1337b1e-3635-467e-8919-88797bb33965-54] > service.QueryService:338 : Using project: bind_financial_manager > 2017-07-19 09:34:48,423 INFO [Query d1337b1e-3635-467e-8919-88797bb33965-54] > service.QueryService:339 : The original query: CREATE LOCAL TEMPORARY > TABLE "XTB_EDEBFDEA_ACCJ_EFFB_ACDE_ADECHDECADE_Connect" ( "COL" INTEGER > ) ON COMMIT PRESERVE ROWS > 2017-07-19 09:34:48,423 DEBUG [Query d1337b1e-3635-467e-8919-88797bb33965-54] > service.QueryService:342 : Directly return exception as not supported > 2017-07-19 09:34:48,424 ERROR [http-bio-7070-exec-6] > controller.BasicController:44 : > org.apache.kylin.rest.exception.InternalErrorException: Not Supported SQL. > at org.apache.kylin.rest.service.QueryService.doQueryWithCache( > QueryService.java:343) > at org.apache.kylin.rest.controller.QueryController. > query(QueryController.java:69) > at sun.reflect.GeneratedMethodAccessor123.invoke(Unknown Source) > at sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:606) > at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke( > InvocableHandlerMethod.java:221) > ... > ... > > For more details,please open the attachment. > > Thank you very much! > > > > > > > 在 2017-07-19 09:36:05，"Billy Liu" <[email protected]> 写道： > >The root cause is Tableau sends out “select * ” to Kylin which costs much > >resource. > > > >在 2017年7月18日 下午5:51，沈丹丹 <[email protected]>写道： > > > >> yes， I use the live model. > >> > >> > >> > >> > >> > >> > >> > >> > >> 在 2017-07-18 17:25:48，"Billy Liu" <[email protected]> 写道： > >> >Did you use Tableau Live mode? > >> > > >> >在 2017年7月18日 下午2:59，沈丹丹 <[email protected]>写道： > >> > > >> >> > >> >> > >> >> > >> >> Thank you. But the SQL is automatically generated when tableau loads > >> >> metadata, but it not supported. And I can't control it. > >> >> > >> >> > >> >> > >> >> > >> >> > >> >> 在 2017-07-18 14:45:08，"江昆" <[email protected]> 写道： > >> >> >because the sql parser of kylin is calcite,it is different from sql > >> which > >> >> we offen use...you could use your sql in kylin web > >> application-insight,you > >> >> could try then you know what sql could pass or not...good luck... > >> >> > > >> >> > > >> >> > > >> >> > > >> >> >------------------ 原始邮件 ------------------ > >> >> >发件人: "沈丹丹";<[email protected]>; > >> >> >发送时间: 2017年7月18日(星期二) 下午2:39 > >> >> >收件人: "dev"<[email protected]>; > >> >> > > >> >> >主题: 技术求助 > >> >> > > >> >> > > >> >> > > >> >> >大家好： > >> >> > 我在使用kylin整合tableau的时候遇到一些问题，我不知道如何解决，希望能得到你们的帮助。 > >> >> 我使用的是kylin1.6版本，jdk1.7版本的，结合tableau9.0使用，但是在tableau加载kylin元数据的时候每次都会花费1 > >> >> 0分钟左右，并且内存狂飙至99%导致电脑会卡住一段时间。但是元数据很小，才18M左右。请问这是为什么？ > >> 而且看kylin.log文件，里面会报很多Not > >> >> Supported SQL 错误，这个该怎么解决呢？（ps，附件是tableau加载kylin元数据时kylin.log日志文件） > >> >> > 盼回复！谢谢！ > >> >> > >> > > > > > > > > >
