kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Niasari, Mehrdad" <mehrdad.nias...@rbc.com>
Subject RE: Empty Cube
Date Thu, 01 Sep 2016 17:34:16 GMT
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:shaofengshi@apache.org]
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 <mehrdad.niasari@rbc.com<mailto:mehrdad.niasari@rbc.com>>:
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.
Mime
View raw message