Re: corrupt metastore

2016-12-01 Thread Alberto Ramón
yes, yes, I had this type of problems, I needed used hdfs fsck hbase hbck And solved all problems. --> pehaps some data has been lost The nex steps will be: - check metadata of Kylin - check consistence between metadata and Kylin's tables But I don't know if there is some tools/commands to

Re: corrupt metastore

2016-12-01 Thread ShaoFeng Shi
Hi Alberto, It looks like the HBase service is in trouble, please check it firstly; 2016-12-02 8:03 GMT+08:00 Alberto Ramón : > I had some problems with corrupt data on HDFS and Meta HDFS > Now all services started OK > > *None query is excuted in none cube * > *Error while executing SQL "select

corrupt metastore

2016-12-01 Thread Alberto Ramón
I had some problems with corrupt data on HDFS and Meta HDFS Now all services started OK *None query is excuted in none cube * *Error while executing SQL "select part_dt, sum(price) as total_selled, count(distinct seller_id) as sellers from kylin_sales group by part_dt order by part_dt LIMIT 5"

Re: Consulting "EXTENDED_COLUMN"

2016-12-01 Thread Alberto Ramón
Nice Liu We have some cases like DayWeekTXT , DayWeekID MonthTXT, MonthID small proposal: Can would be interesting create Derived with 1:1 relation, with support for filters and Group by 2016-12-01 11:55 GMT+01:00 Billy(Yiming) Liu : > The cost of joint dimension compared with extended column i

Re: User MailList

2016-12-01 Thread ShaoFeng Shi
It is pending on me; I have created an archive for user@ in nabble.com, but need some hacky way to add the nabble's robot email to apache's subscription list. 2016-12-01 20:31 GMT+08:00 Luke Han : > already working on that > > Get Outlook for iOS > > > > > On Thu, Dec 1, 2

Re: User MailList

2016-12-01 Thread Alberto Ramón
Nice ¡¡ Will be very helpfull to find similar problems 2016-12-01 13:31 GMT+01:00 Luke Han : > already working on that > > Get Outlook for iOS > > > > > On Thu, Dec 1, 2016 at 5:15 PM +0800, "Alberto Ramón" < > a.ramonporto...@gmail.com> wrote: > > Small Proposal: >> >> De

Re: User MailList

2016-12-01 Thread Luke Han
already working on that Get Outlook for iOS On Thu, Dec 1, 2016 at 5:15 PM +0800, "Alberto Ramón" wrote: Small Proposal: Dev mailList is in Nabble (more practical than mail-archives.apache.org: You can find by txt, see pictures and more readable) Is it possible make the same wit

Re: Consulting "EXTENDED_COLUMN"

2016-12-01 Thread Billy(Yiming) Liu
The cost of joint dimension compared with extended column is you have more columns in the HBase rowkey. It may harm the query performance. But most time, joint dimension is still recommended, since the normal dimension column supports much more functions than extended column, such as count(*). 201

User MailList

2016-12-01 Thread Alberto Ramón
Small Proposal: Dev mailList is in Nabble (more practical than mail-archives.apache.org: You can find by txt, see pictures and more readable) Is it possible make the same with UserList ? (nowadays, a lot of user's doubts are in Dev MailList or in both)

Re: Consulting "EXTENDED_COLUMN"

2016-12-01 Thread Alberto Ramón
Hello I was preparing a email with related doubts: Some times we have derived dimensions with relation 1:1, examples: WeekDayID & WeekDayTxt MonthID & WeekTxt SOL1: Derived. ID as Host and Txt Extended PB: You can't filter / Group by Txt SOL2: Joint. Define tuples of ID & TXT Some PB/limitation