Moreover would like to add that sometimes I am getting this error in kylin.log,
[http-bio-7070-exec-29]:[2015-06-16 17:46:38,317][ERROR][org.apache.kylin.rest.controller.TableController.cloneTableDesc(TableController.java:172)] - The result cardinality is not identical with hive table metadata, cardinaly : 11050893,3828574,16019,42748,973708,620,281095,1392176,54,31888,2115197,1575939,1422740,2195,7,76,3,35731,5,270 column array length: 54 [http-bio-7070-exec-29]:[2015-06-16 17:46:38,318][INFO][org.apache.kylin.rest.controller.TableController.getHiveTables(TableController.java:74)] - Return all table metadata in 1 seconds [http-bio-7070-exec-29]:[2015-06-16 17:46:39,494][ERROR][org.apache.kylin.rest.controller.TableController.cloneTableDesc(TableController.java:172)] - The result cardinality is not identical with hive table metadata, cardinaly : 11050893,3828574,16019,42748,973708,620,281095,1392176,54,31888,2115197,1575939,1422740,2195,7,76,3,35731,5,270 column array length: 54 Thanks, On Tue, Jun 16, 2015 at 5:45 PM, Vineet Mishra <[email protected]> wrote: > Any update on this? > > URGENT! > > On Tue, Jun 16, 2015 at 4:05 PM, Vineet Mishra <[email protected]> > wrote: > >> Hi All, >> >> While I have build the cube, I am trying to query through the kylin query >> interface but landing up in some error. Stack trace mentioned below, >> >> Query: >> SELECT ft.cc ,ft.sm ,ft.fcc ,ft.fm ,ft.st ,ft.sodp ,ft.lmtdf ,ft.mtdf >> ,ft.modf ,ft.zdf ,ft.odf ,ft.tdf ,ft.gtdf, count(1) as counts FROM >> STAGE.fsc as ft group by ft.cc ,ft.sm ,ft.fcc ,ft.fm ,ft.st ,ft.sodp >> ,ft.lmtdf ,ft.mtdf ,ft.modf ,ft.zdf ,ft.odf ,ft.tdf ,ft.gtdf >> >> Exception: >> org.apache.kylin.query.routing.NoRealizationFoundException: Can't find >> any realization. Please confirm with providers. SQL digest: fact table >> STAGE.fsc,group by [STAGE.fsc.cc, STAGE.fsc.sm, STAGE.fsc.fcc, >> STAGE.fsc.fm, STAGE.fsc.st, STAGE.fsc.sodp, STAGE.fsc.lmtdf, >> STAGE.fsc.mtdf, STAGE.fsc.modf, STAGE.fsc.zdf, STAGE.fsc.odf, >> STAGE.fsc.tdf, STAGE.fsc.gtdf],filter on [],with aggregates[FunctionDesc >> [expression=COUNT, parameter=null, returnType=null]] >> >> Moreover I am referring the code where this error is getting thrown link >> mentioned below, >> >> >> https://github.com/KylinOLAP/Kylin/blob/master/query/src/main/java/org/apache/kylin/query/routing/QueryRouter.java >> >> in the code there's a reference to Project Manager class(as highlighted >> above), I can see the class being instantiated within this class but >> nowhere I can find the definition of Project Manager Class. Is this class >> kept unrevealed in the project. >> >> Awaiting response on priority. >> >> Thanks! >> > >
