(merry Christmas) I found the error: * You can't have the same name column (cod_producto) in Dim Table and Fact Table* ==> ERROR: java.lang.ArrayIndexOutOfBoundsException: -1 (If you don't use this Dim in Cube, don't have any problem) Open JIRA ??
I also discovered: In Data model, you can define the same column from Fact Table as Dim and as Measure Is this the desired behavior ?? Open JIRA ?? 2016-12-23 0:44 GMT+01:00 Alberto Ramón <a.ramonporto...@gmail.com>: > > Error on, Extract Fact Table Distinct Columns > > > > > * Insane record: [1, 0600-160077, FVP DAFUTURO - ESTABLE, COP, 11, 11, > Tipo de producto 11, 16.94579786] java.lang.ArrayIndexOutOfBoundsException: > -1 > at org.apache.kylin.engine.mr > <http://org.apache.kylin.engine.mr>.steps.FactDistinctHiveColumnsMapper.map(FactDistinctHiveColumnsMapper.java:140)* > > > > I see an extra column, ???? My DIM have 7 columns: > > *Original CSV: 7 columns* > [image: Imágenes integradas 3] > > > *On hive: 7 columns* > [image: Imágenes integradas 1] > > > > *On DM: 7 columns*[image: Imágenes integradas 2] > > > > *On Cube: 7 columns* > > "dimensions": [ > { > "name": "ID_PRODUCTO", > "table": "HERR_POSITIONS.DIM_PRODUCTOS", > "column": "ID_PRODUCTO", > "derived": null > }, > { > "name": "COD_PRODUCTO", > "table": "HERR_POSITIONS.DIM_PRODUCTOS", > "column": "COD_PRODUCTO", > "derived": null > }, > { > "name": "PRODUCTO_DESC", > "table": "HERR_POSITIONS.DIM_PRODUCTOS", > "column": "PRODUCTO_DESC", > "derived": null > }, > { > "name": "CURRECY", > "table": "HERR_POSITIONS.DIM_PRODUCTOS", > "column": "CURRENCY", > "derived": null > }, > { > "name": "ISIN", > "table": "HERR_POSITIONS.DIM_PRODUCTOS", > "column": "ISIN", > "derived": null > }, > { > "name": "ID_TIPO_PRODUCTO", > "table": "HERR_POSITIONS.DIM_PRODUCTOS", > "column": "ID_TIPO_PRODUCTO", > "derived": null > }, > { > "name": "TIPO_PRODUCTO_DESC", > "table": "HERR_POSITIONS.DIM_PRODUCTOS", > "column": "TIPO_PRODUCTO_DESC", > "derived": null > } > ], > >
