You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by Vineet Mishra <cl...@gmail.com> on 2015/06/07 13:48:26 UTC
Kylin Query comes blank
Hi,
I have a kylin cube setup with few dimensions and I am trying to query the
associated columns to it but I couldn't see any particular data coming up.
Has anyone been through the kylin making queries and getting records
properly.
Thanks!
Re: Kylin Query comes blank
Posted by Vineet Mishra <cl...@gmail.com>.
Thanks guys!
On Fri, Jun 19, 2015 at 7:23 PM, Shi, Shaofeng <sh...@ebay.com> wrote:
> In bin/kylin.sh there is a JAVA_OPTS variable; Give a proper heap size
> based on your query scale; In our internal deployment we set to 16G;
>
> On 6/10/15, 3:09 AM, "Vineet Mishra" <cl...@gmail.com> wrote:
>
> >Whenever I am firing a "select * from" the resultset returned is blank,
> >moreover when I am querying selected column with groupby the records are
> >coming fine.
> >
> >Moreover to my surprise sometimes when I am building cube the job gets
> >failed, how can increase the memory limits of kylin? I guess its going
> >down
> >due to the reason of same!
> >
> >Thanks!
> >
> >On Tue, Jun 9, 2015 at 5:16 AM, Luke Han <lu...@gmail.com> wrote:
> >
> >> Could you please help to paste log from Tomcat logs/kylin.log?
> >>
> >> it could help a lots to understand your problem.
> >>
> >> Thanks.
> >>
> >>
> >> Best Regards!
> >> ---------------------
> >>
> >> Luke Han
> >>
> >> 2015-06-08 13:38 GMT-07:00 Diego Pinheiro <di...@gmail.com>:
> >>
> >> > Hi all,
> >> >
> >> > I am facing the same issue. I'm running the latest Kylin build:
> >> >
> >> >
> >> >
> >>
> >>
> http://kylin.incubator.apache.org/download/kylin-0.7.1-incubating-SNAPSHO
> >>T.tar.gz
> >> >
> >> > and following the steps in:
> >> >
> >> >
> >> >
> >>
> >>
> https://github.com/apache/incubator-kylin/blob/0.7-staging/docs/Tutorial/
> >>Quick%20play%20with%20a%20sample%20cube.md
> >> >
> >> > The mentioned query in the tutorial is returning empty. Did anybody
> >> > get it works properly?
> >> >
> >> >
> >> > On Sun, Jun 7, 2015 at 7:48 AM, Vineet Mishra <clearmidoubt@gmail.com
> >
> >> > wrote:
> >> > > Hi,
> >> > >
> >> > > I have a kylin cube setup with few dimensions and I am trying to
> >>query
> >> > the
> >> > > associated columns to it but I couldn't see any particular data
> >>coming
> >> > up.
> >> > >
> >> > > Has anyone been through the kylin making queries and getting records
> >> > > properly.
> >> > >
> >> > > Thanks!
> >> >
> >>
>
>
Re: Kylin Query comes blank
Posted by "Shi, Shaofeng" <sh...@ebay.com>.
In bin/kylin.sh there is a JAVA_OPTS variable; Give a proper heap size
based on your query scale; In our internal deployment we set to 16G;
On 6/10/15, 3:09 AM, "Vineet Mishra" <cl...@gmail.com> wrote:
>Whenever I am firing a "select * from" the resultset returned is blank,
>moreover when I am querying selected column with groupby the records are
>coming fine.
>
>Moreover to my surprise sometimes when I am building cube the job gets
>failed, how can increase the memory limits of kylin? I guess its going
>down
>due to the reason of same!
>
>Thanks!
>
>On Tue, Jun 9, 2015 at 5:16 AM, Luke Han <lu...@gmail.com> wrote:
>
>> Could you please help to paste log from Tomcat logs/kylin.log?
>>
>> it could help a lots to understand your problem.
>>
>> Thanks.
>>
>>
>> Best Regards!
>> ---------------------
>>
>> Luke Han
>>
>> 2015-06-08 13:38 GMT-07:00 Diego Pinheiro <di...@gmail.com>:
>>
>> > Hi all,
>> >
>> > I am facing the same issue. I'm running the latest Kylin build:
>> >
>> >
>> >
>>
>>http://kylin.incubator.apache.org/download/kylin-0.7.1-incubating-SNAPSHO
>>T.tar.gz
>> >
>> > and following the steps in:
>> >
>> >
>> >
>>
>>https://github.com/apache/incubator-kylin/blob/0.7-staging/docs/Tutorial/
>>Quick%20play%20with%20a%20sample%20cube.md
>> >
>> > The mentioned query in the tutorial is returning empty. Did anybody
>> > get it works properly?
>> >
>> >
>> > On Sun, Jun 7, 2015 at 7:48 AM, Vineet Mishra <cl...@gmail.com>
>> > wrote:
>> > > Hi,
>> > >
>> > > I have a kylin cube setup with few dimensions and I am trying to
>>query
>> > the
>> > > associated columns to it but I couldn't see any particular data
>>coming
>> > up.
>> > >
>> > > Has anyone been through the kylin making queries and getting records
>> > > properly.
>> > >
>> > > Thanks!
>> >
>>
Re: Kylin Query comes blank
Posted by Li Yang <li...@apache.org>.
Select * without any group by is expected to yield strange result... cause
Kylin only retains aggregated data, so every query is expected to having a
group by at least.
However we did hack a little to try return something on select * with no
group by, because so many will attempt this query right after cube build...
I'll check and see if the hack still works.
On Wed, Jun 10, 2015 at 3:09 AM, Vineet Mishra <cl...@gmail.com>
wrote:
> Whenever I am firing a "select * from" the resultset returned is blank,
> moreover when I am querying selected column with groupby the records are
> coming fine.
>
> Moreover to my surprise sometimes when I am building cube the job gets
> failed, how can increase the memory limits of kylin? I guess its going down
> due to the reason of same!
>
> Thanks!
>
> On Tue, Jun 9, 2015 at 5:16 AM, Luke Han <lu...@gmail.com> wrote:
>
> > Could you please help to paste log from Tomcat logs/kylin.log?
> >
> > it could help a lots to understand your problem.
> >
> > Thanks.
> >
> >
> > Best Regards!
> > ---------------------
> >
> > Luke Han
> >
> > 2015-06-08 13:38 GMT-07:00 Diego Pinheiro <di...@gmail.com>:
> >
> > > Hi all,
> > >
> > > I am facing the same issue. I'm running the latest Kylin build:
> > >
> > >
> > >
> >
> http://kylin.incubator.apache.org/download/kylin-0.7.1-incubating-SNAPSHOT.tar.gz
> > >
> > > and following the steps in:
> > >
> > >
> > >
> >
> https://github.com/apache/incubator-kylin/blob/0.7-staging/docs/Tutorial/Quick%20play%20with%20a%20sample%20cube.md
> > >
> > > The mentioned query in the tutorial is returning empty. Did anybody
> > > get it works properly?
> > >
> > >
> > > On Sun, Jun 7, 2015 at 7:48 AM, Vineet Mishra <cl...@gmail.com>
> > > wrote:
> > > > Hi,
> > > >
> > > > I have a kylin cube setup with few dimensions and I am trying to
> query
> > > the
> > > > associated columns to it but I couldn't see any particular data
> coming
> > > up.
> > > >
> > > > Has anyone been through the kylin making queries and getting records
> > > > properly.
> > > >
> > > > Thanks!
> > >
> >
>
Re: Kylin Query comes blank
Posted by Vineet Mishra <cl...@gmail.com>.
Whenever I am firing a "select * from" the resultset returned is blank,
moreover when I am querying selected column with groupby the records are
coming fine.
Moreover to my surprise sometimes when I am building cube the job gets
failed, how can increase the memory limits of kylin? I guess its going down
due to the reason of same!
Thanks!
On Tue, Jun 9, 2015 at 5:16 AM, Luke Han <lu...@gmail.com> wrote:
> Could you please help to paste log from Tomcat logs/kylin.log?
>
> it could help a lots to understand your problem.
>
> Thanks.
>
>
> Best Regards!
> ---------------------
>
> Luke Han
>
> 2015-06-08 13:38 GMT-07:00 Diego Pinheiro <di...@gmail.com>:
>
> > Hi all,
> >
> > I am facing the same issue. I'm running the latest Kylin build:
> >
> >
> >
> http://kylin.incubator.apache.org/download/kylin-0.7.1-incubating-SNAPSHOT.tar.gz
> >
> > and following the steps in:
> >
> >
> >
> https://github.com/apache/incubator-kylin/blob/0.7-staging/docs/Tutorial/Quick%20play%20with%20a%20sample%20cube.md
> >
> > The mentioned query in the tutorial is returning empty. Did anybody
> > get it works properly?
> >
> >
> > On Sun, Jun 7, 2015 at 7:48 AM, Vineet Mishra <cl...@gmail.com>
> > wrote:
> > > Hi,
> > >
> > > I have a kylin cube setup with few dimensions and I am trying to query
> > the
> > > associated columns to it but I couldn't see any particular data coming
> > up.
> > >
> > > Has anyone been through the kylin making queries and getting records
> > > properly.
> > >
> > > Thanks!
> >
>
Re: Kylin Query comes blank
Posted by Luke Han <lu...@gmail.com>.
Could you please help to paste log from Tomcat logs/kylin.log?
it could help a lots to understand your problem.
Thanks.
Best Regards!
---------------------
Luke Han
2015-06-08 13:38 GMT-07:00 Diego Pinheiro <di...@gmail.com>:
> Hi all,
>
> I am facing the same issue. I'm running the latest Kylin build:
>
>
> http://kylin.incubator.apache.org/download/kylin-0.7.1-incubating-SNAPSHOT.tar.gz
>
> and following the steps in:
>
>
> https://github.com/apache/incubator-kylin/blob/0.7-staging/docs/Tutorial/Quick%20play%20with%20a%20sample%20cube.md
>
> The mentioned query in the tutorial is returning empty. Did anybody
> get it works properly?
>
>
> On Sun, Jun 7, 2015 at 7:48 AM, Vineet Mishra <cl...@gmail.com>
> wrote:
> > Hi,
> >
> > I have a kylin cube setup with few dimensions and I am trying to query
> the
> > associated columns to it but I couldn't see any particular data coming
> up.
> >
> > Has anyone been through the kylin making queries and getting records
> > properly.
> >
> > Thanks!
>
Re: Kylin Query comes blank
Posted by Diego Pinheiro <di...@gmail.com>.
Hi all,
I am facing the same issue. I'm running the latest Kylin build:
http://kylin.incubator.apache.org/download/kylin-0.7.1-incubating-SNAPSHOT.tar.gz
and following the steps in:
https://github.com/apache/incubator-kylin/blob/0.7-staging/docs/Tutorial/Quick%20play%20with%20a%20sample%20cube.md
The mentioned query in the tutorial is returning empty. Did anybody
get it works properly?
On Sun, Jun 7, 2015 at 7:48 AM, Vineet Mishra <cl...@gmail.com> wrote:
> Hi,
>
> I have a kylin cube setup with few dimensions and I am trying to query the
> associated columns to it but I couldn't see any particular data coming up.
>
> Has anyone been through the kylin making queries and getting records
> properly.
>
> Thanks!