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 <m...@apache.org> 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 <cornead...@gmail.com>
>> 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] <http://pamediakopes.gr/>
>>>>
>>>> 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 +] <https://plus.google.com/u/0/+PanayotisTrapatsas>[image:
>>>> Stack Overflow] <http://stackoverflow.com/users/2618541/panayotis>
>>>>
>>>
>>>
>>
>>
>> --
>>
>> [image: e-Travel SA] <http://pamediakopes.gr/>
>>
>> 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 +] <https://plus.google.com/u/0/+PanayotisTrapatsas>[image:
>> Stack Overflow] <http://stackoverflow.com/users/2618541/panayotis>
>>
>


-- 

[image: e-Travel SA] <http://pamediakopes.gr/>

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 +] <https://plus.google.com/u/0/+PanayotisTrapatsas>[image:
Stack Overflow] <http://stackoverflow.com/users/2618541/panayotis>

Reply via email to