You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@zeppelin.apache.org by Panayotis Trapatsas <p....@pamediakopes.gr> on 2016/07/22 16:58:49 UTC
Filter query results by current user
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.trapatsas@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>
Re: Filter query results by current user
Posted by moon soo Lee <mo...@apache.org>.
Per user interpreter is tracked by
https://issues.apache.org/jira/browse/ZEPPELIN-1210
Thanks,
moon
On Mon, Jul 25, 2016 at 8:52 PM Panayotis Trapatsas <
p.trapatsas@pamediakopes.gr> wrote:
> 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 <co...@gmail.com>
> 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.trapatsas@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 <mo...@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.trapatsas@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 <co...@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.trapatsas@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.trapatsas@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.trapatsas@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.trapatsas@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.trapatsas@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>
>
Re: Filter query results by current user
Posted by Panayotis Trapatsas <p....@pamediakopes.gr>.
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 <co...@gmail.com>
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.trapatsas@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 <mo...@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.trapatsas@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 <co...@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.trapatsas@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.trapatsas@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.trapatsas@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.trapatsas@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.trapatsas@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>
Re: Filter query results by current user
Posted by Corneau Damien <co...@gmail.com>.
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.trapatsas@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 <mo...@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.trapatsas@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 <co...@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.trapatsas@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.trapatsas@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.trapatsas@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.trapatsas@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>
>
Re: Filter query results by current user
Posted by Panayotis Trapatsas <p....@pamediakopes.gr>.
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 <mo...@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.trapatsas@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 <co...@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.trapatsas@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.trapatsas@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.trapatsas@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.trapatsas@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>
Re: Filter query results by current user
Posted by moon soo Lee <mo...@apache.org>.
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.trapatsas@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 <co...@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.trapatsas@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.trapatsas@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.trapatsas@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>
>
Re: Filter query results by current user
Posted by Panayotis Trapatsas <p....@pamediakopes.gr>.
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 <co...@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.trapatsas@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.trapatsas@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.trapatsas@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>
Re: Filter query results by current user
Posted by Corneau Damien <co...@gmail.com>.
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.trapatsas@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.trapatsas@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>
>