THank you. This worked. We need to explicitly mention Join type. However,
When I ran the query I got below exception. Could you please let me know
what could be the cause of it?
Query:
select PRODUCT_DIM.PRODUCT_DESC,TIME.CAL_MONTH_YEAR_DESC
from FACT
INNER JOIN TIME ON FACT.TIME_DIM_ID=TIME.TIME_DIM_ID
INNER JOIN PRODUCT_DIM ON PRODUCT_DIM.PRODUCT_DIM_ID=FACT.PRODUCT_DIM_ID
group by PRODUCT_DIM.PRODUCT_DESC,TIME.CAL_MONTH_YEAR_DESC
order by sum(FACT.amt) desc limit 10
;
Exception:
Caused by: java.lang.ArrayIndexOutOfBoundsException: 4
at
org.apache.kylin.cube.gridtable.CubeCodeSystem.codeLength(CubeCodeSystem.java:100)
at
org.apache.kylin.gridtable.GTRecord.loadColumns(GTRecord.java:279)
at
org.apache.kylin.storage.hbase.cube.v2.HBaseReadonlyStore$1$1.next(HBaseReadonlyStore.java:135)
at
org.apache.kylin.storage.hbase.cube.v2.HBaseReadonlyStore$1$1.next(HBaseReadonlyStore.java:101)
at
org.apache.kylin.storage.hbase.cube.v2.coprocessor.endpoint.CubeVisitService.visitCube(CubeVisitService.java:329)
at
org.apache.kylin.storage.hbase.cube.v2.coprocessor.endpoint.generated.CubeVisitProtos$CubeVisitService.callMethod(CubeVisitProtos.java:5555)
at
org.apache.hadoop.hbase.regionserver.HRegion.execService(HRegion.java:8065)
at
org.apache.hadoop.hbase.regionserver.RSRpcServices.execServiceOnRegion(RSRpcServices.java:2426)
at
org.apache.hadoop.hbase.regionserver.RSRpcServices.execService(RSRpcServices.java:2408)
at
org.apache.hadoop.hbase.shaded.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:42010)
at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:413)
... 3 more
--
Sent from: http://apache-kylin.74782.x6.nabble.com/
