You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by Na Zhai <na...@kyligence.io> on 2019/04/21 14:29:59 UTC
答复: Apache kylin is a strange system
Hi, Khalil Mejdi.
For question one, query reaches the HBase.
For question two, query the cube.
发送自 Windows 10 版邮件<https://go.microsoft.com/fwlink/?LinkId=550986>应用
________________________________
发件人: Khalil Mejdi <kh...@gmail.com>
发送时间: Sunday, April 21, 2019 9:40:54 PM
收件人: user@kylin.apache.org
主题: Apache kylin is a strange system
Hello kylin
Does in the insight tab, when i query something, that query reachs the HBase and get data from it or it just query the datasource.
And one more thing, using BI tools like Tableau software, PowerBI or Saiku, are they querying the cubes or only the datasource,
Things are still unclear for me, can someone explain it!!
Best regards.
Khalil
Re: Apache kylin is a strange system
Posted by Khalil Mejdi <kh...@gmail.com>.
Thanks again !
But One last thing, Using a jdbc datasource like mysql,postgresql, etc... linked to apache kylin , will things will work as smooth as it is with hive as a datasource?
> On Apr 22, 2019, at 3:27 AM, ShaoFeng Shi <sh...@apache.org> wrote:
>
> Hi Khalil,
>
> Saiku/Mondrian is less used by Kylin users; We recommend to use Apache Superset, Tableau or other modern BI tools.
>
> Best regards,
>
> Shaofeng Shi 史少锋
> Apache Kylin PMC
> Email: shaofengshi@apache.org
>
> Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html
> Join Kylin user mail group: user-subscribe@kylin.apache.org
> Join Kylin dev mail group: dev-subscribe@kylin.apache.org
>
>
>
>
> Khalil Mejdi <kh...@gmail.com> 于2019年4月22日周一 上午4:58写道：
>> Thanks alot for your clear response! That was really helpful
>> But one more thing !
>> I am using :
>>
>> Apache Hadoop 2.7.3
>> Apache HBase 1.2.4
>> Apache Hive 2.1.1
>> Apache Kylin 2.6.1
>> Saiku
>> Mondrian 4.4 Dialect Kylin
>> I've managed to create a schema and i saw it on my cube list from saiku but i couldnt get any data from it!
>>
>> checked my saiku log and i found this!
>>
>> 2019-04-20 22:14:56,964 ERROR [org.saiku.web.rest.InfoResource] /etc/theme/cssoverride.less
>> 2019-04-20 22:14:59,468 DEBUG [org.saiku.web.rest.resources.Query2Resource] TRACK /query/E78B5A72-3348-A912-AF77-BB9ACD1E3E48 POST tq:false file:null
>> do i have something wrong with my schema or something else !
>> I sincerly feel like that mondrian jar isnt working well with my kylin version
>>
>>
>>> On Sun, Apr 21, 2019 at 4:30 PM Na Zhai <na...@kyligence.io> wrote:
>>> Hi, Khalil Mejdi.
>>>
>>>
>>>
>>> For question one, query reaches the HBase.
>>>
>>> For question two, query the cube.
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> 发送自 Windows 10 版邮件应用
>>>
>>>
>>>
>>>
>>> 发件人: Khalil Mejdi <kh...@gmail.com>
>>> 发送时间: Sunday, April 21, 2019 9:40:54 PM
>>> 收件人: user@kylin.apache.org
>>> 主题: Apache kylin is a strange system
>>>
>>> Hello kylin
>>>
>>> Does in the insight tab, when i query something, that query reachs the HBase and get data from it or it just query the datasource.
>>>
>>> And one more thing, using BI tools like Tableau software, PowerBI or Saiku, are they querying the cubes or only the datasource,
>>> Things are still unclear for me, can someone explain it!!
>>>
>>> Best regards.
>>> Khalil
Re: Apache kylin is a strange system
Posted by ShaoFeng Shi <sh...@apache.org>.
Hi Khalil,
Saiku/Mondrian is less used by Kylin users; We recommend to use Apache
Superset, Tableau or other modern BI tools.
Best regards,
Shaofeng Shi 史少锋
Apache Kylin PMC
Email: shaofengshi@apache.org
Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html
Join Kylin user mail group: user-subscribe@kylin.apache.org
Join Kylin dev mail group: dev-subscribe@kylin.apache.org
Khalil Mejdi <kh...@gmail.com> 于2019年4月22日周一 上午4:58写道：
> Thanks alot for your clear response! That was really helpful
> But one more thing !
>
> I am using :
>
> Apache Hadoop 2.7.3
> Apache HBase 1.2.4
> Apache Hive 2.1.1
> Apache Kylin 2.6.1
> Saiku
> Mondrian 4.4 Dialect Kylin
>
> I've managed to create a schema and i saw it on my cube list from saiku
> but i couldnt get any data from it!
>
> checked my saiku log and i found this!
>
> 2019-04-20 22:14:56,964 ERROR [org.saiku.web.rest.InfoResource] /etc/theme/cssoverride.less
> 2019-04-20 22:14:59,468 DEBUG [org.saiku.web.rest.resources.Query2Resource] TRACK /query/E78B5A72-3348-A912-AF77-BB9ACD1E3E48 POST tq:false file:null
>
> do i have something wrong with my schema or something else !
> I sincerly feel like that mondrian jar isnt working well with my kylin
> version
>
>
> On Sun, Apr 21, 2019 at 4:30 PM Na Zhai <na...@kyligence.io> wrote:
>
>> Hi, Khalil Mejdi.
>>
>>
>>
>> For question one, query reaches the HBase.
>>
>> For question two, query the cube.
>>
>>
>>
>>
>>
>>
>>
>> 发送自 Windows 10 版邮件 <https://go.microsoft.com/fwlink/?LinkId=550986>应用
>>
>>
>> ------------------------------
>> *发件人:* Khalil Mejdi <kh...@gmail.com>
>> *发送时间:* Sunday, April 21, 2019 9:40:54 PM
>> *收件人:* user@kylin.apache.org
>> *主题:* Apache kylin is a strange system
>>
>> Hello kylin
>>
>> Does in the insight tab, when i query something, that query reachs the
>> HBase and get data from it or it just query the datasource.
>>
>>
>> And one more thing, using BI tools like Tableau software, PowerBI or
>> Saiku, are they querying the cubes or only the datasource,
>>
>> Things are still unclear for me, can someone explain it!!
>>
>>
>> Best regards.
>>
>> Khalil
>>
>
Re: Apache kylin is a strange system
Posted by Khalil Mejdi <kh...@gmail.com>.
Thanks alot for your clear response! That was really helpful
But one more thing !
I am using :
Apache Hadoop 2.7.3
Apache HBase 1.2.4
Apache Hive 2.1.1
Apache Kylin 2.6.1
Saiku
Mondrian 4.4 Dialect Kylin
I've managed to create a schema and i saw it on my cube list from saiku but
i couldnt get any data from it!
checked my saiku log and i found this!
2019-04-20 22:14:56,964 ERROR [org.saiku.web.rest.InfoResource]
/etc/theme/cssoverride.less
2019-04-20 22:14:59,468 DEBUG
[org.saiku.web.rest.resources.Query2Resource] TRACK
/query/E78B5A72-3348-A912-AF77-BB9ACD1E3E48 POST tq:false
file:null
do i have something wrong with my schema or something else !
I sincerly feel like that mondrian jar isnt working well with my kylin
version
On Sun, Apr 21, 2019 at 4:30 PM Na Zhai <na...@kyligence.io> wrote:
> Hi, Khalil Mejdi.
>
>
>
> For question one, query reaches the HBase.
>
> For question two, query the cube.
>
>
>
>
>
>
>
> 发送自 Windows 10 版邮件 <https://go.microsoft.com/fwlink/?LinkId=550986>应用
>
>
> ------------------------------
> *发件人:* Khalil Mejdi <kh...@gmail.com>
> *发送时间:* Sunday, April 21, 2019 9:40:54 PM
> *收件人:* user@kylin.apache.org
> *主题:* Apache kylin is a strange system
>
> Hello kylin
>
> Does in the insight tab, when i query something, that query reachs the
> HBase and get data from it or it just query the datasource.
>
>
> And one more thing, using BI tools like Tableau software, PowerBI or
> Saiku, are they querying the cubes or only the datasource,
>
> Things are still unclear for me, can someone explain it!!
>
>
> Best regards.
>
> Khalil
>