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 <fawz...@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 <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 > -- Abhi Basu
