Re: Setting default interpreter at notebook level

[Krishnaprasad A S]

Hi Abul,
 You can change the default interpreter for each notebook through zeppelin
web UI.
Go to the notebook and then settings(up right corner), there you can find
Interpreter binding option. You can reorder the interpreters by drag and
drop. The first one will be default.

Hope this helps.

Regards,
Krishnaprasad

On Mon, Jul 25, 2016 at 12:01 PM, Abul Basar  wrote:

> I know there is a way to set up a default interpreter at Zepplin using 
> zeppelin.interpreters
> property in conf/zeppelin-site.xml. The setting is global is nature.
>
> But, is it possible to create a notebook level setting for interpreter?
> For example, in a notebook I want to set the default interpreter at R so
> that for every code block i do not have to start with "%spark.r", while on
> another notebook, I want to set the default interpreter as Scala.
>
> I am using v0.6
>
> AB
>



-- 
Krishnaprasad A S
Lead Engineer
Flytxt
Skype: krishnaprasadas
M: +91 8907209454 | O: +91 471.3082753 | F: +91 471.2700202
www.flytxt.com | Visit our blog  | Follow us
 | Connect on LinkedIn

Re: Setting default interpreter at notebook level

[Abul Basar]

Hi Krishnaprasad,

Yes, I have played around with that feature. What I found is "spark,
pyspark, r, sql" are grouped together. I use Zeppelin for Spark projects.
So I need to set one of these sub-categories as default. Most often I use
scala for Spark. But I should be able to create a notebook using r (which
essentially is SparkR) as a default. Please let me know if I am missing
something.

Thanks!
- AB

On Mon, Jul 25, 2016 at 12:45 PM, Krishnaprasad A S <
krishna.pra...@flytxt.com> wrote:

> Hi Abul,
>  You can change the default interpreter for each notebook through zeppelin
> web UI.
> Go to the notebook and then settings(up right corner), there you can find
> Interpreter binding option. You can reorder the interpreters by drag and
> drop. The first one will be default.
>
> Hope this helps.
>
> Regards,
> Krishnaprasad
>
> On Mon, Jul 25, 2016 at 12:01 PM, Abul Basar  wrote:
>
>> I know there is a way to set up a default interpreter at Zepplin using 
>> zeppelin.interpreters
>> property in conf/zeppelin-site.xml. The setting is global is nature.
>>
>> But, is it possible to create a notebook level setting for interpreter?
>> For example, in a notebook I want to set the default interpreter at R so
>> that for every code block i do not have to start with "%spark.r", while on
>> another notebook, I want to set the default interpreter as Scala.
>>
>> I am using v0.6
>>
>> AB
>>
>
>
>
> --
> Krishnaprasad A S
> Lead Engineer
> Flytxt
> Skype: krishnaprasadas
> M: +91 8907209454 | O: +91 471.3082753 | F: +91 471.2700202
> www.flytxt.com | Visit our blog  | Follow us
>  | Connect on LinkedIn
> 
>

Re: Filter query results by current user

[Panayotis Trapatsas]

Thanks moon but this way all users need to have write permissions to run
the report and every time a user runs the reports with his name all other
instances are updated with this users data.

I am trying to find a way for a user to filter his own data without
affecting other users viewing the report at the same time.

On Sun, Jul 24, 2016 at 11:15 AM, moon soo Lee  wrote:

