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>
>
