Re: Kylin Interpreter on Zeppelin doesnt allow stting project name on paragraph

[Billy Liu]

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  于2018年9月27日周四 上午10:50写道：

> Thank you; we will check it.
>
> Moisés Català  于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 
>> 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à  于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:
>>> 
>>> 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:
>>> 
>>>
>>> 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

[ShaoFeng Shi]

Thank you; we will check it.

Moisés Català  于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 
> 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à  于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:
>> 
>> 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:
>> 
>>
>> 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

[Moisés Català]

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  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à  > 于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: 
> 
> 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:
> 
> 
> 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

[ShaoFeng Shi]

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à  于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 史少锋