You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by Moisés Català <mo...@lacupulamusic.com> on 2018/09/18 17:25:37 UTC
Kylin Interpreter on Zeppelin doesnt allow stting project name on paragraph
Hi guys,
I have started using Kylin with our Zeppelin Notebook Server, we have
installed correctly the interpreter and we can run queries to the default
project specified in the interpreter settings:
The problem is when we try to set the project at the paragraph:
[image: image.png]
First paragraph fails with error 500, second paragraph has not specified
the project (learn_kylin) and executes fine.
Our Kylin version is 2.4.0
Zeppelin Version 0.7.3
Kylin interpreter settings are the default:
[image: image.png]
Am I writting the paragraph with incorrect syntax??
%kylin(learn_kylin)
select part_dt,count(*) from kylin_sales group by part_dt
Thanks in advance
Re: Kylin Interpreter on Zeppelin doesnt allow stting project name on paragraph
Posted by Billy Liu <bi...@apache.org>.
Hi Shaofeng,
The project name defining in paragraph is supported since Zeppelin 0.7.1.
The test cases are included here:
https://github.com/apache/zeppelin/blob/master/kylin/src/test/java/org/apache/zeppelin/kylin/KylinInterpreterTest.java
Hi Moises,
If that does not work, please check the exception logs again. Thank you.
With Warm regards
Billy Liu
ShaoFeng Shi <sh...@apache.org> 于2018年9月27日周四 上午10:50写道：
> Thank you; we will check it.
>
> Moisés Català <mo...@lacupulamusic.com> 于2018年9月26日周三 下午10:34写道：
>
>> Hi ShaoFeng,
>>
>> I’ve created the JIra Issue
>> https://issues.apache.org/jira/browse/KYLIN-3593 related to this topic
>>
>> Thanks
>>
>>
>>
>> Moisés Català
>> Senior Data Engineer
>> La Cupula Music - Sonosuite
>> T: *+34 93 250 38 05*
>> www.lacupulamusic.com
>>
>>
>>
>> C/. Trafalgar, 10 Pral-1ª
>> 08010 Barcelona (Spain)
>>
>>
>>
>>
>>
>>
>>
>> El 25 sept 2018, a las 6:01, ShaoFeng Shi <sh...@apache.org>
>> escribió:
>>
>> Hi Moises,
>>
>> It doesn't support project name following "%kylin" I think. The project
>> name can only be set in the interpreter configuration with
>> "kylin.query.project".
>>
>> But I agree with you that it should be flexible to support connecting
>> with multiple projects. Would you like to report a JIRA to Kylin? Thank you!
>>
>> Moisés Català <mo...@lacupulamusic.com> 于2018年9月19日周三 上午1:26写道：
>>
>>> Hi guys,
>>>
>>> I have started using Kylin with our Zeppelin Notebook Server, we have
>>> installed correctly the interpreter and we can run queries to the default
>>> project specified in the interpreter settings:
>>>
>>> The problem is when we try to set the project at the paragraph:
>>> <image.png>
>>> First paragraph fails with error 500, second paragraph has not specified
>>> the project (learn_kylin) and executes fine.
>>>
>>> Our Kylin version is 2.4.0
>>> Zeppelin Version 0.7.3
>>>
>>> Kylin interpreter settings are the default:
>>> <image.png>
>>>
>>> Am I writting the paragraph with incorrect syntax??
>>>
>>> %kylin(learn_kylin)
>>>
>>> select part_dt,count(*) from kylin_sales group by part_dt
>>>
>>> Thanks in advance
>>>
>>>
>>
>> --
>> Best regards,
>>
>> Shaofeng Shi 史少锋
>>
>>
>>
>
> --
> Best regards,
>
> Shaofeng Shi 史少锋
>
>
Re: Kylin Interpreter on Zeppelin doesnt allow stting project name on paragraph
Posted by ShaoFeng Shi <sh...@apache.org>.
Thank you; we will check it.
Moisés Català <mo...@lacupulamusic.com> 于2018年9月26日周三 下午10:34写道：
> Hi ShaoFeng,
>
> I’ve created the JIra Issue
> https://issues.apache.org/jira/browse/KYLIN-3593 related to this topic
>
> Thanks
>
>
>
> Moisés Català
> Senior Data Engineer
> La Cupula Music - Sonosuite
> T: *+34 93 250 38 05*
> www.lacupulamusic.com
>
>
>
> C/. Trafalgar, 10 Pral-1ª
> 08010 Barcelona (Spain)
>
>
>
>
>
>
>
> El 25 sept 2018, a las 6:01, ShaoFeng Shi <sh...@apache.org>
> escribió:
>
> Hi Moises,
>
> It doesn't support project name following "%kylin" I think. The project
> name can only be set in the interpreter configuration with
> "kylin.query.project".
>
> But I agree with you that it should be flexible to support connecting with
> multiple projects. Would you like to report a JIRA to Kylin? Thank you!
>
> Moisés Català <mo...@lacupulamusic.com> 于2018年9月19日周三 上午1:26写道：
>
>> Hi guys,
>>
>> I have started using Kylin with our Zeppelin Notebook Server, we have
>> installed correctly the interpreter and we can run queries to the default
>> project specified in the interpreter settings:
>>
>> The problem is when we try to set the project at the paragraph:
>> <image.png>
>> First paragraph fails with error 500, second paragraph has not specified
>> the project (learn_kylin) and executes fine.
>>
>> Our Kylin version is 2.4.0
>> Zeppelin Version 0.7.3
>>
>> Kylin interpreter settings are the default:
>> <image.png>
>>
>> Am I writting the paragraph with incorrect syntax??
>>
>> %kylin(learn_kylin)
>>
>> select part_dt,count(*) from kylin_sales group by part_dt
>>
>> Thanks in advance
>>
>>
>
> --
> Best regards,
>
> Shaofeng Shi 史少锋
>
>
>
--
Best regards,
Shaofeng Shi 史少锋
Re: Kylin Interpreter on Zeppelin doesnt allow stting project name on
paragraph
Posted by Moisés Català <mo...@lacupulamusic.com>.
Hi ShaoFeng,
I’ve created the JIra Issue https://issues.apache.org/jira/browse/KYLIN-3593 <https://issues.apache.org/jira/browse/KYLIN-3593> related to this topic
Thanks
Moisés Català
Senior Data Engineer
La Cupula Music - Sonosuite
T: +34 93 250 38 05
www.lacupulamusic.com <http://www.lacupulamusic.com/>
C/. Trafalgar, 10 Pral-1ª
08010 Barcelona (Spain)
> El 25 sept 2018, a las 6:01, ShaoFeng Shi <sh...@apache.org> escribió:
>
> Hi Moises,
>
> It doesn't support project name following "%kylin" I think. The project name can only be set in the interpreter configuration with "kylin.query.project".
>
> But I agree with you that it should be flexible to support connecting with multiple projects. Would you like to report a JIRA to Kylin? Thank you!
>
> Moisés Català <moises.catala@lacupulamusic.com <ma...@lacupulamusic.com>> 于2018年9月19日周三 上午1:26写道：
> Hi guys,
>
> I have started using Kylin with our Zeppelin Notebook Server, we have installed correctly the interpreter and we can run queries to the default project specified in the interpreter settings:
>
> The problem is when we try to set the project at the paragraph:
> <image.png>
> First paragraph fails with error 500, second paragraph has not specified the project (learn_kylin) and executes fine.
>
> Our Kylin version is 2.4.0
> Zeppelin Version 0.7.3
>
> Kylin interpreter settings are the default:
> <image.png>
>
> Am I writting the paragraph with incorrect syntax??
>
> %kylin(learn_kylin)
>
> select part_dt,count(*) from kylin_sales group by part_dt
>
> Thanks in advance
>
>
>
> --
> Best regards,
>
> Shaofeng Shi 史少锋
>
Re: Kylin Interpreter on Zeppelin doesnt allow stting project name on paragraph
Posted by ShaoFeng Shi <sh...@apache.org>.
Hi Moises,
It doesn't support project name following "%kylin" I think. The project
name can only be set in the interpreter configuration with
"kylin.query.project".
But I agree with you that it should be flexible to support connecting with
multiple projects. Would you like to report a JIRA to Kylin? Thank you!
Moisés Català <mo...@lacupulamusic.com> 于2018年9月19日周三 上午1:26写道：
> Hi guys,
>
> I have started using Kylin with our Zeppelin Notebook Server, we have
> installed correctly the interpreter and we can run queries to the default
> project specified in the interpreter settings:
>
> The problem is when we try to set the project at the paragraph:
> [image: image.png]
> First paragraph fails with error 500, second paragraph has not specified
> the project (learn_kylin) and executes fine.
>
> Our Kylin version is 2.4.0
> Zeppelin Version 0.7.3
>
> Kylin interpreter settings are the default:
> [image: image.png]
>
> Am I writting the paragraph with incorrect syntax??
>
> %kylin(learn_kylin)
>
> select part_dt,count(*) from kylin_sales group by part_dt
>
> Thanks in advance
>
>
--
Best regards,
Shaofeng Shi 史少锋