Hi,
I have replaced (not updated) Kylin 1.6 for Kylin 2.1. I created a cube
(and also underlying model) with the same sources and metadata that I
have used for the same I previously implementend on Kylin 1.6. The cube
construcction was Ok. However, some strange occurs with join queries.
The following query goes
/F_RENDIMIENTO is the fact table and //D_CURSO_ACADEMICO_VK is a
dimension table:
/
/select D_CURSO_ACADEMICO_VK.ID_CURSO_ACADEMICO, sum(CREDITOS)/
/from F_RENDIMIENTO JOIN D_CURSO_ACADEMICO_VK ON
F_RENDIMIENTO.ID_CURSO_ACADEMICO =
D_CURSO_ACADEMICO_VK.ID_CURSO_ACADEMICO/
/group by D_CURSO_ACADEMICO_VK.ID_CURSO_ACADEMICO/
But susprisingly if I change the INNER JOIN order the following query
does not go
/select D_CURSO_ACADEMICO_VK.ID_CURSO_ACADEMICO, sum(CREDITOS)//
//from D_CURSO_ACADEMICO_VK JOIN F_RENDIMIENTO ON
F_RENDIMIENTO.ID_CURSO_ACADEMICO =
D_CURSO_ACADEMICO_VK.ID_CURSO_ACADEMICO//
//group by D_CURSO_ACADEMICO_VK.ID_CURSO_ACADEMICO/
/Error while executing SQL "select
D_CURSO_ACADEMICO_VK.ID_CURSO_ACADEMICO, sum(CREDITOS) from
D_CURSO_ACADEMICO_VK JOIN F_RENDIMIENTO ON
F_RENDIMIENTO.ID_CURSO_ACADEMICO =
D_CURSO_ACADEMICO_VK.ID_CURSO_ACADEMICO group by
D_CURSO_ACADEMICO_VK.ID_CURSO_ACADEMICO LIMIT 50000": No realization
found for rel#7393:OLAPTableScan.OLAP.[](table=[DM_ACAD_KYLIN_ORC,
D_CURSO_ACADEMICO_VK],fields=[0, 1]), JoinDesc [type=INNER,
primary_key=[ID_CURSO_ACADEMICO], foreign_key=[ID_CURSO_ACADEMICO]]/
This does not happend with the same cube implemented using Kylin 1.6.
Why does this happen?
Maybe is related to the new snowflake schema support. I used I a star
schema and I defined the INNER JOIN as I show in the next picture
Maybe I have to add a second explicit JOIN between D_CURSO_ACADEMICO -->
F_RENDIMIENTO, i.e, the inverted join.
Regards,
Roberto
--
*Roberto Tardío Olmos*
/Senior Big Data & Business Intelligence Consultant/
Avenida de Brasil, 17, Planta 16.28020 Madrid
Fijo: 91.788.34.10
