Oh，I see. Thank you,Billy .
At 2017-07-20 11:45:52, "Billy Liu" <[email protected]> wrote: >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日志文件） >> >> >> > 盼回复！谢谢！ >> >> >> >> >> >> >> >> >> >> >> >> >> >>
