You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by Li Yang <li...@apache.org> on 2015/01/27 03:22:31 UTC
Re: MDX for kylin?
MDX support is definitely possible! However MDX was not Kylin's priority
from the beginning. SQL is.
If anyone find MDX important and willing to contribute, that's very
appreciated. Not sure if any sql-mdx adapter out there that we could
leverage.
Cheers
Yang
On Mon, Jan 26, 2015 at 10:49 PM, Jakob Stengård <ja...@gmail.com>
wrote:
> Hi.
>
> Is it possible to use MDX on kylin, maybe through some tool or add-on?
>
> Best Regards.
> Jakob Stengård
>
> MSc Student
> Royal Institute of Technology
> Sweden
>
Re: MDX for kylin?
Posted by Luke Han <lu...@gmail.com>.
Hi Julian,
You are right, such interface should one part of OLAP system.
Full OLAP function is long term goal of Kylin, and such
multidimensional interface will come eventfully.
Regards.
Luke
2015-01-28 0:18 GMT+08:00 Julian Hyde <ju...@hydromatic.net>:
> Luke, Yang, I think the perception problem is your own making --
> because you call Kylin OLAP, people expect an OLAP (multidimensional)
> interface. Traditionally, OLAP tools may or may not have cubes
> internally, but they always have a multidimensional interface.
>
> But Kylin is what it is: a fast SQL engine for OLAP-style queries.
>
> If you want to do MDX using Kylin, I suggest that you try Mondrian [
> http://community.pentaho.com/projects/mondrian/ ]. It has full support
> for the MDX language, olap4j and XMLA APIs, and several client tools
> such as Saiku work with it. It can work with just about any SQL engine
> that has a JDBC driver.
>
> Julian
>
>
> On Tue, Jan 27, 2015 at 7:02 AM, Luke Han <lu...@gmail.com> wrote:
> > MDX, there are many people have asked this, but a few are using in real
> > work.
> >
> > And, there's very important concept in Kylin is Cube will not EXPOSED to
> > end users, only Hive Tables.
> > The purpose is to keep our analysts and users to continue use ANSI SQL
> with
> > same table structure on Hadoop.
> >
> > Most of BI tools are working very well with SQL already, even better than
> > MDX. This is also another decision fact:)
> >
> > It's possible to support MDX as Yang mentioned, will bring to roadmap if
> > there are highly requirements from community.
> >
> > Regards.
> > Luke
> >
> >
> > 2015-01-27 10:22 GMT+08:00 Li Yang <li...@apache.org>:
> >
> >> MDX support is definitely possible! However MDX was not Kylin's
> priority
> >> from the beginning. SQL is.
> >>
> >> If anyone find MDX important and willing to contribute, that's very
> >> appreciated. Not sure if any sql-mdx adapter out there that we could
> >> leverage.
> >>
> >> Cheers
> >> Yang
> >>
> >> On Mon, Jan 26, 2015 at 10:49 PM, Jakob Stengård <
> jakob.stengard@gmail.com
> >> >
> >> wrote:
> >>
> >> > Hi.
> >> >
> >> > Is it possible to use MDX on kylin, maybe through some tool or add-on?
> >> >
> >> > Best Regards.
> >> > Jakob Stengård
> >> >
> >> > MSc Student
> >> > Royal Institute of Technology
> >> > Sweden
> >> >
> >>
> >
> >
> >
> > --
> >
> > Best Regards!
> > ---------------------
> >
> > Luke Han
>
--
Best Regards!
---------------------
Luke Han
Re: MDX for kylin?
Posted by Julian Hyde <ju...@hydromatic.net>.
Luke, Yang, I think the perception problem is your own making --
because you call Kylin OLAP, people expect an OLAP (multidimensional)
interface. Traditionally, OLAP tools may or may not have cubes
internally, but they always have a multidimensional interface.
But Kylin is what it is: a fast SQL engine for OLAP-style queries.
If you want to do MDX using Kylin, I suggest that you try Mondrian [
http://community.pentaho.com/projects/mondrian/ ]. It has full support
for the MDX language, olap4j and XMLA APIs, and several client tools
such as Saiku work with it. It can work with just about any SQL engine
that has a JDBC driver.
Julian
On Tue, Jan 27, 2015 at 7:02 AM, Luke Han <lu...@gmail.com> wrote:
> MDX, there are many people have asked this, but a few are using in real
> work.
>
> And, there's very important concept in Kylin is Cube will not EXPOSED to
> end users, only Hive Tables.
> The purpose is to keep our analysts and users to continue use ANSI SQL with
> same table structure on Hadoop.
>
> Most of BI tools are working very well with SQL already, even better than
> MDX. This is also another decision fact:)
>
> It's possible to support MDX as Yang mentioned, will bring to roadmap if
> there are highly requirements from community.
>
> Regards.
> Luke
>
>
> 2015-01-27 10:22 GMT+08:00 Li Yang <li...@apache.org>:
>
>> MDX support is definitely possible! However MDX was not Kylin's priority
>> from the beginning. SQL is.
>>
>> If anyone find MDX important and willing to contribute, that's very
>> appreciated. Not sure if any sql-mdx adapter out there that we could
>> leverage.
>>
>> Cheers
>> Yang
>>
>> On Mon, Jan 26, 2015 at 10:49 PM, Jakob Stengård <jakob.stengard@gmail.com
>> >
>> wrote:
>>
>> > Hi.
>> >
>> > Is it possible to use MDX on kylin, maybe through some tool or add-on?
>> >
>> > Best Regards.
>> > Jakob Stengård
>> >
>> > MSc Student
>> > Royal Institute of Technology
>> > Sweden
>> >
>>
>
>
>
> --
>
> Best Regards!
> ---------------------
>
> Luke Han
Re: MDX for kylin?
Posted by Luke Han <lu...@gmail.com>.
MDX, there are many people have asked this, but a few are using in real
work.
And, there's very important concept in Kylin is Cube will not EXPOSED to
end users, only Hive Tables.
The purpose is to keep our analysts and users to continue use ANSI SQL with
same table structure on Hadoop.
Most of BI tools are working very well with SQL already, even better than
MDX. This is also another decision fact:)
It's possible to support MDX as Yang mentioned, will bring to roadmap if
there are highly requirements from community.
Regards.
Luke
2015-01-27 10:22 GMT+08:00 Li Yang <li...@apache.org>:
> MDX support is definitely possible! However MDX was not Kylin's priority
> from the beginning. SQL is.
>
> If anyone find MDX important and willing to contribute, that's very
> appreciated. Not sure if any sql-mdx adapter out there that we could
> leverage.
>
> Cheers
> Yang
>
> On Mon, Jan 26, 2015 at 10:49 PM, Jakob Stengård <jakob.stengard@gmail.com
> >
> wrote:
>
> > Hi.
> >
> > Is it possible to use MDX on kylin, maybe through some tool or add-on?
> >
> > Best Regards.
> > Jakob Stengård
> >
> > MSc Student
> > Royal Institute of Technology
> > Sweden
> >
>
--
Best Regards!
---------------------
Luke Han