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 <fawz...@gmail.com> wrote: > So you are using hive JDBC and not impala JBC .... > > > > On Wed, Dec 12, 2018 at 7:47 PM Abhi Basu <9000r...@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 <fawz...@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 <9000r...@gmail.com> wrote: >>> >>>> Yes, we use Zeppelin and Impala. What is your question? >>>> >>>> On Wed, Dec 12, 2018 at 11:03 AM Fawze Abujaber <fawz...@gmail.com> >>>> wrote: >>>> >>>>> Anyone who used Zeppelin to run queries through impala? >>>>> >>>>> On Wed, 12 Dec 2018 at 14:54 Paul Brenner <pbren...@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 >>>>>> pbren...@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.mor...@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
