Problem solved. After restoring ,I have to purge the cube first.
2015-05-14 14:29 GMT+08:00 Tao Wong <[email protected]>: > Hi,shaofeng > > nice job ! > the table appears. > > but i still couldn't run SQL query after cube be refreshed. > > ==========================[QUERY]=============================== > SQL: select dt user_fact where province_id<>-1 and city_type_id<>-1 and > city_id<>-1 group by dt > User: ADMIN > Success: false > Duration: 0.002 > Project: user > Realization Names: [] > Cuboid Ids: [] > Total scan count: 0 > Result row count: 0 > Accept Partial: true > Is Partial Result: false > Hit Cache: true > Message: exception while executing query: Error when scan from lower key > ^@^@^@^@^@^@^@^O^@^@^@^@ to upper key ^@^@^@^@^@^@^@^O����^@ on > table KYLIN_1BH1WBQ2ZE. > > 2015-05-13 10:53 GMT+08:00 Tao Wong <[email protected]>: > >> YES.Also CDH env.but its version is 5.3.X >> we are cautious with restore operation as the machines deploied CDH 5.3.X >> are on-line. >> >> 2015-05-13 10:44 GMT+08:00 ShaoFeng Shi <[email protected]>: >> >>> BTW, which env did you migrate the metadata/cubes to this CDH env? Is it >>> also CDH or other hadoop env? Does it have the same issue there? >>> >>> 2015-05-13 10:43 GMT+08:00 ShaoFeng Shi <[email protected]>: >>> >>> > okay get it; please watch >>> https://issues.apache.org/jira/browse/KYLIN-761 >>> > for any update; I'm setting up a CDH environment to check this. >>> > >>> > 2015-05-13 10:39 GMT+08:00 Tao Wong <[email protected]>: >>> > >>> >> *are you running Kylin on CDH? * >>> >> YES. we are running kylin on CDH 5.4.x >>> >> >>> >> *What's the status of the cubes after "refresh the cube successfully" >>> ?* >>> >> actually,i backup the metadata from one kylin system and restore it on >>> >> another one. >>> >> after i restore the metadata,the status of cubes in the "Cubes" Tab >>> are >>> >> all >>> >> "READY". >>> >> refresh does not change its status. >>> >> >>> >> * Is there any error in kylin.log when "can not do the query >>> operation"?* >>> >> >>> >> User: ADMIN >>> >> Success: false >>> >> Duration: 0.001 >>> >> Project: ProjectName >>> >> Realization Names: [] >>> >> Cuboid Ids: [] >>> >> Total scan count: 0 >>> >> Result row count: 0 >>> >> Accept Partial: true >>> >> Is Partial Result: false >>> >> Hit Cache: true >>> >> Message: Error instantiating JsonCustomSchema(name=ProjectName) >>> >> >>> >> >>> >> 2015-05-13 9:41 GMT+08:00 ShaoFeng Shi <[email protected]>: >>> >> >>> >> > Tao, are you running Kylin on CDH? What's the status of the cubes >>> after >>> >> > "refresh the cube successfully"? Is there any error in kylin.log >>> when >>> >> "can >>> >> > not do the query operation"? >>> >> > >>> >> > 2015-05-12 18:46 GMT+08:00 Tao Wong <[email protected]>: >>> >> > >>> >> > > BTW: >>> >> > > >>> >> > > after restoring the metadata ,i can resresh the cube successfully. >>> >> > > but with no tables, i can not do the query operation. >>> >> > > >>> >> > > 2015-05-12 18:38 GMT+08:00 Tao Wong <[email protected]>: >>> >> > > >>> >> > > > Hi, >>> >> > > > I backup and restore the metadata to do some test. >>> >> > > > The cubes demostrate as expected ,but no tables shows in "Query" >>> >> tap. >>> >> > > > >>> >> > > > >>> >> > > > >>> >> > > >>> >> > >>> >> >>> > >>> > >>> >> >> >
