I changed authentication. Could you please provide me exact code.
-----Original Message----- From: Jian Zhong [mailto:[email protected]] Sent: Thursday, November 12, 2015 1:49 PM To: [email protected] Subject: Re: Refresh setting tab Kylin auth is basic authentication, so you need to do basic authentication in .net way. maybe this link could help http://www.asp.net/web-api/overview/security/basic-authentication On Thu, Nov 12, 2015 at 3:48 PM, Indiradevi Gorijavolu < [email protected]> wrote: > I have little bit knowledge in .net.so I tried to write code in .net. But > it is showing some errors. > my kylin cube in VMware so how should we can give authorization? > Please send me exact code. > Please check my below query. Please find attachment also. > > protected void ASPxButton1_Click(object sender, EventArgs e) > { > //Page.ClientScript.RegisterStartupScript(this.GetType(), > "JsFunc", "alert('Hello!')", true); > // $.ajaxSetup({ > // headers: { 'Authorization': "Basic eWFu**********X***ZA==", > 'Content-Type': 'application/json;charset=utf-8' } // use your own > authorization code here > //}); > var request = $.ajax({ > url: "http://192.168.75.131:7070/kylin/api/query";, > type: "POST", > data: '{"sql":"select count(*) from > diemp;","offset":0,"limit":50000,"acceptPartial":true,"project":"testproj"}', > dataType: "json" > }); > request.done(function( msg ) { > alert(msg); > }); > request.fail(function( jqXHR, textStatus ) { > alert( "Request failed: " + textStatus ); > }); > } > } > > > -----Original Message----- > From: Luke Han [mailto:[email protected]] > Sent: Thursday, November 12, 2015 6:53 AM > To: [email protected] > Subject: Re: Refresh setting tab > > Please refer to how JavaScript to interactive with Kylin Services: > > http://kylin.incubator.apache.org/docs/howto/howto_use_restapi_in_js.html > > It should not too hard to write .net one with same approach. > > Thanks. > > > Best Regards! > --------------------- > > Luke Han > > On Thu, Nov 12, 2015 at 12:43 AM, Indiradevi Gorijavolu < > [email protected]> wrote: > > > 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. > > > > > > ______________________________________________________________________ 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.