> How about something like
>
> %spark
> val userName = z.getInterpreterContext.getAuthenticationInfo.getUser
> z.show(sqlContext.sql(s"""select * from data where user="${userName}" """))
>
> Thanks,
> moon
>
> On Sun, Jul 24, 2016 at 3:25 PM Panayotis Trapatsas <
> p.trapat...@pamediakopes.gr> wrote:
>
>> Does the angular way work even if the user has read-only permissions? Is
>> there a way to do this without giving the user write permissions to
>> notebook?
>>
>> On Sat, Jul 23, 2016 at 3:02 AM, Corneau Damien 
>> wrote:
>>
>>> Hi,
>>>
>>> Maybe Dynamic Forms (
>>> https://zeppelin.apache.org/docs/0.7.0-SNAPSHOT/manual/dynamicform.html)
>>> could help in this case?
>>> It allows you to add some conditioning in your queries.
>>> In this case, the user would be able to select themselves and rerun the
>>> query.
>>>
>>> If you want to do it on a whole Notebook level, then binding values
>>> could be another way (
>>> https://zeppelin.apache.org/docs/0.7.0-SNAPSHOT/displaysystem/back-end-angular.html
>>> )
>>>
>>> On Sat, Jul 23, 2016 at 1:58 AM, Panayotis Trapatsas <
>>> p.trapat...@pamediakopes.gr> wrote:
>>>
 Hi,

 I know I can get current user with
 'z.getInterpreterContext.getAuthenticationInfo.getUser' but is there a way
 to filter query results by the username of the current user?

 E.g. there are different salesman and each one wants to log in to
 Zeppelin and see only his own sales.

 --

 [image: e-Travel SA] 

 Panayotis Trapatsas / Lead Data Engineer
 p.trapat...@pamediakopes.gr / +30 6979493921

 e-Travel SA
 Office: +30 213 0184000/ Fax: +30 211 8001181
 Leof. Kifisias 7, AmpelokipiAthens 115 23, Greece
 pamediakopes.gr |  trip.ru |  airtickets24.com |  fantasticgreece.com

 [image: Google +] [image:
 Stack Overflow] 

>>>
>>>
>>
>>
>> --
>>
>> [image: e-Travel SA] 
>>
>> Panayotis Trapatsas / Lead Data Engineer
>> p.trapat...@pamediakopes.gr / +30 6979493921
>>
>> e-Travel SA
>> Office: +30 213 0184000/ Fax: +30 211 8001181
>> Leof. Kifisias 7, AmpelokipiAthens 115 23, Greece
>> pamediakopes.gr |  trip.ru |  airtickets24.com |  fantasticgreece.com
>>
>> [image: Google +] [image:
>> Stack Overflow] 
>>
>


-- 

[image: e-Travel SA] 

Panayotis Trapatsas / Lead Data Engineer
p.trapat...@pamediakopes.gr / +30 6979493921

e-Travel SA
Office: +30 213 0184000/ Fax: +30 211 8001181
Leof. Kifisias 7, AmpelokipiAthens 115 23, Greece
pamediakopes.gr |  trip.ru |  airtickets24.com |  fantasticgreece.com

[image: Google +] [image:
Stack Overflow] 

Re: Filter query results by current user

[Corneau Damien]

There was a thread opened not that long ago in the mailing list with a
similar use case.

In short, there is currently no way to have changes made without those
changes being saved.

On Mon, Jul 25, 2016 at 6:25 PM, Panayotis Trapatsas <
p.trapat...@pamediakopes.gr> wrote:

> Thanks moon but this way all users need to have write permissions to run
> the report and every time a user runs the reports with his name all other
> instances are updated with this users data.
>
> I am trying to find a way for a user to filter his own data without
> affecting other users viewing the report at the same time.
>
> On Sun, Jul 24, 2016 at 11:15 AM, moon soo Lee  wrote:
>
>> How about something like
>>
>> %spark
>> val userName = z.getInterpreterContext.getAuthenticationInfo.getUser
>> z.show(sqlContext.sql(s"""select * from data where user="${userName}"
>> """))
>>
>> Thanks,
>> moon
>>
>> On Sun, Jul 24, 2016 at 3:25 PM Panayotis Trapatsas <
>> p.trapat...@pamediakopes.gr> wrote:
>>
>>> Does the angular way work even if the user has read-only permissions? Is
>>> there a way to do this without giving the user write permissions to
>>> notebook?
>>>
>>> On Sat, Jul 23, 2016 at 3:02 AM, Corneau Damien 
>>> wrote:
>>>
 Hi,

 Maybe Dynamic Forms (
 https://zeppelin.apache.org/docs/0.7.0-SNAPSHOT/manual/dynamicform.html)
 could help in this case?
 It allows you to add some conditioning in your queries.
 In this case, the user would be able to select themselves and rerun the
 query.

 If you want to do it on a whole Notebook level, then binding values
 could be another way (
 https://zeppelin.apache.org/docs/0.7.0-SNAPSHOT/displaysystem/back-end-angular.html
 )

 On Sat, Jul 23, 2016 at 1:58 AM, Panayotis Trapatsas <
 p.trapat...@pamediakopes.gr> wrote:

> Hi,
>
> I know I can get current user with
> 'z.getInterpreterContext.getAuthenticationInfo.getUser' but is there a way
> to filter query results by the username of the current user?
>
> E.g. there are different salesman and each one wants to log in to
> Zeppelin and see only his own sales.
>
> --
>
> [image: e-Travel SA] 
>
> Panayotis Trapatsas / Lead Data Engineer
> p.trapat...@pamediakopes.gr / +30 6979493921
>
> e-Travel SA
> Office: +30 213 0184000/ Fax: +30 211 8001181
> Leof. Kifisias 7, AmpelokipiAthens 115 23, Greece
> pamediakopes.gr |  trip.ru |  airtickets24.com |  fantasticgreece.com
>
> [image: Google +] [image:
> Stack Overflow] 
>


>>>
>>>
>>> --
>>>
>>> [image: e-Travel SA] 
>>>
>>> Panayotis Trapatsas / Lead Data Engineer
>>> p.trapat...@pamediakopes.gr / +30 6979493921
>>>
>>> e-Travel SA
>>> Office: +30 213 0184000/ Fax: +30 211 8001181
>>> Leof. Kifisias 7, AmpelokipiAthens 115 23, Greece
>>> pamediakopes.gr |  trip.ru |  airtickets24.com |  fantasticgreece.com
>>>
>>> [image: Google +] [image:
>>> Stack Overflow] 
>>>
>>
>
>
> --
>
> [image: e-Travel SA] 
>
> Panayotis Trapatsas / Lead Data Engineer
> p.trapat...@pamediakopes.gr / +30 6979493921
>
> e-Travel SA
> Office: +30 213 0184000/ Fax: +30 211 8001181
> Leof. Kifisias 7, AmpelokipiAthens 115 23, Greece
> pamediakopes.gr |  trip.ru |  airtickets24.com |  fantasticgreece.com
>
> [image: Google +] [image:
> Stack Overflow] 
>

Re: Setting default interpreter at notebook level

[Jongyoul Lee]

Hello Abul,

Changing orders within a group dynamically is not supported yet. You can
change it by making interpreter-setting.json in a resources directory In a
interpreter-setting.json, you can find a property named `default`. If it's
true, That will be a default interpreter in a group. If you don't want to
compile Zeppelin again, copy interpreter-setting.json into
interpreter/spark/ and open it and change it. It will also have a same
effect.

Hope this help,
Jongyoul

On Mon, Jul 25, 2016 at 4:39 PM, Abul Basar  wrote:

> Hi Krishnaprasad,
>
> Yes, I have played around with that feature. What I found is "spark,
> pyspark, r, sql" are grouped together. I use Zeppelin for Spark projects.
> So I need to set one of these sub-categories as default. Most often I use
> scala for Spark. But I should be able to create a notebook using r (which
> essentially is SparkR) as a default. Please let me know if I am missing
> something.
>
> Thanks!
> - AB
>
> On Mon, Jul 25, 2016 at 12:45 PM, Krishnaprasad A S <
> krishna.pra...@flytxt.com> wrote:
>
>> Hi Abul,
>>  You can change the default interpreter for each notebook through
>> zeppelin web UI.
>> Go to the notebook and then settings(up right corner), there you can find
>> Interpreter binding option. You can reorder the interpreters by drag and
>> drop. The first one will be default.
>>
>> Hope this helps.
>>
>> Regards,
>> Krishnaprasad
>>
>> On Mon, Jul 25, 2016 at 12:01 PM, Abul Basar  wrote:
>>
>>> I know there is a way to set up a default interpreter at Zepplin using 
>>> zeppelin.interpreters
>>> property in conf/zeppelin-site.xml. The setting is global is nature.
>>>
>>> But, is it possible to create a notebook level setting for interpreter?
>>> For example, in a notebook I want to set the default interpreter at R so
>>> that for every code block i do not have to start with "%spark.r", while on
>>> another notebook, I want to set the default interpreter as Scala.
>>>
>>> I am using v0.6
>>>
>>> AB
>>>
>>
>>
>>
>> --
>> Krishnaprasad A S
>> Lead Engineer
>> Flytxt
>> Skype: krishnaprasadas
>> M: +91 8907209454 | O: +91 471.3082753 | F: +91 471.2700202
>> www.flytxt.com | Visit our blog  | Follow us
>>  | Connect on LinkedIn
>> 
>>
>
>


-- 
이종열, Jongyoul Lee, 李宗烈
http://madeng.net

Re: Filter query results by current user

[Panayotis Trapatsas]

Is there a way to open a separate interpreter for each different user that
logs in the notebook?

On Mon, Jul 25, 2016 at 12:36 PM, Corneau Damien 
wrote:

> There was a thread opened not that long ago in the mailing list with a
> similar use case.
>
> In short, there is currently no way to have changes made without those
> changes being saved.
>
> On Mon, Jul 25, 2016 at 6:25 PM, Panayotis Trapatsas <
> p.trapat...@pamediakopes.gr> wrote:
>
>> Thanks moon but this way all users need to have write permissions to run
>> the report and every time a user runs the reports with his name all other
>> instances are updated with this users data.
>>
>> I am trying to find a way for a user to filter his own data without
>> affecting other users viewing the report at the same time.
>>
>> On Sun, Jul 24, 2016 at 11:15 AM, moon soo Lee  wrote:
>>
>>> How about something like
>>>
>>> %spark
>>> val userName = z.getInterpreterContext.getAuthenticationInfo.getUser
>>> z.show(sqlContext.sql(s"""select * from data where user="${userName}"
>>> """))
>>>
>>> Thanks,
>>> moon
>>>
>>> On Sun, Jul 24, 2016 at 3:25 PM Panayotis Trapatsas <
>>> p.trapat...@pamediakopes.gr> wrote:
>>>
 Does the angular way work even if the user has read-only permissions?
 Is there a way to do this without giving the user write permissions to
 notebook?

 On Sat, Jul 23, 2016 at 3:02 AM, Corneau Damien 
 wrote:

> Hi,
>
> Maybe Dynamic Forms (
> https://zeppelin.apache.org/docs/0.7.0-SNAPSHOT/manual/dynamicform.html)
> could help in this case?
> It allows you to add some conditioning in your queries.
> In this case, the user would be able to select themselves and rerun
> the query.
>
> If you want to do it on a whole Notebook level, then binding values
> could be another way (
> https://zeppelin.apache.org/docs/0.7.0-SNAPSHOT/displaysystem/back-end-angular.html
> )
>
> On Sat, Jul 23, 2016 at 1:58 AM, Panayotis Trapatsas <
> p.trapat...@pamediakopes.gr> wrote:
>
>> Hi,
>>
>> I know I can get current user with
>> 'z.getInterpreterContext.getAuthenticationInfo.getUser' but is there a 
>> way
>> to filter query results by the username of the current user?
>>
>> E.g. there are different salesman and each one wants to log in to
>> Zeppelin and see only his own sales.
>>
>> --
>>
>> [image: e-Travel SA] 
>>
>> Panayotis Trapatsas / Lead Data Engineer
>> p.trapat...@pamediakopes.gr / +30 6979493921
>>
>> e-Travel SA
>> Office: +30 213 0184000/ Fax: +30 211 8001181
>> Leof. Kifisias 7, AmpelokipiAthens 115 23, Greece
>> pamediakopes.gr |  trip.ru |  airtickets24.com |  fantasticgreece.com
>>
>> [image: Google +] 
>> [image:
>> Stack Overflow] 
>>
>
>


 --

 [image: e-Travel SA] 

 Panayotis Trapatsas / Lead Data Engineer
 p.trapat...@pamediakopes.gr / +30 6979493921

 e-Travel SA
 Office: +30 213 0184000/ Fax: +30 211 8001181
 Leof. Kifisias 7, AmpelokipiAthens 115 23, Greece
 pamediakopes.gr |  trip.ru |  airtickets24.com |  fantasticgreece.com

 [image: Google +] [image:
 Stack Overflow] 

>>>
>>
>>
>> --
>>
>> [image: e-Travel SA] 
>>
>> Panayotis Trapatsas / Lead Data Engineer
>> p.trapat...@pamediakopes.gr / +30 6979493921
>>
>> e-Travel SA
>> Office: +30 213 0184000/ Fax: +30 211 8001181
>> Leof. Kifisias 7, AmpelokipiAthens 115 23, Greece
>> pamediakopes.gr |  trip.ru |  airtickets24.com |  fantasticgreece.com
>>
>> [image: Google +] [image:
>> Stack Overflow] 
>>
>
>


-- 

[image: e-Travel SA] 

Panayotis Trapatsas / Lead Data Engineer
p.trapat...@pamediakopes.gr / +30 6979493921

e-Travel SA
Office: +30 213 0184000/ Fax: +30 211 8001181
Leof. Kifisias 7, AmpelokipiAthens 115 23, Greece
pamediakopes.gr |  trip.ru |  airtickets24.com |  fantasticgreece.com

[image: Google +] [image:
Stack Overflow] 

Re: Zeppelin multi-user dashboards

[Panayotis Trapatsas]

+1. Do we have any updates on this issue?

On Thu, Jun 30, 2016 at 10:23 AM, Skanda  wrote:

> Hi All,
>
> I have the same requirement as that of Ashish, wherein the same Dashboard
> will be used by multiple users and each user will look at the charts by
> applying different filters. Can somebody from the core Zeppelin team
> provide the right way to have this feature built in Zeppelin?
>
> Regards,
> Skanda
>
> On Thu, Jun 23, 2016 at 2:24 PM, Andrea Santurbano 
> wrote:
>
>> As Ashish said:
>>
>> *For Zeppelin, this is true that if the view is different from each user,
>> then it is not the same notebook anymore. But from a dashboard perspective,
>> multiple users work on the same dashboard, viewing different data and we
>> still call it the same dashboard.*
>>
>> This is a common use case in most of organizations. We need to find a way
>> in order to make it work.
>> There is someone on zeppelin core team that can answer or give a hint on
>> that?
>>
>> Il giorno ven 17 giu 2016 alle ore 10:10 Corneau Damien <
>> cornead...@gmail.com> ha scritto:
>>
>>> That's why I was talking about easy way VS more complicated changes.
>>> The idea behind the easy way was to bypass the server save and send the
>>> result to the view directly.
>>>
>>> Honestly, I'm not knowledgeable enough to give an estimation of how hard
>>> caching of previous results, or other methods would be.
>>>
>>>
>>>
>>> On Fri, Jun 17, 2016 at 5:04 PM, ashish rawat 
>>> wrote:
>>>
 Yes, that looks like a good way to do it. Also, you mentioned an
 important point that user would have to stay on the page for query to
 finish and the results would be flushed when moving to a new page. This is
 typically the case in dashboard that queries have very small response times
 and users wait for the results. But still, as per my understanding,
 dashboards do retain the last viewed data (through browser cache) and also
 allow people to navigate to some other screen while the data is getting
 loaded.

 Is there any limitation in Zeppelin, which would not let browser cache
 the view for the current user session? Is it because Zeppelin web always
 asks for a fresh copy of the notebook from server, whenever user switches
 notebooks? Perhaps, keeping the changed state of the notebook in the user
 session at the server side might resolve this?

 Regards,
 Ashish
 On Jun 17, 2016 1:09 PM, "Corneau Damien"  wrote:

 The easy way to do that would be:
 Have an option on the notebook (automatic-save vs manual save), manual
 save could be set as an Admin command only, and once activated any change
 on the notebook wouldn't be propagated to others or saved in the note.json

 One drawback however would be that you would be forced to stay on the
 page until the query is finished, and the modification would be flushed
 once you visit a different page.

 Otherwise, it would probably need some heavy changes to the Notebook
 Repo and saving mechanism etc...



 On Fri, Jun 17, 2016 at 4:14 PM, ashish rawat 
 wrote:

> Thanks Vincent. I haven't explore git storage much, but it's important
> for us that the cost the maintaining a changing notebook and a changing
> user list shouldn't be high. If we have 20 dashboard users and there are
> minor changes in dashboard functionality every two weeks, then there 
> should
> not be a need to make changes to all the 20 copies manually. Apart from
> taking time, this would invariably result in some human error and
> variations in copies of the same notebook. Moreover maintaining user
> permissions, also become complex with so many copies.
>
> The overall user management and authorization may become non-trivial
> to manage if we start creating copies for what should be just one 
> notebook.
>
> Regards,
> Ashish
>
> On Fri, Jun 17, 2016 at 11:37 AM, vincent gromakowski <
> vincent.gromakow...@gmail.com> wrote:
>
>> Isnt it acheivable via git repository ? A kind of git clone to get an
>> indépendant copy of the notebook?
>> Le 17 juin 2016 4:18 AM, "Corneau Damien"  a
>> écrit :
>>
>>> It is simple Read/Write
>>> Some people can edit, some people can see.
>>>
>>> By essence, if the view is different from each user, then it is not
>>> the same notebook anymore.
>>> Being able to have a different results for each user saved somewhere
>>> so that they can read it, seems like a big overhead.
>>>
>>> On Fri, Jun 17, 2016 at 6:35 AM, ashish rawat 
>>> wrote:
>>>
 Hi Damien,

 Does the read mode work as I described above i.e. multiple users
 can work with selectors and input boxes of the same notebook and view
 different outputs?
 My assumption is that read will only allow users to just view the
 notebook

Fwd: Apache Zeppelin 0.6.0 Installation on Windows

[VIVEK NARAYANASETTY]

Hi All,

Can any one suggest how to Install/Configure zeppelin on windows.

FYI, I have downloaded pre built Binary Package Release 0.6.0 and tried to
start zeppelin as mentioned in the documentation(refer below URL). But no
luck. Please find the attached error log for more details.

https://zeppelin.apache.org/docs/0.6.0/install/install.html#starting-apache-zeppelin-with-command-line

Starting Apache Zeppelin with Command Line

If you are using Windows

bin\zeppelin.cmd

After successful start, visit http://localhost:8080 with your web browser.


Appreciate if someone can give quick reply on this.

-- 
Thanks & Regards
*Vivek Narayanasetty*
+91 9902862499




*Go Green: Think before you print this e-mail or its attachment. You can
save paper if you do not really need to print.*


zeppelin-VivekNarayanasetty-D330N6C2.log
Description: Binary data

Cannot use Hive Interpreter in Zeppelin 0.6.0 - Hive class java.lang.ClassNotFoundException

[Kevin Verhoeven]

I built Zeppelin 0.6.0 against CDH 5.7.1 using the following command:

sudo mvn clean package -Pspark-1.6 -Dhadoop.version=2.6.0-cdh5.7.1 -Phadoop-2.6 
-Pvendor-repo –DskipTests

Zeppelin started successfully. I then created an Interpreter for Hive using the 
Jdbc Interpreter. I created a new Notebook, bound to the Hive Interpreter, and 
ran a Paragraph. The Hive query failed with the following error message:

org.apache.hive.jdbc.HiveDriver
class java.lang.ClassNotFoundException
java.net.URLClassLoader.findClass(URLClassLoader.java:381)
java.lang.ClassLoader.loadClass(ClassLoader.java:424)
sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331)
java.lang.ClassLoader.loadClass(ClassLoader.java:357)
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Class.java:264)
org.apache.zeppelin.jdbc.JDBCInterpreter.getConnection(JDBCInterpreter.java:224)
org.apache.zeppelin.jdbc.JDBCInterpreter.getStatement(JDBCInterpreter.java:237)
org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(JDBCInterpreter.java:306)
org.apache.zeppelin.jdbc.JDBCInterpreter.interpret(JDBCInterpreter.java:412)
org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:94)
org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:383)
org.apache.zeppelin.scheduler.Job.run(Job.java:176)
org.apache.zeppelin.scheduler.ParallelScheduler$JobRunner.run(ParallelScheduler.java:162)
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
java.util.concurrent.FutureTask.run(FutureTask.java:266)
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
java.lang.Thread.run(Thread.java:745)

