I'm using impala JDBC and not ODBC and it's not working .... On Wed, Dec 12, 2018 at 8:13 PM Abhi Basu <9000r...@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 <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 > -- Take Care Fawze Abujaber