[jira] [Created] (KYLIN-3593) Kylin Interpreter on Zeppelin doesn't allow setting project name on paragraph

2018-09-25 Thread Moises (JIRA) 
Moises created KYLIN-3593:
-

 Summary: Kylin Interpreter on Zeppelin doesn't allow setting 
project name on paragraph
 Key: KYLIN-3593
 URL: https://issues.apache.org/jira/browse/KYLIN-3593
 Project: Kylin
  Issue Type: Improvement
  Components: Driver - JDBC, Integration
Affects Versions: v2.4.1
Reporter: Moises


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: 
 
{{%kylin(learn_kylin)}}{{ }}{{select part_dt,count(*) from kylin_sales group by 
part_dt}}
 
Fails with error 500, second paragraph has not specified the project 
(learn_kylin) and executes fine.
 
 {{%kylin}}{{ }}{{select part_dt,count(*) from kylin_sales group by part_dt}}
 
Our Kylin version is 2.4.0
Zeppelin Version 0.7.3 
 
Kylin interpreter settings are the default, we followed the tutorial in 
Zeppelin Documentation: 
[https://zeppelin.apache.org/docs/0.7.0/interpreter/kylin.html] 
 
 
Am I writting the paragraph with incorrect syntax??
 
Thanks in advance
 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Re: 答复: 答复: kylin interpreter for zeppelin

2016-05-04 Thread Jian Zhong 
Can you share the sql or tell the different of this sql?

any special ?

On Wed, May 4, 2016 at 7:31 PM, Tao Li(Internship) <tao...@envisioncn.com>
wrote:

> Only one special sql
>
> -邮件原件-
> 发件人: Jian Zhong [mailto:hellowode...@gmail.com]
> 发送时间: 2016年5月4日 18:41
> 收件人: dev@kylin.apache.org
> 主题: Re: 答复: kylin interpreter for zeppelin
>
> all sql or only one specific sql?
>
> On Wed, May 4, 2016 at 6:02 PM, Tao Li(Internship) <tao...@envisioncn.com>
> wrote:
>
> > Yes, the sql can work normally.
> >
> > -邮件原件-
> > 发件人: Jian Zhong [mailto:hellowode...@gmail.com]
> > 发送时间: 2016年5月4日 17:56
> > 收件人: dev@kylin.apache.org
> > 主题: Re: kylin interpreter for zeppelin
> >
> > Does your sql work normally in Kylin?
> >
> > On Wed, May 4, 2016 at 3:25 PM, Tao Li(Internship)
> > <tao...@envisioncn.com>
> > wrote:
> >
> > > Hi,
> > >
> > > I want to select from kylin by zeppelin, however I get an exception:
> > >
> > > java.lang.NullPointerException
> > > at
> > > org.apache.zeppelin.kylin.KylinInterpreter.formatResult(KylinInterpr
> > > et
> > > er.java:190)
> > > at
> > > org.apache.zeppelin.kylin.KylinInterpreter.executeQuery(KylinInterpr
> > > et
> > > er.java:170)
> > > at
> > > org.apache.zeppelin.kylin.KylinInterpreter.interpret(KylinInterpreter.
> > > java:92)
> > > at
> > > org.apache.zeppelin.interpreter.ClassloaderInterpreter.interpret(Cla
> > > ss
> > > loaderInterpreter.java:57)
> > > at
> > > org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOp
> > > en
> > > Interpreter.java:93)
> > > at
> > > org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$Inter
> > > pr
> > > etJob.jobRun(RemoteInterpreterServer.java:300)
> > > at org.apache.zeppelin.scheduler.Job.run(Job.java:169)
> > > at
> > > org.apache.zeppelin.scheduler.FIFOScheduler$1.run(FIFOScheduler.java
> > > :1
> > > 34) at
> > > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:4
> > > 71
> > > ) at java.util.concurrent.FutureTask.run(FutureTask.java:262)
> > > at
> > > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask
> > > .a
> > > ccess$201(ScheduledThreadPoolExecutor.java:178)
> > > at
> > > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask
> > > .r
> > > un(ScheduledThreadPoolExecutor.java:292)
> > > at
> > > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor
> > > .j
> > > ava:1145)
> > > at
> > > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.
> > > java:615) at java.lang.Thread.run(Thread.java:745)
> > >
> > >
> > >
> > > Best regards,
> > >
> > >
> > >
> > > Tao Li
> > >
> > >
> > >
> > >
> > >
> > >
> >
> ???(,?
> > > This email message (including any attachments) is confidential and
> > > may be legally privileged. If you have received it by mistake,
> > > please notify the sender by return email and delete this message
> > > from your system. Any unauthorized use or dissemination of this
> > > message in whole or in part is strictly prohibited. Envision Energy
> > > Limited and all its subsidiaries shall not be liable for the
> > > improper or incomplete transmission of the information contained in
> > > this email nor for any delay in its receipt or damage to your
> > > system. Envision Energy Limited does not guarantee the integrity of
> > > this email message, nor that this email message is free of viruses,
> interceptions, or interference.
> > >
> >
> >
> >
> >
> > 本邮件(包括任何附件）内容机密并受法律保护。如果您意外地收到这封邮件，请回复通知发件人并从当前系统中删除本邮件。任何未经授权者，严禁使用并部
> > 分或者全部的转发本条信息。任何未经授权的使用或传播都是被严格禁止的。远景能源与其分公司不对因不正确和不完整的转发此邮件包含的信息以及因任何因
> > 邮件延迟或对你的系统造成的损害而负责。远景能源不能保证此邮件的真实完整性,也不能确定此邮件是否含有病毒或者监听程序。
> > This email message (including any attachments) is confidential and may
> > be legally privileged. If you have received it by mistake, please
> > notify the sender by return email and delete this message from your
> > system. Any unauthorized use or disse

答复: 答复: kylin interpreter for zeppelin

2016-05-04 Thread Tao Li(Internship) 
Only one special sql

-邮件原件-
发件人: Jian Zhong [mailto:hellowode...@gmail.com]
发送时间: 2016年5月4日 18:41
收件人: dev@kylin.apache.org
主题: Re: 答复: kylin interpreter for zeppelin

all sql or only one specific sql?

On Wed, May 4, 2016 at 6:02 PM, Tao Li(Internship) <tao...@envisioncn.com>
wrote:

> Yes, the sql can work normally.
>
> -邮件原件-
> 发件人: Jian Zhong [mailto:hellowode...@gmail.com]
> 发送时间: 2016年5月4日 17:56
> 收件人: dev@kylin.apache.org
> 主题: Re: kylin interpreter for zeppelin
>
> Does your sql work normally in Kylin?
>
> On Wed, May 4, 2016 at 3:25 PM, Tao Li(Internship)
> <tao...@envisioncn.com>
> wrote:
>
> > Hi,
> >
> > I want to select from kylin by zeppelin, however I get an exception:
> >
> > java.lang.NullPointerException
> > at
> > org.apache.zeppelin.kylin.KylinInterpreter.formatResult(KylinInterpr
> > et
> > er.java:190)
> > at
> > org.apache.zeppelin.kylin.KylinInterpreter.executeQuery(KylinInterpr
> > et
> > er.java:170)
> > at
> > org.apache.zeppelin.kylin.KylinInterpreter.interpret(KylinInterpreter.
> > java:92)
> > at
> > org.apache.zeppelin.interpreter.ClassloaderInterpreter.interpret(Cla
> > ss
> > loaderInterpreter.java:57)
> > at
> > org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOp
> > en
> > Interpreter.java:93)
> > at
> > org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$Inter
> > pr
> > etJob.jobRun(RemoteInterpreterServer.java:300)
> > at org.apache.zeppelin.scheduler.Job.run(Job.java:169)
> > at
> > org.apache.zeppelin.scheduler.FIFOScheduler$1.run(FIFOScheduler.java
> > :1
> > 34) at
> > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:4
> > 71
> > ) at java.util.concurrent.FutureTask.run(FutureTask.java:262)
> > at
> > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask
> > .a
> > ccess$201(ScheduledThreadPoolExecutor.java:178)
> > at
> > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask
> > .r
> > un(ScheduledThreadPoolExecutor.java:292)
> > at
> > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor
> > .j
> > ava:1145)
> > at
> > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.
> > java:615) at java.lang.Thread.run(Thread.java:745)
> >
> >
> >
> > Best regards,
> >
> >
> >
> > Tao Li
> >
> >
> >
> >
> >
> >
> ???(,?
> > This email message (including any attachments) is confidential and
> > may be legally privileged. If you have received it by mistake,
> > please notify the sender by return email and delete this message
> > from your system. Any unauthorized use or dissemination of this
> > message in whole or in part is strictly prohibited. Envision Energy
> > Limited and all its subsidiaries shall not be liable for the
> > improper or incomplete transmission of the information contained in
> > this email nor for any delay in its receipt or damage to your
> > system. Envision Energy Limited does not guarantee the integrity of
> > this email message, nor that this email message is free of viruses, 
> > interceptions, or interference.
> >
>
>
>
>
> 本邮件(包括任何附件）内容机密并受法律保护。如果您意外地收到这封邮件，请回复通知发件人并从当前系统中删除本邮件。任何未经授权者，严禁使用并部
> 分或者全部的转发本条信息。任何未经授权的使用或传播都是被严格禁止的。远景能源与其分公司不对因不正确和不完整的转发此邮件包含的信息以及因任何因
> 邮件延迟或对你的系统造成的损害而负责。远景能源不能保证此邮件的真实完整性,也不能确定此邮件是否含有病毒或者监听程序。
> This email message (including any attachments) is confidential and may
> be legally privileged. If you have received it by mistake, please
> notify the sender by return email and delete this message from your
> system. Any unauthorized use or dissemination of this message in whole
> or in part is strictly prohibited. Envision Energy Limited and all its
> subsidiaries shall not be liable for the improper or incomplete
> transmission of the information contained in this email nor for any
> delay in its receipt or damage to your system. Envision Energy Limited
> does not guarantee the integrity of this email message, nor that this
> email message is free of viruses, interceptions, or interference.
>



本邮件(包括任何附件）内容机密并受法律保护。如果您意外地收到这封邮件，请回复通知发件人并从当前系统中删除本邮件。任何未经授权者，严禁使用并部分或者全部的转发本条信息。任何未经授权的使用或传播都是被严格禁止的。远景能源与其分公司不对因不正确和不完整的转发此邮件包含的信息以及因任何因邮件延迟或对你的系统造成的损害而负责。远景能源不能保证此邮件的真实完整性,也不能确定此邮件是否含有病毒或者监听程序。
This email message (including any attachment

Re: 答复: kylin interpreter for zeppelin

2016-05-04 Thread Jian Zhong 
all sql or only one specific sql?

On Wed, May 4, 2016 at 6:02 PM, Tao Li(Internship) <tao...@envisioncn.com>
wrote:

> Yes, the sql can work normally.
>
> -邮件原件-
> 发件人: Jian Zhong [mailto:hellowode...@gmail.com]
> 发送时间: 2016年5月4日 17:56
> 收件人: dev@kylin.apache.org
> 主题: Re: kylin interpreter for zeppelin
>
> Does your sql work normally in Kylin?
>
> On Wed, May 4, 2016 at 3:25 PM, Tao Li(Internship) <tao...@envisioncn.com>
> wrote:
>
> > Hi,
> >
> > I want to select from kylin by zeppelin, however I get an exception:
> >
> > java.lang.NullPointerException
> > at
> > org.apache.zeppelin.kylin.KylinInterpreter.formatResult(KylinInterpret
> > er.java:190)
> > at
> > org.apache.zeppelin.kylin.KylinInterpreter.executeQuery(KylinInterpret
> > er.java:170)
> > at
> > org.apache.zeppelin.kylin.KylinInterpreter.interpret(KylinInterpreter.
> > java:92)
> > at
> > org.apache.zeppelin.interpreter.ClassloaderInterpreter.interpret(Class
> > loaderInterpreter.java:57)
> > at
> > org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpen
> > Interpreter.java:93)
> > at
> > org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$Interpr
> > etJob.jobRun(RemoteInterpreterServer.java:300)
> > at org.apache.zeppelin.scheduler.Job.run(Job.java:169)
> > at
> > org.apache.zeppelin.scheduler.FIFOScheduler$1.run(FIFOScheduler.java:1
> > 34) at
> > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471
> > ) at java.util.concurrent.FutureTask.run(FutureTask.java:262)
> > at
> > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.a
> > ccess$201(ScheduledThreadPoolExecutor.java:178)
> > at
> > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.r
> > un(ScheduledThreadPoolExecutor.java:292)
> > at
> > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.j
> > ava:1145)
> > at
> > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.
> > java:615) at java.lang.Thread.run(Thread.java:745)
> >
> >
> >
> > Best regards,
> >
> >
> >
> > Tao Li
> >
> >
> >
> >
> >
> >
> ???(,?
> > This email message (including any attachments) is confidential and may
> > be legally privileged. If you have received it by mistake, please
> > notify the sender by return email and delete this message from your
> > system. Any unauthorized use or dissemination of this message in whole
> > or in part is strictly prohibited. Envision Energy Limited and all its
> > subsidiaries shall not be liable for the improper or incomplete
> > transmission of the information contained in this email nor for any
> > delay in its receipt or damage to your system. Envision Energy Limited
> > does not guarantee the integrity of this email message, nor that this
> > email message is free of viruses, interceptions, or interference.
> >
>
>
>
>
> 本邮件(包括任何附件）内容机密并受法律保护。如果您意外地收到这封邮件，请回复通知发件人并从当前系统中删除本邮件。任何未经授权者，严禁使用并部分或者全部的转发本条信息。任何未经授权的使用或传播都是被严格禁止的。远景能源与其分公司不对因不正确和不完整的转发此邮件包含的信息以及因任何因邮件延迟或对你的系统造成的损害而负责。远景能源不能保证此邮件的真实完整性,也不能确定此邮件是否含有病毒或者监听程序。
> This email message (including any attachments) is confidential and may be
> legally privileged. If you have received it by mistake, please notify the
> sender by return email and delete this message from your system. Any
> unauthorized use or dissemination of this message in whole or in part is
> strictly prohibited. Envision Energy Limited and all its subsidiaries shall
> not be liable for the improper or incomplete transmission of the
> information contained in this email nor for any delay in its receipt or
> damage to your system. Envision Energy Limited does not guarantee the
> integrity of this email message, nor that this email message is free of
> viruses, interceptions, or interference.
>

答复: kylin interpreter for zeppelin

2016-05-04 Thread Tao Li(Internship) 
Yes, the sql can work normally.

-邮件原件-
发件人: Jian Zhong [mailto:hellowode...@gmail.com]
发送时间: 2016年5月4日 17:56
收件人: dev@kylin.apache.org
主题: Re: kylin interpreter for zeppelin

Does your sql work normally in Kylin?

On Wed, May 4, 2016 at 3:25 PM, Tao Li(Internship) <tao...@envisioncn.com>
wrote:

> Hi,
>
> I want to select from kylin by zeppelin, however I get an exception:
>
> java.lang.NullPointerException
> at
> org.apache.zeppelin.kylin.KylinInterpreter.formatResult(KylinInterpret
> er.java:190)
> at
> org.apache.zeppelin.kylin.KylinInterpreter.executeQuery(KylinInterpret
> er.java:170)
> at
> org.apache.zeppelin.kylin.KylinInterpreter.interpret(KylinInterpreter.
> java:92)
> at
> org.apache.zeppelin.interpreter.ClassloaderInterpreter.interpret(Class
> loaderInterpreter.java:57)
> at
> org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpen
> Interpreter.java:93)
> at
> org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$Interpr
> etJob.jobRun(RemoteInterpreterServer.java:300)
> at org.apache.zeppelin.scheduler.Job.run(Job.java:169)
> at
> org.apache.zeppelin.scheduler.FIFOScheduler$1.run(FIFOScheduler.java:1
> 34) at
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471
> ) at java.util.concurrent.FutureTask.run(FutureTask.java:262)
> at
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.a
> ccess$201(ScheduledThreadPoolExecutor.java:178)
> at
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.r
> un(ScheduledThreadPoolExecutor.java:292)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.j
> ava:1145)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.
> java:615) at java.lang.Thread.run(Thread.java:745)
>
>
>
> Best regards,
>
>
>
> Tao Li
>
>
>
>
>
> ???(,?
> This email message (including any attachments) is confidential and may
> be legally privileged. If you have received it by mistake, please
> notify the sender by return email and delete this message from your
> system. Any unauthorized use or dissemination of this message in whole
> or in part is strictly prohibited. Envision Energy Limited and all its
> subsidiaries shall not be liable for the improper or incomplete
> transmission of the information contained in this email nor for any
> delay in its receipt or damage to your system. Envision Energy Limited
> does not guarantee the integrity of this email message, nor that this
> email message is free of viruses, interceptions, or interference.
>



本邮件(包括任何附件）内容机密并受法律保护。如果您意外地收到这封邮件，请回复通知发件人并从当前系统中删除本邮件。任何未经授权者，严禁使用并部分或者全部的转发本条信息。任何未经授权的使用或传播都是被严格禁止的。远景能源与其分公司不对因不正确和不完整的转发此邮件包含的信息以及因任何因邮件延迟或对你的系统造成的损害而负责。远景能源不能保证此邮件的真实完整性,也不能确定此邮件是否含有病毒或者监听程序。
This email message (including any attachments) is confidential and may be 
legally privileged. If you have received it by mistake, please notify the 
sender by return email and delete this message from your system. Any 
unauthorized use or dissemination of this message in whole or in part is 
strictly prohibited. Envision Energy Limited and all its subsidiaries shall not 
be liable for the improper or incomplete transmission of the information 
contained in this email nor for any delay in its receipt or damage to your 
system. Envision Energy Limited does not guarantee the integrity of this email 
message, nor that this email message is free of viruses, interceptions, or 
interference.

Re: kylin interpreter for zeppelin

2016-05-04 Thread Jian Zhong 
Does your sql work normally in Kylin?

On Wed, May 4, 2016 at 3:25 PM, Tao Li(Internship) 
wrote:

> Hi,
>
> I want to select from kylin by zeppelin, however I get an exception:
>
> java.lang.NullPointerException
> at
> org.apache.zeppelin.kylin.KylinInterpreter.formatResult(KylinInterpreter.java:190)
> at
> org.apache.zeppelin.kylin.KylinInterpreter.executeQuery(KylinInterpreter.java:170)
> at
> org.apache.zeppelin.kylin.KylinInterpreter.interpret(KylinInterpreter.java:92)
> at
> org.apache.zeppelin.interpreter.ClassloaderInterpreter.interpret(ClassloaderInterpreter.java:57)
> at
> org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:93)
> at
> org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:300)
> at org.apache.zeppelin.scheduler.Job.run(Job.java:169)
> at
> org.apache.zeppelin.scheduler.FIFOScheduler$1.run(FIFOScheduler.java:134)
> at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
> at java.util.concurrent.FutureTask.run(FutureTask.java:262)
> at
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)
> at
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> at java.lang.Thread.run(Thread.java:745)
>
>
>
> Best regards,
>
>
>
> Tao Li
>
>
>
>
>
> ???(,?
> This email message (including any attachments) is confidential and may be
> legally privileged. If you have received it by mistake, please notify the
> sender by return email and delete this message from your system. Any
> unauthorized use or dissemination of this message in whole or in part is
> strictly prohibited. Envision Energy Limited and all its subsidiaries shall
> not be liable for the improper or incomplete transmission of the
> information contained in this email nor for any delay in its receipt or
> damage to your system. Envision Energy Limited does not guarantee the
> integrity of this email message, nor that this email message is free of
> viruses, interceptions, or interference.
>