The command I ran is very simple:

%hive
show databases

Do you have any recommendations?

Regards,

Kevin

Re: Cannot use Hive Interpreter in Zeppelin 0.6.0 - Hive class java.lang.ClassNotFoundException

[Jeff Zhang]

You need to specfiy the following 2 dependencies, see the doc here
http://zeppelin.apache.org/docs/0.6.0/interpreter/hive.html

org.apache.hive:hive-jdbc:0.14.0
org.apache.hadoop:hadoop-common:2.6.0


On Tue, Jul 26, 2016 at 7:30 AM, Kevin Verhoeven 
wrote:

> I built Zeppelin 0.6.0 against CDH 5.7.1 using the following command:
>
>
>
> sudo mvn clean package -Pspark-1.6 -Dhadoop.version=2.6.0-cdh5.7.1
> -Phadoop-2.6 -Pvendor-repo –DskipTests
>
>
>
> Zeppelin started successfully. I then created an Interpreter for Hive
> using the Jdbc Interpreter. I created a new Notebook, bound to the Hive
> Interpreter, and ran a Paragraph. The Hive query failed with the following
> error message:
>
>
>
> org.apache.hive.jdbc.HiveDriver
>
> class java.lang.ClassNotFoundException
>
> java.net.URLClassLoader.findClass(URLClassLoader.java:381)
>
> java.lang.ClassLoader.loadClass(ClassLoader.java:424)
>
> sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331)
>
> java.lang.ClassLoader.loadClass(ClassLoader.java:357)
>
> java.lang.Class.forName0(Native Method)
>
> java.lang.Class.forName(Class.java:264)
>
>
> org.apache.zeppelin.jdbc.JDBCInterpreter.getConnection(JDBCInterpreter.java:224)
>
>
> org.apache.zeppelin.jdbc.JDBCInterpreter.getStatement(JDBCInterpreter.java:237)
>
>
> org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(JDBCInterpreter.java:306)
>
>
> org.apache.zeppelin.jdbc.JDBCInterpreter.interpret(JDBCInterpreter.java:412)
>
>
> org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:94)
>
>
> org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:383)
>
> org.apache.zeppelin.scheduler.Job.run(Job.java:176)
>
>
> org.apache.zeppelin.scheduler.ParallelScheduler$JobRunner.run(ParallelScheduler.java:162)
>
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
>
> java.util.concurrent.FutureTask.run(FutureTask.java:266)
>
>
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
>
>
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
>
>
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>
>
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>
> java.lang.Thread.run(Thread.java:745)
>
>
>
> The command I ran is very simple:
>
>
>
> %hive
>
> show databases
>
>
>
> Do you have any recommendations?
>
>
>
> Regards,
>
>
>
> Kevin
>



