Finally successfully created cube,and quried data also.i observed some difference in duration between hive and kylin.
Here I have some questions. 1)after cube build ,cube size showing 1kb only.wheere data will be sit after cube build means does it is not stored in cube? 2)after cube build, when we queried data, where it will retrieving data like from tables or cube? If tables, what is the use of building cube?(In BI, after cube processing data will be stored in cube only like aggregate data, in kylin it is not showing cube size) 3)i need small code,how to call to kylin cubes in asp.net? I tried some blogs, did not understand. Please give me sample code. -----Original Message----- From: Jian Zhong [mailto:[email protected]] Sent: Wednesday, November 11, 2015 8:12 AM To: [email protected] Subject: Re: Refresh setting tab you need to build your cube first, when cube is enable you can query.when disable, you can't query. if you never build your cube successfully, you can't enable your cube. about how to build cube check this http://kylin.incubator.apache.org/docs/tutorial/cube_build_job.html On Wed, Nov 11, 2015 at 4:03 AM, Indiradevi Gorijavolu < [email protected]> wrote: > I am successfully create job.but status is disable.does we need to > enable cube or not required? > > When I enableing cube,I am getting some errors.please find attachehment. > > After cube build, do we need to run jobs also or not required? > > Please give me some guidense. > > -----Original Message----- > From: Indiradevi Gorijavolu [mailto:[email protected]] > Sent: Tuesday, November 10, 2015 5:39 PM > To: [email protected] > Subject: RE: Refresh setting tab > > I am successfully create cube. But this cube status is in diasable.i > tried to enable, it is not enabling. > > Please suggest me, what I am doing wrong? > > > > -----Original Message----- > From: Luke Han [mailto:[email protected]] > Sent: Monday, November 09, 2015 7:55 PM > To: [email protected] > Subject: Re: Refresh setting tab > > Change those column's data type to same. > > > Best Regards! > --------------------- > > Luke Han > > On Mon, Nov 9, 2015 at 5:44 PM, Indiradevi Gorijavolu < > [email protected]> wrote: > > > I downloaded v1.1 version. Now I am getting below error. What I did > > wrong ,please suggest me. > > > > > > Error Message > > > > Primary key DEFAULT.DIMEMP.EMPLOYEEKEY.tinyint are not consistent > > with Foreign key DEFAULT.FACTSALESQUOTA.EMPLOYEEKEY.smallint > > > > -----Original Message----- > > From: Shaofeng Shi [mailto:[email protected]] > > Sent: Sunday, November 08, 2015 8:11 PM > > To: [email protected] > > Subject: RE: Refresh setting tab > > > > please download v1.1 and try again > > > > Indiradevi Gorijavolu <[email protected]>编写： > > > > >Kylin version is apache kylin 1.0,browser is firefox 38.0.1. > > > > > >-----Original Message----- > > >From: ShaoFeng Shi [mailto:[email protected]] > > >Sent: Sunday, November 08, 2015 6:21 AM > > >To: [email protected] > > >Subject: Re: Refresh setting tab > > > > > >what's your kylin version and browser version? from the screenshot > > >I see > > there is JS error, looks like browser compatible issue. > > > > > >2015-11-08 8:36 GMT+08:00 Luke Han <[email protected]>: > > > > > >> Well, have you tried here? > > >> > > >> http://kylin.incubator.apache.org/docs/ > > >> > > >> Thanks. > > >> > > >> > > >> Best Regards! > > >> --------------------- > > >> > > >> Luke Han > > >> > > >> On Sun, Nov 8, 2015 at 3:00 AM, Indiradevi Gorijavolu < > > >> [email protected]> wrote: > > >> > > >> > I tried with without lookup table,but same thing is happing. > > >> > > > >> > Do you have any documents step by step for creating cubes? > > >> > if you have please share me. > > >> > > > >> > > > >> > -----Original Message----- > > >> > From: yu feng [mailto:[email protected]] > > >> > Sent: Saturday, November 07, 2015 4:44 PM > > >> > To: [email protected] > > >> > Subject: Re: Refresh setting tab > > >> > > > >> > I do not know the problem about the button disable, but I > > >> > always build cube without any lookup table, all dimensions and > > >> > measures are in one table, It can works... > > >> > > > >> > 2015-11-07 17:08 GMT+08:00, Indiradevi Gorijavolu < > > >> [email protected] > > >> > >: > > >> > > I added one dimensation in dimensation tab,still refresh > > >> > >settings tab in next button is not enabled. > > >> > > > > >> > > Here I got one question.in datamodel tab ,is it mandatory to > > >> > > add lookup table? > > >> > > > > >> > > Please find attached screenshot. > > >> > > > > >> > > > > >> > > -----Original Message----- > > >> > > From: Luke Han [mailto:[email protected]] > > >> > > Sent: Friday, November 06, 2015 8:07 PM > > >> > > To: [email protected] > > >> > > Subject: Re: Refresh setting tab > > >> > > > > >> > > Please send screenshot as attachment, we can't see it > > >> > > directly from > > >> mail. > > >> > > > > >> > > Thanks. > > >> > > > > >> > > > > >> > > Best Regards! > > >> > > --------------------- > > >> > > > > >> > > Luke Han > > >> > > > > >> > > On Fri, Nov 6, 2015 at 9:54 PM, Indiradevi Gorijavolu < > > >> > > [email protected]> wrote: > > >> > > > > >> > >> HI, > > >> > >> > > >> > >> > > >> > >> > > >> > >> I created one dimension and fact table in hive tables. > > >> > >> > > >> > >> in data model tab, added lookup table as dimension table. > > >> > >> > > >> > >> in dimension tab, i did not add anything. > > >> > >> > > >> > >> measures tab ,added one fact column with sum. > > >> > >> > > >> > >> after filter tab, Refresh setting tab next button is not > enabling. > > >> > >> Could you please check ,what i did mistake. Please let me know. > > >> > >> > > >> > >> > > >> > >> > > >> > >> And one thing could you please provide me ,kylin cube > > >> > >> creation document. I read blogs did not find exact solution. > > >> > >> > > >> > >> > > >> > >> ------------------------------ > > >> > >> > > >> > >> This electronic transmission and any documents accompanying > > >> > >> this electronic transmission contain confidential > > >> > >> information belonging to the sender. This information may > > >> > >> contain confidential health information that is legally privileged. > > >> > >> The information is intended only for the use of the > > >> > >> individual or entity named above. The authorized recipient > > >> > >> of this transmission is prohibited from disclosing this > > >> > >> information to any other party unless required to do so by > > >> > >> law or regulation and is required to delete or destroy the > > >> > >> information after its > > stated need has been fulfilled. > > >> > >> If you are not the intended recipient, you are hereby > > >> > >> notified that any disclosure, copying, distribution or the > > >> > >> taking of any action in reliance on or regarding the > > >> > >> contents of this electronically transmitted information is strictly > > >> > >> prohibited. > > >> > >> If you have received this E-mail in error, please notify the > > >> > >> sender and delete this message immediately. > > >> > >> > > >> > > > > >> > > _____________________________________________________________ > > >> > > __ __ _ ____ This electronic transmission and any documents > > >> > > accompanying this electronic transmission contain > > >> > > confidential information belonging to the sender. This > > >> > > information may contain confidential health information that > > >> > > is legally privileged. The information is intended only for > > >> > > the use of the individual or entity named above. The > > >> > > authorized recipient of this transmission is prohibited from > > >> > > disclosing this information to any other party unless > > >> > > required to do so by law or regulation and is required to > > >> > > delete or destroy the information after its stated need has > > >> > > been fulfilled. If you are not the intended recipient, you > > >> > > are hereby notified that any disclosure, copying, > > >> > > distribution or the taking of any action in reliance on or > > >> > > regarding the contents of this electronically transmitted > > >> > > information is strictly prohibited. > > >> > > If you have received this E-mail in error, > > >> > please notify the sender and delete this message immediately. > > >> > > > > >> > > > >> > _______________________________________________________________ > > >> > __ __ _ __ This electronic transmission and any documents > > >> > accompanying this electronic transmission contain confidential > > >> > information belonging to the sender. This information may > > >> > contain confidential health information > > >> that > > >> > is legally privileged. The information is intended only for > > >> > the use of > > >> the > > >> > individual or entity named above. The authorized recipient of > > >> > this transmission is prohibited from disclosing this > > >> > information to any other party unless required to do so by law > > >> > or regulation and is required to delete or destroy the > > >> > information after its stated need has been fulfilled. If you > > >> > are not the intended recipient, you are hereby > > >> notified > > >> > that any disclosure, copying, distribution or the taking of any > > >> > action in reliance on or regarding the contents of this > > >> > electronically transmitted information is strictly prohibited. > > >> > If you have received this E-mail in error, please notify the > > >> > sender and > > delete this message immediately. > > >> > > > >> > > > > > > > > > > > >-- > > >Best regards, > > > > > >Shaofeng Shi > > > > > >___________________________________________________________________ > > >__ _ This electronic transmission and any documents accompanying > > >this > > electronic transmission contain confidential information belonging > > to the sender. This information may contain confidential health > > information that is legally privileged. The information is intended > > only for the use of the individual or entity named above. The > > authorized recipient of this transmission is prohibited from > > disclosing this information to any other party unless required to do > > so by law or regulation and is required to delete or destroy the > > information after its stated need has been fulfilled. If you are > > not the intended recipient, you are hereby notified that any > > disclosure, copying, distribution or the taking of any action in > > reliance on or regarding the contents of this electronically > > transmitted information is strictly prohibited. If you have > > received this E-mail in error, > please notify the sender and delete this message immediately. > > > > ______________________________________________________________________ > This electronic transmission and any documents accompanying this > electronic transmission contain confidential information belonging to > the sender. This information may contain confidential health > information that is legally privileged. The information is intended > only for the use of the individual or entity named above. The > authorized recipient of this transmission is prohibited from > disclosing this information to any other party unless required to do > so by law or regulation and is required to delete or destroy the > information after its stated need has been fulfilled. If you are not > the intended recipient, you are hereby notified that any disclosure, > copying, distribution or the taking of any action in reliance on or > regarding the contents of this electronically transmitted information > is strictly prohibited. If you have received this E-mail in error, please > notify the sender and delete this message immediately. > ______________________________________________________________________ This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may contain confidential health information that is legally privileged. The information is intended only for the use of the individual or entity named above. The authorized recipient of this transmission is prohibited from disclosing this information to any other party unless required to do so by law or regulation and is required to delete or destroy the information after its stated need has been fulfilled. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited. If you have received this E-mail in error, please notify the sender and delete this message immediately.
