the cube has been built and in READY state? On Tue, Nov 17, 2015 at 1:27 AM, Indiradevi Gorijavolu < [email protected]> wrote:
> Hi, > > I am querying data in querytab using kylin. > Why fact table not loading any data? > But in my hive table has data. > > Please suggest me.what I was doing wrong? > -----Original Message----- > From: Indiradevi Gorijavolu [mailto:[email protected]] > Sent: Wednesday, November 11, 2015 10:14 PM > To: [email protected] > Subject: RE: Refresh setting tab > > I checked restapi.but I did not understand. > > Actually my scenario is I have .net application.in that .net application > calling mdx queries.so I am binding result in grid. > Same thing how is it possible here? > > -----Original Message----- > From: Jian Zhong [mailto:[email protected]] > Sent: Wednesday, November 11, 2015 2:49 PM > To: [email protected] > Subject: Re: Refresh setting tab > > 1) data will be store in hbase.we need to use Cube Metadata to build > cuboids. > > 2) your sql will map to data in hbase. Cube will desc the necessary > metadata like dimension,measure,rowkey...Build cube will build all cuboids > for you. > > 3) check this API see how to use Kylin API > http://kylin.incubator.apache.org/docs/howto/howto_use_restapi.html > > also here's a link about kylin olap engine > http://www.slideshare.net/lukehan/kylin-olap-engine-tour > > > On Wed, Nov 11, 2015 at 3:28 PM, Indiradevi Gorijavolu < > [email protected]> wrote: > > > 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. > > >