-- 
Best Regards

Jeff Zhang

RE: Cannot use Hive Interpreter in Zeppelin 0.6.0 - Hive class java.lang.ClassNotFoundException

[Kevin Verhoeven]

That worked successfully, thanks for the quick response!

Kevin

From: Jeff Zhang [mailto:zjf...@gmail.com]
Sent: Monday, July 25, 2016 4:35 PM
To: users@zeppelin.apache.org
Subject: Re: Cannot use Hive Interpreter in Zeppelin 0.6.0 - Hive class 
java.lang.ClassNotFoundException

You need to specfiy the following 2 dependencies, see the doc here 
http://zeppelin.apache.org/docs/0.6.0/interpreter/hive.html


org.apache.hive:hive-jdbc:0.14.0

org.apache.hadoop:hadoop-common:2.6.0


On Tue, Jul 26, 2016 at 7:30 AM, Kevin Verhoeven 
mailto:kevin.verhoe...@ds-iq.com>> wrote:
I built Zeppelin 0.6.0 against CDH 5.7.1 using the following command:

sudo mvn clean package -Pspark-1.6 -Dhadoop.version=2.6.0-cdh5.7.1 -Phadoop-2.6 
-Pvendor-repo –DskipTests

Zeppelin started successfully. I then created an Interpreter for Hive using the 
Jdbc Interpreter. I created a new Notebook, bound to the Hive Interpreter, and 
ran a Paragraph. The Hive query failed with the following error message:

