Hi clude, Is there "Derived" dimension in your cube? The derived dimension need a snapshot of the lookup table to do the "mapping". If the snapshot is absent, such an error is reported. Please create a new cube without "Derived" (select "Normal"), and then try again.
2017-10-17 14:06 GMT+08:00 cludezhu <[email protected]>: > Hi all, > > we met an issue on lookup table snapshot option. > > 1. we created a model with a lookup table which unchecked the snapshot > option. > > 2. then we create and build the cube base on this model, every thing is ok. > > but when we try to join this lookup table do query the data, we met some > issue, seems KYLIN still try to find the sanpshot table: > > "No snaphot for table 'SENSE.CUSTOMER_PORTRAIT_PRICE_ZONE' found on cube > segmentc_customer_portrait/c_customer_portrait[20171001000000_20171010000000] > while executing “ > > this issue occurs on KYLIN VERSION: 2.10, 2.2.0-SNAPSHOT > > PS: our kylin is deployed on write-read mode ( one hadoop cluster for > building cube, one hbase cluster for storing data) > > any help is appreciate, thanks > > -- > cludezhu > Sent with Airmail -- Best regards, Shaofeng Shi 史少锋
