The range is up to 2015 and that’s not the problem. The only query that doesn’t return zero/empty result is from table kylin_cal_dt. When I delete this table from hive, still the result is not empty and Kylin doesn’t complain! Where does Kylin bring the data of this table even when it’s not on hive? Also I checked the cube itself on Hbase and it’s empty. Any other suggestion? Can it be because of some wrong configuration in connecting Kylin to Hive/Hbase? If that’s the case why it can create the cube successfully?
Also I have a question regarding uuid. What is this for? I’m asking this cause I cannot fully understand that why you have used a fixed value in sample cube json files (for example for kylin_sales_cube uuid is: “2fbca32a-a33e-4b69-83dd-0bb8b1f8c53b”). How come it doesn’t conflict if you run the sample cube multiple times? Thanks, Mehrdad From: ShaoFeng Shi [mailto:[email protected]] Sent: 2016, September, 01 9:01 PM To: user Subject: Re: Empty Cube 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]<mailto:[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]<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]<mailto:[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 _______________________________________________________________________ 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.
