Hi Indiradevi,
Could you please have a try and ask some .net expert for authentication
and consume REST API? We are actually not .NET developer who has no
experience for this:-(
Hi Community,
Is there anyone who has .NET knowledge could help on this?
Thanks.
Luke
Best Regards!
---------------------
Luke Han
On Thu, Nov 12, 2015 at 8:49 PM, Indiradevi Gorijavolu <
[email protected]> wrote:
> 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.
>