org.apache.hive.jdbc.HiveDriver
class java.lang.ClassNotFoundException
java.net.URLClassLoader.findClass(URLClassLoader.java:381)
java.lang.ClassLoader.loadClass(ClassLoader.java:424)
sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331)
java.lang.ClassLoader.loadClass(ClassLoader.java:357)
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Class.java:264)
org.apache.zeppelin.jdbc.JDBCInterpreter.getConnection(JDBCInterpreter.java:224)
org.apache.zeppelin.jdbc.JDBCInterpreter.getStatement(JDBCInterpreter.java:237)
org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(JDBCInterpreter.java:306)
org.apache.zeppelin.jdbc.JDBCInterpreter.interpret(JDBCInterpreter.java:412)
org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:94)
org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:383)
org.apache.zeppelin.scheduler.Job.run(Job.java:176)
org.apache.zeppelin.scheduler.ParallelScheduler$JobRunner.run(ParallelScheduler.java:162)
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
java.util.concurrent.FutureTask.run(FutureTask.java:266)
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
java.lang.Thread.run(Thread.java:745)

The command I ran is very simple:

%hive
show databases

Do you have any recommendations?

Regards,

Kevin



--
Best Regards

Jeff Zhang

Re: Chrome not displaying Login element with authentication enabled

[Samuel Lachterman]

