You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@zeppelin.apache.org by Paul Brenner <pb...@placeiq.com> on 2018/12/12 12:53:36 UTC
Re: Zeppelin and impersonation
We just did this on our install recently following the steps in the guide here:
https://zeppelin.apache.org/docs/0.8.0/usage/interpreter/user_impersonation.html
If that doesn’t work maybe you could call out where it fails?
PAUL BRENNER
Sr. Data Scientist
pbrenner@placeiq.com | (217) 390-3033 | www.placeiq.com
twitter @placeiq linkedin /placeiq
On Dec 12, 2018, 3:06 AM -0500, Neil Morris <Ne...@argos.co.uk>, wrote:
> Hi There,
>
> We run Cloudera 5.12, and have a Kerborised Hadoop Cluster. We have installed zeppelin under its own local user and control access to zeppelin via AD.
>
> As the standards on our estate dictate, whatever runs on the cluster must be auditable. We are therefore trying to configure zeppelin to impersonate the logged in user, but experiencing difficulties
> Can anyone supply a list of properties/variables that require configuring to achieve this.
>
> Regards
>
> Neil Morris
> Big Data Engineer
> Argos Ltd.
> 489-499 Avebury Boulevard, Milton Keynes MK9 2NW
>
> Mobile: 07964 784257
> LinkedIn
> This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. Unauthorised disclosure, copying or dissemination of the contents is strictly prohibited. The views expressed within this communication may not be official policy, but the personal views of the originator. If you are not the intended recipient or have received this message in error, please delete this e-mail and advise the sender. All messages sent and received by Argos Limited are monitored for viruses, high-risk file extensions, and inappropriate content. Sainsbury's Argos is a trading name of both: 1) Argos Limited, Registered office: 489-499 Avebury Boulevard, Milton Keynes, United Kingdom, MK9 2NW, registered number: 01081551 (England and Wales); and 2) Sainsbury's Supermarkets Ltd, Registered office: 33 Holborn, London, EC1N 2HT, registered number: 03261722 (England and Wales). Both companies are subsidiaries of J Sainsbury plc (185647).
Re: Zeppelin and impersonation
Posted by Abhi Basu <90...@gmail.com>.
No, I don't not kerberos yet.
On Wed, Dec 12, 2018 at 7:51 PM liuxun <hz...@corp.netease.com> wrote:
> hi, *Abhi Basu*
>
> *I used the following configuration to connect to the kerberos certified
> cluster, but it failed.*
> I followed the code and found that after the kerberos authentication was
> successful, the doAs operation failed to connect to impala.
>
> zeppelin/jdbc/src/main/java/org/apache/zeppelin/jdbc/JDBCInterpreter.java
>
> Do you use impala with kerberos certification?
>
>
> 在 2018年12月13日，上午2:17，Abhi Basu <90...@gmail.com> 写道：
>
> Are you pointing to one of the Impala daemon nodes?
>
> What do the logs say?
>
> On Wed, Dec 12, 2018 at 12:15 PM Fawze Abujaber <fa...@gmail.com> wrote:
>
>> I'm using impala JDBC and not ODBC and it's not working ....
>>
>> On Wed, Dec 12, 2018 at 8:13 PM Abhi Basu <90...@gmail.com> wrote:
>>
>>> Correct. Using JDBC to connect to Impala from Zeppelin.
>>>
>>> ODBC is mainly for Windows (I think), all our nodes run Centos7.
>>>
>>>
>>>
>>> On Wed, Dec 12, 2018 at 12:07 PM Fawze Abujaber <fa...@gmail.com>
>>> wrote:
>>>
>>>> So you are using hive JDBC and not impala JBC ....
>>>>
>>>>
>>>>
>>>> On Wed, Dec 12, 2018 at 7:47 PM Abhi Basu <90...@gmail.com> wrote:
>>>>
>>>>> This is our Zeppelin - JDBC config for Impala
>>>>> default.url --> jdbc:hive2://<IMPALA_DAEMON_IP>:21050/;auth=noSasl
>>>>> default.user --> impala
>>>>> default.driver org.apache.hive.jdbc.HiveDriver
>>>>> Dependencies
>>>>> artifactexclude
>>>>> org.apache.hadoop:hadoop-common:2.6.0
>>>>> org.apache.hive:hive-jdbc:0.14.0
>>>>>
>>>>>
>>>>> On Wed, Dec 12, 2018 at 11:18 AM Fawze Abujaber <fa...@gmail.com>
>>>>> wrote:
>>>>>
>>>>>> When you run the impala query, is it running with user? Do you see
>>>>>> the user in cloudera manager?
>>>>>>
>>>>>> Do you mind share your impala odbc string ?
>>>>>>
>>>>>> On Wed, 12 Dec 2018 at 19:06 Abhi Basu <90...@gmail.com> wrote:
>>>>>>
>>>>>>> Yes, we use Zeppelin and Impala. What is your question?
>>>>>>>
>>>>>>> On Wed, Dec 12, 2018 at 11:03 AM Fawze Abujaber <fa...@gmail.com>
>>>>>>> wrote:
>>>>>>>
>>>>>>>> Anyone who used Zeppelin to run queries through impala?
>>>>>>>>
>>>>>>>> On Wed, 12 Dec 2018 at 14:54 Paul Brenner <pb...@placeiq.com>
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>> We just did this on our install recently following the steps in
>>>>>>>>> the guide here:
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> https://zeppelin.apache.org/docs/0.8.0/usage/interpreter/user_impersonation.html
>>>>>>>>>
>>>>>>>>> If that doesn’t work maybe you could call out where it fails?
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> PAUL BRENNER
>>>>>>>>> Sr. Data Scientist
>>>>>>>>> pbrenner@placeiq.com | (217) 390-3033 | www.placeiq.com
>>>>>>>>> twitter @placeiq <https://twitter.com/PlaceIQ> linkedin /placeiq
>>>>>>>>> <https://www.linkedin.com/company/placeiq/>
>>>>>>>>>
>>>>>>>>> [image: PlaceIQ:CES 2018]
>>>>>>>>> <http://pages.placeiq.com/FY19Q1---CES-Meetings_LP---Meeting-Request.html>
>>>>>>>>> On Dec 12, 2018, 3:06 AM -0500, Neil Morris <
>>>>>>>>> Neil.Morris@argos.co.uk>, wrote:
>>>>>>>>>
>>>>>>>>> Hi There,
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> We run Cloudera 5.12, and have a Kerborised Hadoop Cluster. We
>>>>>>>>> have installed zeppelin under its own local user and control access to
>>>>>>>>> zeppelin via AD.
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> As the standards on our estate dictate, whatever runs on the
>>>>>>>>> cluster must be auditable. We are therefore trying to configure zeppelin to
>>>>>>>>> impersonate the logged in user, but experiencing difficulties
>>>>>>>>>
>>>>>>>>> Can anyone supply a list of properties/variables that require
>>>>>>>>> configuring to achieve this.
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> Regards
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> Neil Morris
>>>>>>>>>
>>>>>>>>> *Big Data Engineer*
>>>>>>>>>
>>>>>>>>> *Argos Ltd. *
>>>>>>>>>
>>>>>>>>> *489-499 Avebury Boulevard,
>>>>>>>>> <https://maps.google.com/?q=489-499+Avebury+Boulevard,+Milton+Keynes+MK9+2NW&entry=gmail&source=g>
>>>>>>>>> <https://maps.google.com/?q=489-499+Avebury+Boulevard,+%C2%A0+Milton+Keynes+MK9+2NW&entry=gmail&source=g>Milton
>>>>>>>>> Keynes MK9 2NW
>>>>>>>>> <https://maps.google.com/?q=489-499+Avebury+Boulevard,+Milton+Keynes+MK9+2NW&entry=gmail&source=g>*
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> Mobile: 07964 784257
>>>>>>>>>
>>>>>>>>> LinkedIn <https://www.linkedin.com/in/neil-morris-31746242>
>>>>>>>>> This email and any files transmitted with it are confidential and
>>>>>>>>> intended solely for the use of the individual or entity to whom they are
>>>>>>>>> addressed. Unauthorised disclosure, copying or dissemination of the
>>>>>>>>> contents is strictly prohibited. The views expressed within this
>>>>>>>>> communication may not be official policy, but the personal views of the
>>>>>>>>> originator. If you are not the intended recipient or have received this
>>>>>>>>> message in error, please delete this e-mail and advise the sender. All
>>>>>>>>> messages sent and received by Argos Limited are monitored for viruses,
>>>>>>>>> high-risk file extensions, and inappropriate content. Sainsbury's Argos is
>>>>>>>>> a trading name of both: 1) Argos Limited, Registered office: 489-499
>>>>>>>>> Avebury Boulevard, Milton Keynes, United Kingdom, MK9 2NW
>>>>>>>>> <https://maps.google.com/?q=499+Avebury+Boulevard,+Milton+Keynes,+United+Kingdom,+MK9+2NW&entry=gmail&source=g>,
>>>>>>>>> registered number: 01081551 (England and Wales); and 2) Sainsbury's
>>>>>>>>> Supermarkets Ltd, Registered office: 33 Holborn, London, EC1N 2HT
>>>>>>>>> <https://maps.google.com/?q=33+Holborn,+London,+EC1N+2HT&entry=gmail&source=g>,
>>>>>>>>> registered number: 03261722 (England and Wales). Both companies are
>>>>>>>>> subsidiaries of J Sainsbury plc (185647).
>>>>>>>>>
>>>>>>>>> --
>>>>>>>> Take Care
>>>>>>>> Fawze Abujaber
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> Abhi Basu
>>>>>>>
>>>>>> --
>>>>>> Take Care
>>>>>> Fawze Abujaber
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Abhi Basu
>>>>>
>>>>
>>>>
>>>> --
>>>> Take Care
>>>> Fawze Abujaber
>>>>
>>>
>>>
>>> --
>>> Abhi Basu
>>>
>>
>>
>> --
>> Take Care
>> Fawze Abujaber
>>
>
>
> --
> Abhi Basu
>
>
>
--
Abhi Basu
Re: Zeppelin and impersonation
Posted by Abhi Basu <90...@gmail.com>.
Are you pointing to one of the Impala daemon nodes?
What do the logs say?
On Wed, Dec 12, 2018 at 12:15 PM Fawze Abujaber <fa...@gmail.com> wrote:
> I'm using impala JDBC and not ODBC and it's not working ....
>
> On Wed, Dec 12, 2018 at 8:13 PM Abhi Basu <90...@gmail.com> wrote:
>
>> Correct. Using JDBC to connect to Impala from Zeppelin.
>>
>> ODBC is mainly for Windows (I think), all our nodes run Centos7.
>>
>>
>>
>> On Wed, Dec 12, 2018 at 12:07 PM Fawze Abujaber <fa...@gmail.com>
>> wrote:
>>
>>> So you are using hive JDBC and not impala JBC ....
>>>
>>>
>>>
>>> On Wed, Dec 12, 2018 at 7:47 PM Abhi Basu <90...@gmail.com> wrote:
>>>
>>>> This is our Zeppelin - JDBC config for Impala
>>>> default.url --> jdbc:hive2://<IMPALA_DAEMON_IP>:21050/;auth=noSasl
>>>> default.user --> impala
>>>> default.driver org.apache.hive.jdbc.HiveDriver
>>>> Dependencies
>>>> artifactexclude
>>>> org.apache.hadoop:hadoop-common:2.6.0
>>>> org.apache.hive:hive-jdbc:0.14.0
>>>>
>>>>
>>>> On Wed, Dec 12, 2018 at 11:18 AM Fawze Abujaber <fa...@gmail.com>
>>>> wrote:
>>>>
>>>>> When you run the impala query, is it running with user? Do you see the
>>>>> user in cloudera manager?
>>>>>
>>>>> Do you mind share your impala odbc string ?
>>>>>
>>>>> On Wed, 12 Dec 2018 at 19:06 Abhi Basu <90...@gmail.com> wrote:
>>>>>
>>>>>> Yes, we use Zeppelin and Impala. What is your question?
>>>>>>
>>>>>> On Wed, Dec 12, 2018 at 11:03 AM Fawze Abujaber <fa...@gmail.com>
>>>>>> wrote:
>>>>>>
>>>>>>> Anyone who used Zeppelin to run queries through impala?
>>>>>>>
>>>>>>> On Wed, 12 Dec 2018 at 14:54 Paul Brenner <pb...@placeiq.com>
>>>>>>> wrote:
>>>>>>>
>>>>>>>> We just did this on our install recently following the steps in the
>>>>>>>> guide here:
>>>>>>>>
>>>>>>>>
>>>>>>>> https://zeppelin.apache.org/docs/0.8.0/usage/interpreter/user_impersonation.html
>>>>>>>>
>>>>>>>> If that doesn’t work maybe you could call out where it fails?
>>>>>>>>
>>>>>>>>
>>>>>>>> PAUL BRENNER
>>>>>>>>
>>>>>>>> Sr. Data Scientist
>>>>>>>> pbrenner@placeiq.com | (217) 390-3033 | www.placeiq.com
>>>>>>>> twitter @placeiq <https://twitter.com/PlaceIQ> linkedin /placeiq
>>>>>>>> <https://www.linkedin.com/company/placeiq/>
>>>>>>>>
>>>>>>>> [image: PlaceIQ:CES 2018]
>>>>>>>> <http://pages.placeiq.com/FY19Q1---CES-Meetings_LP---Meeting-Request.html>
>>>>>>>> On Dec 12, 2018, 3:06 AM -0500, Neil Morris <
>>>>>>>> Neil.Morris@argos.co.uk>, wrote:
>>>>>>>>
>>>>>>>> Hi There,
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> We run Cloudera 5.12, and have a Kerborised Hadoop Cluster. We have
>>>>>>>> installed zeppelin under its own local user and control access to zeppelin
>>>>>>>> via AD.
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> As the standards on our estate dictate, whatever runs on the
>>>>>>>> cluster must be auditable. We are therefore trying to configure zeppelin to
>>>>>>>> impersonate the logged in user, but experiencing difficulties
>>>>>>>>
>>>>>>>> Can anyone supply a list of properties/variables that require
>>>>>>>> configuring to achieve this.
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> Regards
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> Neil Morris
>>>>>>>>
>>>>>>>> *Big Data Engineer*
>>>>>>>>
>>>>>>>> *Argos Ltd. *
>>>>>>>>
>>>>>>>> *489-499 Avebury Boulevard,
>>>>>>>> <https://maps.google.com/?q=489-499+Avebury+Boulevard,+Milton+Keynes+MK9+2NW&entry=gmail&source=g>
>>>>>>>> <https://maps.google.com/?q=489-499+Avebury+Boulevard,+%C2%A0+Milton+Keynes+MK9+2NW&entry=gmail&source=g>Milton
>>>>>>>> Keynes MK9 2NW
>>>>>>>> <https://maps.google.com/?q=489-499+Avebury+Boulevard,+Milton+Keynes+MK9+2NW&entry=gmail&source=g>*
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> Mobile: 07964 784257
>>>>>>>>
>>>>>>>> LinkedIn <https://www.linkedin.com/in/neil-morris-31746242>
>>>>>>>> This email and any files transmitted with it are confidential and
>>>>>>>> intended solely for the use of the individual or entity to whom they are
>>>>>>>> addressed. Unauthorised disclosure, copying or dissemination of the
>>>>>>>> contents is strictly prohibited. The views expressed within this
>>>>>>>> communication may not be official policy, but the personal views of the
>>>>>>>> originator. If you are not the intended recipient or have received this
>>>>>>>> message in error, please delete this e-mail and advise the sender. All
>>>>>>>> messages sent and received by Argos Limited are monitored for viruses,
>>>>>>>> high-risk file extensions, and inappropriate content. Sainsbury's Argos is
>>>>>>>> a trading name of both: 1) Argos Limited, Registered office: 489-499
>>>>>>>> Avebury Boulevard, Milton Keynes, United Kingdom, MK9 2NW
>>>>>>>> <https://maps.google.com/?q=499+Avebury+Boulevard,+Milton+Keynes,+United+Kingdom,+MK9+2NW&entry=gmail&source=g>,
>>>>>>>> registered number: 01081551 (England and Wales); and 2) Sainsbury's
>>>>>>>> Supermarkets Ltd, Registered office: 33 Holborn, London, EC1N 2HT
>>>>>>>> <https://maps.google.com/?q=33+Holborn,+London,+EC1N+2HT&entry=gmail&source=g>,
>>>>>>>> registered number: 03261722 (England and Wales). Both companies are
>>>>>>>> subsidiaries of J Sainsbury plc (185647).
>>>>>>>>
>>>>>>>> --
>>>>>>> Take Care
>>>>>>> Fawze Abujaber
>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Abhi Basu
>>>>>>
>>>>> --
>>>>> Take Care
>>>>> Fawze Abujaber
>>>>>
>>>>
>>>>
>>>> --
>>>> Abhi Basu
>>>>
>>>
>>>
>>> --
>>> Take Care
>>> Fawze Abujaber
>>>
>>
>>
>> --
>> Abhi Basu
>>
>
>
> --
> Take Care
> Fawze Abujaber
>
--
Abhi Basu
Re: Zeppelin and impersonation
Posted by Fawze Abujaber <fa...@gmail.com>.
I'm using impala JDBC and not ODBC and it's not working ....
On Wed, Dec 12, 2018 at 8:13 PM Abhi Basu <90...@gmail.com> wrote:
> Correct. Using JDBC to connect to Impala from Zeppelin.
>
> ODBC is mainly for Windows (I think), all our nodes run Centos7.
>
>
>
> On Wed, Dec 12, 2018 at 12:07 PM Fawze Abujaber <fa...@gmail.com> wrote:
>
>> So you are using hive JDBC and not impala JBC ....
>>
>>
>>
>> On Wed, Dec 12, 2018 at 7:47 PM Abhi Basu <90...@gmail.com> wrote:
>>
>>> This is our Zeppelin - JDBC config for Impala
>>> default.url --> jdbc:hive2://<IMPALA_DAEMON_IP>:21050/;auth=noSasl
>>> default.user --> impala
>>> default.driver org.apache.hive.jdbc.HiveDriver
>>> Dependencies
>>> artifactexclude
>>> org.apache.hadoop:hadoop-common:2.6.0
>>> org.apache.hive:hive-jdbc:0.14.0
>>>
>>>
>>> On Wed, Dec 12, 2018 at 11:18 AM Fawze Abujaber <fa...@gmail.com>
>>> wrote:
>>>
>>>> When you run the impala query, is it running with user? Do you see the
>>>> user in cloudera manager?
>>>>
>>>> Do you mind share your impala odbc string ?
>>>>
>>>> On Wed, 12 Dec 2018 at 19:06 Abhi Basu <90...@gmail.com> wrote:
>>>>
>>>>> Yes, we use Zeppelin and Impala. What is your question?
>>>>>
>>>>> On Wed, Dec 12, 2018 at 11:03 AM Fawze Abujaber <fa...@gmail.com>
>>>>> wrote:
>>>>>
>>>>>> Anyone who used Zeppelin to run queries through impala?
>>>>>>
>>>>>> On Wed, 12 Dec 2018 at 14:54 Paul Brenner <pb...@placeiq.com>
>>>>>> wrote:
>>>>>>
>>>>>>> We just did this on our install recently following the steps in the
>>>>>>> guide here:
>>>>>>>
>>>>>>>
>>>>>>> https://zeppelin.apache.org/docs/0.8.0/usage/interpreter/user_impersonation.html
>>>>>>>
>>>>>>> If that doesn’t work maybe you could call out where it fails?
>>>>>>>
>>>>>>>
>>>>>>> PAUL BRENNER
>>>>>>>
>>>>>>> Sr. Data Scientist
>>>>>>> pbrenner@placeiq.com | (217) 390-3033 | www.placeiq.com
>>>>>>> twitter @placeiq <https://twitter.com/PlaceIQ> linkedin /placeiq
>>>>>>> <https://www.linkedin.com/company/placeiq/>
>>>>>>>
>>>>>>> [image: PlaceIQ:CES 2018]
>>>>>>> <http://pages.placeiq.com/FY19Q1---CES-Meetings_LP---Meeting-Request.html>
>>>>>>> On Dec 12, 2018, 3:06 AM -0500, Neil Morris <Ne...@argos.co.uk>,
>>>>>>> wrote:
>>>>>>>
>>>>>>> Hi There,
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> We run Cloudera 5.12, and have a Kerborised Hadoop Cluster. We have
>>>>>>> installed zeppelin under its own local user and control access to zeppelin
>>>>>>> via AD.
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> As the standards on our estate dictate, whatever runs on the
>>>>>>> cluster must be auditable. We are therefore trying to configure zeppelin to
>>>>>>> impersonate the logged in user, but experiencing difficulties
>>>>>>>
>>>>>>> Can anyone supply a list of properties/variables that require
>>>>>>> configuring to achieve this.
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> Regards
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> Neil Morris
>>>>>>>
>>>>>>> *Big Data Engineer*
>>>>>>>
>>>>>>> *Argos Ltd. *
>>>>>>>
>>>>>>> *489-499 Avebury Boulevard,
>>>>>>> <https://maps.google.com/?q=489-499+Avebury+Boulevard,+Milton+Keynes+MK9+2NW&entry=gmail&source=g>
>>>>>>> <https://maps.google.com/?q=489-499+Avebury+Boulevard,+%C2%A0+Milton+Keynes+MK9+2NW&entry=gmail&source=g>Milton
>>>>>>> Keynes MK9 2NW
>>>>>>> <https://maps.google.com/?q=489-499+Avebury+Boulevard,+Milton+Keynes+MK9+2NW&entry=gmail&source=g>*
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> Mobile: 07964 784257
>>>>>>>
>>>>>>> LinkedIn <https://www.linkedin.com/in/neil-morris-31746242>
>>>>>>> This email and any files transmitted with it are confidential and
>>>>>>> intended solely for the use of the individual or entity to whom they are
>>>>>>> addressed. Unauthorised disclosure, copying or dissemination of the
>>>>>>> contents is strictly prohibited. The views expressed within this
>>>>>>> communication may not be official policy, but the personal views of the
>>>>>>> originator. If you are not the intended recipient or have received this
>>>>>>> message in error, please delete this e-mail and advise the sender. All
>>>>>>> messages sent and received by Argos Limited are monitored for viruses,
>>>>>>> high-risk file extensions, and inappropriate content. Sainsbury's Argos is
>>>>>>> a trading name of both: 1) Argos Limited, Registered office: 489-499
>>>>>>> Avebury Boulevard, Milton Keynes, United Kingdom, MK9 2NW
>>>>>>> <https://maps.google.com/?q=499+Avebury+Boulevard,+Milton+Keynes,+United+Kingdom,+MK9+2NW&entry=gmail&source=g>,
>>>>>>> registered number: 01081551 (England and Wales); and 2) Sainsbury's
>>>>>>> Supermarkets Ltd, Registered office: 33 Holborn, London, EC1N 2HT
>>>>>>> <https://maps.google.com/?q=33+Holborn,+London,+EC1N+2HT&entry=gmail&source=g>,
>>>>>>> registered number: 03261722 (England and Wales). Both companies are
>>>>>>> subsidiaries of J Sainsbury plc (185647).
>>>>>>>
>>>>>>> --
>>>>>> Take Care
>>>>>> Fawze Abujaber
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Abhi Basu
>>>>>
>>>> --
>>>> Take Care
>>>> Fawze Abujaber
>>>>
>>>
>>>
>>> --
>>> Abhi Basu
>>>
>>
>>
>> --
>> Take Care
>> Fawze Abujaber
>>
>
>
> --
> Abhi Basu
>
--
Take Care
Fawze Abujaber
Re: Zeppelin and impersonation
Posted by Abhi Basu <90...@gmail.com>.
Correct. Using JDBC to connect to Impala from Zeppelin.
ODBC is mainly for Windows (I think), all our nodes run Centos7.
On Wed, Dec 12, 2018 at 12:07 PM Fawze Abujaber <fa...@gmail.com> wrote:
> So you are using hive JDBC and not impala JBC ....
>
>
>
> On Wed, Dec 12, 2018 at 7:47 PM Abhi Basu <90...@gmail.com> wrote:
>
>> This is our Zeppelin - JDBC config for Impala
>> default.url --> jdbc:hive2://<IMPALA_DAEMON_IP>:21050/;auth=noSasl
>> default.user --> impala
>> default.driver org.apache.hive.jdbc.HiveDriver
>> Dependencies
>> artifactexclude
>> org.apache.hadoop:hadoop-common:2.6.0
>> org.apache.hive:hive-jdbc:0.14.0
>>
>>
>> On Wed, Dec 12, 2018 at 11:18 AM Fawze Abujaber <fa...@gmail.com>
>> wrote:
>>
>>> When you run the impala query, is it running with user? Do you see the
>>> user in cloudera manager?
>>>
>>> Do you mind share your impala odbc string ?
>>>
>>> On Wed, 12 Dec 2018 at 19:06 Abhi Basu <90...@gmail.com> wrote:
>>>
>>>> Yes, we use Zeppelin and Impala. What is your question?
>>>>
>>>> On Wed, Dec 12, 2018 at 11:03 AM Fawze Abujaber <fa...@gmail.com>
>>>> wrote:
>>>>
>>>>> Anyone who used Zeppelin to run queries through impala?
>>>>>
>>>>> On Wed, 12 Dec 2018 at 14:54 Paul Brenner <pb...@placeiq.com>
>>>>> wrote:
>>>>>
>>>>>> We just did this on our install recently following the steps in the
>>>>>> guide here:
>>>>>>
>>>>>>
>>>>>> https://zeppelin.apache.org/docs/0.8.0/usage/interpreter/user_impersonation.html
>>>>>>
>>>>>> If that doesn’t work maybe you could call out where it fails?
>>>>>>
>>>>>>
>>>>>> PAUL BRENNER
>>>>>>
>>>>>> Sr. Data Scientist
>>>>>> pbrenner@placeiq.com | (217) 390-3033 | www.placeiq.com
>>>>>> twitter @placeiq <https://twitter.com/PlaceIQ> linkedin /placeiq
>>>>>> <https://www.linkedin.com/company/placeiq/>
>>>>>>
>>>>>> [image: PlaceIQ:CES 2018]
>>>>>> <http://pages.placeiq.com/FY19Q1---CES-Meetings_LP---Meeting-Request.html>
>>>>>> On Dec 12, 2018, 3:06 AM -0500, Neil Morris <Ne...@argos.co.uk>,
>>>>>> wrote:
>>>>>>
>>>>>> Hi There,
>>>>>>
>>>>>>
>>>>>>
>>>>>> We run Cloudera 5.12, and have a Kerborised Hadoop Cluster. We have
>>>>>> installed zeppelin under its own local user and control access to zeppelin
>>>>>> via AD.
>>>>>>
>>>>>>
>>>>>>
>>>>>> As the standards on our estate dictate, whatever runs on the cluster
>>>>>> must be auditable. We are therefore trying to configure zeppelin to
>>>>>> impersonate the logged in user, but experiencing difficulties
>>>>>>
>>>>>> Can anyone supply a list of properties/variables that require
>>>>>> configuring to achieve this.
>>>>>>
>>>>>>
>>>>>>
>>>>>> Regards
>>>>>>
>>>>>>
>>>>>>
>>>>>> Neil Morris
>>>>>>
>>>>>> *Big Data Engineer*
>>>>>>
>>>>>> *Argos Ltd. *
>>>>>>
>>>>>> *489-499 Avebury Boulevard,
>>>>>> <https://maps.google.com/?q=489-499+Avebury+Boulevard,+Milton+Keynes+MK9+2NW&entry=gmail&source=g>
>>>>>> <https://maps.google.com/?q=489-499+Avebury+Boulevard,+%C2%A0+Milton+Keynes+MK9+2NW&entry=gmail&source=g>Milton
>>>>>> Keynes MK9 2NW
>>>>>> <https://maps.google.com/?q=489-499+Avebury+Boulevard,+Milton+Keynes+MK9+2NW&entry=gmail&source=g>*
>>>>>>
>>>>>>
>>>>>>
>>>>>> Mobile: 07964 784257
>>>>>>
>>>>>> LinkedIn <https://www.linkedin.com/in/neil-morris-31746242>
>>>>>> This email and any files transmitted with it are confidential and
>>>>>> intended solely for the use of the individual or entity to whom they are
>>>>>> addressed. Unauthorised disclosure, copying or dissemination of the
>>>>>> contents is strictly prohibited. The views expressed within this
>>>>>> communication may not be official policy, but the personal views of the
>>>>>> originator. If you are not the intended recipient or have received this
>>>>>> message in error, please delete this e-mail and advise the sender. All
>>>>>> messages sent and received by Argos Limited are monitored for viruses,
>>>>>> high-risk file extensions, and inappropriate content. Sainsbury's Argos is
>>>>>> a trading name of both: 1) Argos Limited, Registered office: 489-499
>>>>>> Avebury Boulevard, Milton Keynes, United Kingdom, MK9 2NW
>>>>>> <https://maps.google.com/?q=499+Avebury+Boulevard,+Milton+Keynes,+United+Kingdom,+MK9+2NW&entry=gmail&source=g>,
>>>>>> registered number: 01081551 (England and Wales); and 2) Sainsbury's
>>>>>> Supermarkets Ltd, Registered office: 33 Holborn, London, EC1N 2HT
>>>>>> <https://maps.google.com/?q=33+Holborn,+London,+EC1N+2HT&entry=gmail&source=g>,
>>>>>> registered number: 03261722 (England and Wales). Both companies are
>>>>>> subsidiaries of J Sainsbury plc (185647).
>>>>>>
>>>>>> --
>>>>> Take Care
>>>>> Fawze Abujaber
>>>>>
>>>>
>>>>
>>>> --
>>>> Abhi Basu
>>>>
>>> --
>>> Take Care
>>> Fawze Abujaber
>>>
>>
>>
>> --
>> Abhi Basu
>>
>
>
> --
> Take Care
> Fawze Abujaber
>
--
Abhi Basu
Re: Zeppelin and impersonation
Posted by Fawze Abujaber <fa...@gmail.com>.
So you are using hive JDBC and not impala JBC ....
On Wed, Dec 12, 2018 at 7:47 PM Abhi Basu <90...@gmail.com> wrote:
> This is our Zeppelin - JDBC config for Impala
> default.url --> jdbc:hive2://<IMPALA_DAEMON_IP>:21050/;auth=noSasl
> default.user --> impala
> default.driver org.apache.hive.jdbc.HiveDriver
> Dependencies
> artifactexclude
> org.apache.hadoop:hadoop-common:2.6.0
> org.apache.hive:hive-jdbc:0.14.0
>
>
> On Wed, Dec 12, 2018 at 11:18 AM Fawze Abujaber <fa...@gmail.com> wrote:
>
>> When you run the impala query, is it running with user? Do you see the
>> user in cloudera manager?
>>
>> Do you mind share your impala odbc string ?
>>
>> On Wed, 12 Dec 2018 at 19:06 Abhi Basu <90...@gmail.com> wrote:
>>
>>> Yes, we use Zeppelin and Impala. What is your question?
>>>
>>> On Wed, Dec 12, 2018 at 11:03 AM Fawze Abujaber <fa...@gmail.com>
>>> wrote:
>>>
>>>> Anyone who used Zeppelin to run queries through impala?
>>>>
>>>> On Wed, 12 Dec 2018 at 14:54 Paul Brenner <pb...@placeiq.com> wrote:
>>>>
>>>>> We just did this on our install recently following the steps in the
>>>>> guide here:
>>>>>
>>>>>
>>>>> https://zeppelin.apache.org/docs/0.8.0/usage/interpreter/user_impersonation.html
>>>>>
>>>>> If that doesn’t work maybe you could call out where it fails?
>>>>>
>>>>>
>>>>> PAUL BRENNER
>>>>>
>>>>> Sr. Data Scientist
>>>>> pbrenner@placeiq.com | (217) 390-3033 | www.placeiq.com
>>>>> twitter @placeiq <https://twitter.com/PlaceIQ> linkedin /placeiq
>>>>> <https://www.linkedin.com/company/placeiq/>
>>>>>
>>>>> [image: PlaceIQ:CES 2018]
>>>>> <http://pages.placeiq.com/FY19Q1---CES-Meetings_LP---Meeting-Request.html>
>>>>> On Dec 12, 2018, 3:06 AM -0500, Neil Morris <Ne...@argos.co.uk>,
>>>>> wrote:
>>>>>
>>>>> Hi There,
>>>>>
>>>>>
>>>>>
>>>>> We run Cloudera 5.12, and have a Kerborised Hadoop Cluster. We have
>>>>> installed zeppelin under its own local user and control access to zeppelin
>>>>> via AD.
>>>>>
>>>>>
>>>>>
>>>>> As the standards on our estate dictate, whatever runs on the cluster
>>>>> must be auditable. We are therefore trying to configure zeppelin to
>>>>> impersonate the logged in user, but experiencing difficulties
>>>>>
>>>>> Can anyone supply a list of properties/variables that require
>>>>> configuring to achieve this.
>>>>>
>>>>>
>>>>>
>>>>> Regards
>>>>>
>>>>>
>>>>>
>>>>> Neil Morris
>>>>>
>>>>> *Big Data Engineer*
>>>>>
>>>>> *Argos Ltd. *
>>>>>
>>>>> *489-499 Avebury Boulevard,
>>>>> <https://maps.google.com/?q=489-499+Avebury+Boulevard,+Milton+Keynes+MK9+2NW&entry=gmail&source=g>
>>>>> <https://maps.google.com/?q=489-499+Avebury+Boulevard,+%C2%A0+Milton+Keynes+MK9+2NW&entry=gmail&source=g>Milton
>>>>> Keynes MK9 2NW
>>>>> <https://maps.google.com/?q=489-499+Avebury+Boulevard,+Milton+Keynes+MK9+2NW&entry=gmail&source=g>*
>>>>>
>>>>>
>>>>>
>>>>> Mobile: 07964 784257
>>>>>
>>>>> LinkedIn <https://www.linkedin.com/in/neil-morris-31746242>
>>>>> This email and any files transmitted with it are confidential and
>>>>> intended solely for the use of the individual or entity to whom they are
>>>>> addressed. Unauthorised disclosure, copying or dissemination of the
>>>>> contents is strictly prohibited. The views expressed within this
>>>>> communication may not be official policy, but the personal views of the
>>>>> originator. If you are not the intended recipient or have received this
>>>>> message in error, please delete this e-mail and advise the sender. All
>>>>> messages sent and received by Argos Limited are monitored for viruses,
>>>>> high-risk file extensions, and inappropriate content. Sainsbury's Argos is
>>>>> a trading name of both: 1) Argos Limited, Registered office: 489-499
>>>>> Avebury Boulevard, Milton Keynes, United Kingdom, MK9 2NW
>>>>> <https://maps.google.com/?q=499+Avebury+Boulevard,+Milton+Keynes,+United+Kingdom,+MK9+2NW&entry=gmail&source=g>,
>>>>> registered number: 01081551 (England and Wales); and 2) Sainsbury's
>>>>> Supermarkets Ltd, Registered office: 33 Holborn, London, EC1N 2HT
>>>>> <https://maps.google.com/?q=33+Holborn,+London,+EC1N+2HT&entry=gmail&source=g>,
>>>>> registered number: 03261722 (England and Wales). Both companies are
>>>>> subsidiaries of J Sainsbury plc (185647).
>>>>>
>>>>> --
>>>> Take Care
>>>> Fawze Abujaber
>>>>
>>>
>>>
>>> --
>>> Abhi Basu
>>>
>> --
>> Take Care
>> Fawze Abujaber
>>
>
>
> --
> Abhi Basu
>
--
Take Care
Fawze Abujaber
Re: Zeppelin and impersonation
Posted by Abhi Basu <90...@gmail.com>.
This is our Zeppelin - JDBC config for Impala
default.url --> jdbc:hive2://<IMPALA_DAEMON_IP>:21050/;auth=noSasl
default.user --> impala
default.driver org.apache.hive.jdbc.HiveDriver
Dependencies
artifactexclude
org.apache.hadoop:hadoop-common:2.6.0
org.apache.hive:hive-jdbc:0.14.0
On Wed, Dec 12, 2018 at 11:18 AM Fawze Abujaber <fa...@gmail.com> wrote:
> When you run the impala query, is it running with user? Do you see the
> user in cloudera manager?
>
> Do you mind share your impala odbc string ?
>
> On Wed, 12 Dec 2018 at 19:06 Abhi Basu <90...@gmail.com> wrote:
>
>> Yes, we use Zeppelin and Impala. What is your question?
>>
>> On Wed, Dec 12, 2018 at 11:03 AM Fawze Abujaber <fa...@gmail.com>
>> wrote:
>>
>>> Anyone who used Zeppelin to run queries through impala?
>>>
>>> On Wed, 12 Dec 2018 at 14:54 Paul Brenner <pb...@placeiq.com> wrote:
>>>
>>>> We just did this on our install recently following the steps in the
>>>> guide here:
>>>>
>>>>
>>>> https://zeppelin.apache.org/docs/0.8.0/usage/interpreter/user_impersonation.html
>>>>
>>>> If that doesn’t work maybe you could call out where it fails?
>>>>
>>>>
>>>> PAUL BRENNER
>>>>
>>>> Sr. Data Scientist
>>>> pbrenner@placeiq.com | (217) 390-3033 | www.placeiq.com
>>>> twitter @placeiq <https://twitter.com/PlaceIQ> linkedin /placeiq
>>>> <https://www.linkedin.com/company/placeiq/>
>>>>
>>>> [image: PlaceIQ:CES 2018]
>>>> <http://pages.placeiq.com/FY19Q1---CES-Meetings_LP---Meeting-Request.html>
>>>> On Dec 12, 2018, 3:06 AM -0500, Neil Morris <Ne...@argos.co.uk>,
>>>> wrote:
>>>>
>>>> Hi There,
>>>>
>>>>
>>>>
>>>> We run Cloudera 5.12, and have a Kerborised Hadoop Cluster. We have
>>>> installed zeppelin under its own local user and control access to zeppelin
>>>> via AD.
>>>>
>>>>
>>>>
>>>> As the standards on our estate dictate, whatever runs on the cluster
>>>> must be auditable. We are therefore trying to configure zeppelin to
>>>> impersonate the logged in user, but experiencing difficulties
>>>>
>>>> Can anyone supply a list of properties/variables that require
>>>> configuring to achieve this.
>>>>
>>>>
>>>>
>>>> Regards
>>>>
>>>>
>>>>
>>>> Neil Morris
>>>>
>>>> *Big Data Engineer*
>>>>
>>>> *Argos Ltd. *
>>>>
>>>> *489-499 Avebury Boulevard,
>>>> <https://maps.google.com/?q=489-499+Avebury+Boulevard,+Milton+Keynes+MK9+2NW&entry=gmail&source=g>
>>>> <https://maps.google.com/?q=489-499+Avebury+Boulevard,+%C2%A0+Milton+Keynes+MK9+2NW&entry=gmail&source=g>Milton
>>>> Keynes MK9 2NW
>>>> <https://maps.google.com/?q=489-499+Avebury+Boulevard,+Milton+Keynes+MK9+2NW&entry=gmail&source=g>*
>>>>
>>>>
>>>>
>>>> Mobile: 07964 784257
>>>>
>>>> LinkedIn <https://www.linkedin.com/in/neil-morris-31746242>
>>>> This email and any files transmitted with it are confidential and
>>>> intended solely for the use of the individual or entity to whom they are
>>>> addressed. Unauthorised disclosure, copying or dissemination of the
>>>> contents is strictly prohibited. The views expressed within this
>>>> communication may not be official policy, but the personal views of the
>>>> originator. If you are not the intended recipient or have received this
>>>> message in error, please delete this e-mail and advise the sender. All
>>>> messages sent and received by Argos Limited are monitored for viruses,
>>>> high-risk file extensions, and inappropriate content. Sainsbury's Argos is
>>>> a trading name of both: 1) Argos Limited, Registered office: 489-499
>>>> Avebury Boulevard, Milton Keynes, United Kingdom, MK9 2NW
>>>> <https://maps.google.com/?q=499+Avebury+Boulevard,+Milton+Keynes,+United+Kingdom,+MK9+2NW&entry=gmail&source=g>,
>>>> registered number: 01081551 (England and Wales); and 2) Sainsbury's
>>>> Supermarkets Ltd, Registered office: 33 Holborn, London, EC1N 2HT
>>>> <https://maps.google.com/?q=33+Holborn,+London,+EC1N+2HT&entry=gmail&source=g>,
>>>> registered number: 03261722 (England and Wales). Both companies are
>>>> subsidiaries of J Sainsbury plc (185647).
>>>>
>>>> --
>>> Take Care
>>> Fawze Abujaber
>>>
>>
>>
>> --
>> Abhi Basu
>>
> --
> Take Care
> Fawze Abujaber
>
--
Abhi Basu
Re: Zeppelin and impersonation
Posted by Fawze Abujaber <fa...@gmail.com>.
When you run the impala query, is it running with user? Do you see the user
in cloudera manager?
Do you mind share your impala odbc string ?
On Wed, 12 Dec 2018 at 19:06 Abhi Basu <90...@gmail.com> wrote:
> Yes, we use Zeppelin and Impala. What is your question?
>
> On Wed, Dec 12, 2018 at 11:03 AM Fawze Abujaber <fa...@gmail.com> wrote:
>
>> Anyone who used Zeppelin to run queries through impala?
>>
>> On Wed, 12 Dec 2018 at 14:54 Paul Brenner <pb...@placeiq.com> wrote:
>>
>>> We just did this on our install recently following the steps in the
>>> guide here:
>>>
>>>
>>> https://zeppelin.apache.org/docs/0.8.0/usage/interpreter/user_impersonation.html
>>>
>>> If that doesn’t work maybe you could call out where it fails?
>>>
>>>
>>> PAUL BRENNER
>>>
>>> Sr. Data Scientist
>>> pbrenner@placeiq.com | (217) 390-3033 | www.placeiq.com
>>> twitter @placeiq <https://twitter.com/PlaceIQ> linkedin /placeiq
>>> <https://www.linkedin.com/company/placeiq/>
>>>
>>> [image: PlaceIQ:CES 2018]
>>> <http://pages.placeiq.com/FY19Q1---CES-Meetings_LP---Meeting-Request.html>
>>> On Dec 12, 2018, 3:06 AM -0500, Neil Morris <Ne...@argos.co.uk>,
>>> wrote:
>>>
>>> Hi There,
>>>
>>>
>>>
>>> We run Cloudera 5.12, and have a Kerborised Hadoop Cluster. We have
>>> installed zeppelin under its own local user and control access to zeppelin
>>> via AD.
>>>
>>>
>>>
>>> As the standards on our estate dictate, whatever runs on the cluster
>>> must be auditable. We are therefore trying to configure zeppelin to
>>> impersonate the logged in user, but experiencing difficulties
>>>
>>> Can anyone supply a list of properties/variables that require
>>> configuring to achieve this.
>>>
>>>
>>>
>>> Regards
>>>
>>>
>>>
>>> Neil Morris
>>>
>>> *Big Data Engineer*
>>>
>>> *Argos Ltd. *
>>>
>>> *489-499 Avebury Boulevard,
>>> <https://maps.google.com/?q=489-499+Avebury+Boulevard,+Milton+Keynes+MK9+2NW&entry=gmail&source=g>
>>> <https://maps.google.com/?q=489-499+Avebury+Boulevard,+%C2%A0+Milton+Keynes+MK9+2NW&entry=gmail&source=g>Milton
>>> Keynes MK9 2NW
>>> <https://maps.google.com/?q=489-499+Avebury+Boulevard,+Milton+Keynes+MK9+2NW&entry=gmail&source=g>*
>>>
>>>
>>>
>>> Mobile: 07964 784257
>>>
>>> LinkedIn <https://www.linkedin.com/in/neil-morris-31746242>
>>> This email and any files transmitted with it are confidential and
>>> intended solely for the use of the individual or entity to whom they are
>>> addressed. Unauthorised disclosure, copying or dissemination of the
>>> contents is strictly prohibited. The views expressed within this
>>> communication may not be official policy, but the personal views of the
>>> originator. If you are not the intended recipient or have received this
>>> message in error, please delete this e-mail and advise the sender. All
>>> messages sent and received by Argos Limited are monitored for viruses,
>>> high-risk file extensions, and inappropriate content. Sainsbury's Argos is
>>> a trading name of both: 1) Argos Limited, Registered office: 489-499
>>> Avebury Boulevard, Milton Keynes, United Kingdom, MK9 2NW
>>> <https://maps.google.com/?q=499+Avebury+Boulevard,+Milton+Keynes,+United+Kingdom,+MK9+2NW&entry=gmail&source=g>,
>>> registered number: 01081551 (England and Wales); and 2) Sainsbury's
>>> Supermarkets Ltd, Registered office: 33 Holborn, London, EC1N 2HT
>>> <https://maps.google.com/?q=33+Holborn,+London,+EC1N+2HT&entry=gmail&source=g>,
>>> registered number: 03261722 (England and Wales). Both companies are
>>> subsidiaries of J Sainsbury plc (185647).
>>>
>>> --
>> Take Care
>> Fawze Abujaber
>>
>
>
> --
> Abhi Basu
>
--
Take Care
Fawze Abujaber
Re: Zeppelin and impersonation
Posted by Abhi Basu <90...@gmail.com>.
Yes, we use Zeppelin and Impala. What is your question?
On Wed, Dec 12, 2018 at 11:03 AM Fawze Abujaber <fa...@gmail.com> wrote:
> Anyone who used Zeppelin to run queries through impala?
>
> On Wed, 12 Dec 2018 at 14:54 Paul Brenner <pb...@placeiq.com> wrote:
>
>> We just did this on our install recently following the steps in the guide
>> here:
>>
>>
>> https://zeppelin.apache.org/docs/0.8.0/usage/interpreter/user_impersonation.html
>>
>> If that doesn’t work maybe you could call out where it fails?
>>
>>
>> PAUL BRENNER
>>
>> Sr. Data Scientist
>> pbrenner@placeiq.com | (217) 390-3033 | www.placeiq.com
>> twitter @placeiq <https://twitter.com/PlaceIQ> linkedin /placeiq
>> <https://www.linkedin.com/company/placeiq/>
>>
>> [image: PlaceIQ:CES 2018]
>> <http://pages.placeiq.com/FY19Q1---CES-Meetings_LP---Meeting-Request.html>
>> On Dec 12, 2018, 3:06 AM -0500, Neil Morris <Ne...@argos.co.uk>,
>> wrote:
>>
>> Hi There,
>>
>>
>>
>> We run Cloudera 5.12, and have a Kerborised Hadoop Cluster. We have
>> installed zeppelin under its own local user and control access to zeppelin
>> via AD.
>>
>>
>>
>> As the standards on our estate dictate, whatever runs on the cluster
>> must be auditable. We are therefore trying to configure zeppelin to
>> impersonate the logged in user, but experiencing difficulties
>>
>> Can anyone supply a list of properties/variables that require configuring
>> to achieve this.
>>
>>
>>
>> Regards
>>
>>
>>
>> Neil Morris
>>
>> *Big Data Engineer*
>>
>> *Argos Ltd. *
>>
>> *489-499 Avebury Boulevard,
>> <https://maps.google.com/?q=489-499+Avebury+Boulevard,+Milton+Keynes+MK9+2NW&entry=gmail&source=g> Milton
>> Keynes MK9 2NW
>> <https://maps.google.com/?q=489-499+Avebury+Boulevard,+Milton+Keynes+MK9+2NW&entry=gmail&source=g>*
>>
>>
>>
>> Mobile: 07964 784257
>>
>> LinkedIn <https://www.linkedin.com/in/neil-morris-31746242>
>> This email and any files transmitted with it are confidential and
>> intended solely for the use of the individual or entity to whom they are
>> addressed. Unauthorised disclosure, copying or dissemination of the
>> contents is strictly prohibited. The views expressed within this
>> communication may not be official policy, but the personal views of the
>> originator. If you are not the intended recipient or have received this
>> message in error, please delete this e-mail and advise the sender. All
>> messages sent and received by Argos Limited are monitored for viruses,
>> high-risk file extensions, and inappropriate content. Sainsbury's Argos is
>> a trading name of both: 1) Argos Limited, Registered office: 489-499
>> Avebury Boulevard, Milton Keynes, United Kingdom, MK9 2NW
>> <https://maps.google.com/?q=499+Avebury+Boulevard,+Milton+Keynes,+United+Kingdom,+MK9+2NW&entry=gmail&source=g>,
>> registered number: 01081551 (England and Wales); and 2) Sainsbury's
>> Supermarkets Ltd, Registered office: 33 Holborn, London, EC1N 2HT
>> <https://maps.google.com/?q=33+Holborn,+London,+EC1N+2HT&entry=gmail&source=g>,
>> registered number: 03261722 (England and Wales). Both companies are
>> subsidiaries of J Sainsbury plc (185647).
>>
>> --
> Take Care
> Fawze Abujaber
>
--
Abhi Basu
Re: Zeppelin and impersonation
Posted by Fawze Abujaber <fa...@gmail.com>.
Anyone who used Zeppelin to run queries through impala?
On Wed, 12 Dec 2018 at 14:54 Paul Brenner <pb...@placeiq.com> wrote:
> We just did this on our install recently following the steps in the guide
> here:
>
>
> https://zeppelin.apache.org/docs/0.8.0/usage/interpreter/user_impersonation.html
>
> If that doesn’t work maybe you could call out where it fails?
>
>
> PAUL BRENNER
>
> Sr. Data Scientist
> pbrenner@placeiq.com | (217) 390-3033 | www.placeiq.com
> twitter @placeiq <https://twitter.com/PlaceIQ> linkedin /placeiq
> <https://www.linkedin.com/company/placeiq/>
>
> [image: PlaceIQ:CES 2018]
> <http://pages.placeiq.com/FY19Q1---CES-Meetings_LP---Meeting-Request.html>
> On Dec 12, 2018, 3:06 AM -0500, Neil Morris <Ne...@argos.co.uk>,
> wrote:
>
> Hi There,
>
>
>
> We run Cloudera 5.12, and have a Kerborised Hadoop Cluster. We have
> installed zeppelin under its own local user and control access to zeppelin
> via AD.
>
>
>
> As the standards on our estate dictate, whatever runs on the cluster must
> be auditable. We are therefore trying to configure zeppelin to impersonate
> the logged in user, but experiencing difficulties
>
> Can anyone supply a list of properties/variables that require configuring
> to achieve this.
>
>
>
> Regards
>
>
>
> Neil Morris
>
> *Big Data Engineer*
>
> *Argos Ltd. *
>
> *489-499 Avebury Boulevard,
> <https://maps.google.com/?q=489-499+Avebury+Boulevard,+Milton+Keynes+MK9+2NW&entry=gmail&source=g> Milton
> Keynes MK9 2NW
> <https://maps.google.com/?q=489-499+Avebury+Boulevard,+Milton+Keynes+MK9+2NW&entry=gmail&source=g>*
>
>
>
> Mobile: 07964 784257
>
> LinkedIn <https://www.linkedin.com/in/neil-morris-31746242>
> This email and any files transmitted with it are confidential and intended
> solely for the use of the individual or entity to whom they are addressed.
> Unauthorised disclosure, copying or dissemination of the contents is
> strictly prohibited. The views expressed within this communication may not
> be official policy, but the personal views of the originator. If you are
> not the intended recipient or have received this message in error, please
> delete this e-mail and advise the sender. All messages sent and received by
> Argos Limited are monitored for viruses, high-risk file extensions, and
> inappropriate content. Sainsbury's Argos is a trading name of both: 1)
> Argos Limited, Registered office: 489-499 Avebury Boulevard, Milton
> Keynes, United Kingdom, MK9 2NW
> <https://maps.google.com/?q=499+Avebury+Boulevard,+Milton+Keynes,+United+Kingdom,+MK9+2NW&entry=gmail&source=g>,
> registered number: 01081551 (England and Wales); and 2) Sainsbury's
> Supermarkets Ltd, Registered office: 33 Holborn, London, EC1N 2HT
> <https://maps.google.com/?q=33+Holborn,+London,+EC1N+2HT&entry=gmail&source=g>,
> registered number: 03261722 (England and Wales). Both companies are
> subsidiaries of J Sainsbury plc (185647).
>
> --
Take Care
Fawze Abujaber