ok; The table "kylin_sales" contains data for 2012 and 2013, so need make sure the build range covers these years; please have a check and I guess it is some minor mistake; BTW, empty cube will return zero since it doesn't have data.
2016-09-02 1:34 GMT+08:00 Niasari, Mehrdad <[email protected]>: > Thanks for the reply. > > > > There is no error in the log. Also I checked the hive tables and they are > not empty; I can run any query on them using Hue and work well. > > > > Also the size of cube in the cubes section in 0.00KB! But even with an > empty cube the result of queries on the tables should not be empty/zero, > right? > > Any other suggestion how to debug it? > > > > Thanks, > > Mehrdad > > > > *From:* ShaoFeng Shi [mailto:[email protected]] > *Sent:* 2016, August, 31 9:04 PM > *To:* user > *Subject:* Re: Empty Cube > > > > Hi Mehrdad, > > > > When you run the query, is there any error reported in the logs/kylin.log? > > > > If no error, please check whether the source hive table has data, you can > do this easily in hive, by running HQL "select * from default.kylin_sales > limit 100"; it is very likely that the "sample.sh" failed to upload the > file; if it is this case, you may need manually import the data files > (sample_cube/data) to hive; > > > > 2016-09-01 4:06 GMT+08:00 Niasari, Mehrdad <[email protected]>: > > Hi All, > > > > When I run the sample cube of Kylin the result is empty, i.e. the cube is > computed successfully, the status is ready but nothing is in the cube and > every query gets zero. > > Do you have any suggestion what can cause the problem? > > How should I debug it? > > > > Thanks, > > Mehrdad > > > > > > _______________________________________________________________________ > > If you received this email in error, please advise the sender (by return > email or otherwise) immediately. You have consented to receive the attached > electronically at the above-noted email address; please retain a copy of > this confirmation for future reference. > > Si vous recevez ce courriel par erreur, veuillez en aviser l'expéditeur > immédiatement, par retour de courriel ou par un autre moyen. Vous avez > accepté de recevoir le(s) document(s) ci-joint(s) par voie électronique à > l'adresse courriel indiquée ci-dessus; veuillez conserver une copie de > cette confirmation pour les fins de reference future. > > > > > > -- > > Best regards, > > > > Shaofeng Shi > > > > _______________________________________________________________________ > > If you received this email in error, please advise the sender (by return > email or otherwise) immediately. You have consented to receive the attached > electronically at the above-noted email address; please retain a copy of > this confirmation for future reference. > > Si vous recevez ce courriel par erreur, veuillez en aviser l'expéditeur > immédiatement, par retour de courriel ou par un autre moyen. Vous avez > accepté de recevoir le(s) document(s) ci-joint(s) par voie électronique à > l'adresse courriel indiquée ci-dessus; veuillez conserver une copie de > cette confirmation pour les fins de reference future. > > -- Best regards, Shaofeng Shi