Hi Ahyoung,

Thanks for this guidance, that’s interesting regarding the browser cache.

I was able to fix this using the idea in this HCC 
post.
 Once I changed the zeppelin.server.addr value to the hostname to which the 
loopback address points in /etc/hosts, the behavior in Chrome is as expected 
when rendering the page.

I have a tangential question regarding 
https://zeppelin.apache.org/docs/0.6.0/security/shiroauthentication.html (which 
appears very similar to the content in the SECURITY-README.md I cited), it 
doesn’t specify whether the following line should be commented or not with 
authentication enabled:

/api/version = anon

I think it would be clearer for the documentation to specify that one way or 
the other.

Best regards,

Sam Lachterman
Solutions Engineer
slachter...@hortonworks.com
(608) 520-3428
[cid:F318C1FF-02CC-478E-BDCB-7A6EA6FB9833]


From: Ahyoung Ryu mailto:ahyoungry...@gmail.com>>
Reply-To: "users@zeppelin.apache.org" 
mailto:users@zeppelin.apache.org>>
Date: Monday, July 25, 2016 at 4:48 PM
To: "users@zeppelin.apache.org" 
mailto:users@zeppelin.apache.org>>
Subject: Re: Chrome not displaying Login element with authentication enabled

Hi Sam,

I tried as you said in my local, but can start Zeppelin server with Shiro 
authentication. The Chrome browser screenshot image that you provided seems 
outdated version of Zeppelin UI. Have you run former version of Zeppelin in 
your Chrome browser(i.e. Zeppelin-0.5.6)? It seems like Chrome browser cache or 
something. Zeppelin UI changed in 0.6.0 ver since this 
PR. Please clean your browser 
cache first. Your Firefox browser shows Zeppelin-0.6.0 UI properly.

