it does not matter which type you are using, just the limit of lookup table, because kylin will store snapshot table in memory, table size need to consider.
2016-02-15 11:14 GMT+08:00 热爱大发挥 <385639...@qq.com>: > this error only happen on left join? > > > ------------------ 原始邮件 ------------------ > *发件人:* "yu feng"<olaptes...@gmail.com>; > *发送时间:* 2016年2月15日(星期一) 中午11:10 > *收件人:* "user"<user@kylin.apache.org>; > *主题:* Re: about "Table snapshot size limit" > > kylin.table.snapshot.max_mb is the max size of files that the lookup table > location, you can increase the config value and skip the error. > > 2016-02-15 9:42 GMT+08:00 热爱大发挥 <385639...@qq.com>: > >> I do not understand why limit the size of the table 300MB, I think 300MB >> is too small, Can you explain this parameter "kylin.table.snapshot.max_mb" >> >> java.lang.IllegalStateException: Table snapshot should be no greater than >> 300 MB, but TableDesc [database=DEFAULT name=USER_PROFILE_NEW] size is >> 6620759443 >> at >> org.apache.kylin.dict.lookup.SnapshotManager.buildSnapshot(SnapshotManager.java:95) >> at >> org.apache.kylin.cube.CubeManager.buildSnapshotTable(CubeManager.java:205) >> > >