Regarding Shiro authentication, could you check whether Zeppelin server started 
well or not with Zeppelin log file under ZEPPELIN_HOME/logs/ dir? And I would 
recommend you to refer this guide 
docs 
:)

Thanks,
Ahyoung

2016년 7월 26일 (화) 오전 12:28, Samuel Lachterman 
mailto:slachter...@hortonworks.com>>님이 작성:
Hello,

I am using the 0.60 Zeppelin binaries and I have enabled authentication using 
the directions 
here. In 
Firefox 41.0.1 (on OS X 10.11.5), I am seeing the expected behavior where users 
are required to login (the Login UI element renders in the upper right corner).

However, in Chrome 51.0.2704, this Login button does not render and I see no 
way to log in. I also see the following message in the Developer Console: 
http://127.0.0.1:9995/api/login Failed to load resource: the server responded 
with a status of 500 (Server Error)

Should this be logged as an issue?

Chrome:
[cid:E337FADE-FB78-41C7-BD71-D0A86BB24392]


Firefox:
[cid:D2237D9D-4952-424F-9DBF-561168C5FFCA]

Thanks,

Sam Lachterman
Solutions Engineer
slachter...@hortonworks.com
(608) 520-3428
[cid:17596D7D-57D5-4D8A-97C7-63628B587B93]