You could use the JDBC interpreter to setup a new interpreter for Impala. That said, Impala is just using your hive metastore and enabling proprietary caching for high performance on your hive database tables rather than doing map reduce translation of hive queries. Running Spark SQL on spark interpreter can be considered as a reasonable alternative to running impala queries through jdbc.
http://www.cloudera.com/documentation/archive/impala/2-x/2-1-x/topics/impala_jdbc.html Thanks, Pradeep On Wed, Aug 31, 2016 at 10:45 AM, Abhi Basu <9000r...@gmail.com> wrote: > How do I setup a connection to impala? Do I need to point to impala-jdbc > jar in dependencies? > > Thanks, > > Abhi > > On Wed, Aug 31, 2016 at 10:36 AM, Abhi Basu <9000r...@gmail.com> wrote: > >> OK, got it. Added the hadoop jar to dependencies and it started working. >> >> Thanks. >> >> On Wed, Aug 31, 2016 at 10:24 AM, Abhi Basu <9000r...@gmail.com> wrote: >> >>> So, path to the jars like /usr/lib/hive/* ? >>> >>> On Wed, Aug 31, 2016 at 9:53 AM, Jeff Zhang <zjf...@gmail.com> wrote: >>> >>>> You don't need to copy these jars manually, just specify them in the >>>> interpreter setting page. >>>> >>>> On Wed, Aug 31, 2016 at 9:52 PM, Abhi Basu <9000r...@gmail.com> wrote: >>>> >>>>> Where do these jars have to be placed? >>>>> >>>>> I thought copying the hive-site.xml and pointing to hadoop conf folder >>>>> in zeppelin conf should be enough (like before). >>>>> >>>>> Thanks, >>>>> >>>>> Abhi >>>>> >>>>> On Tue, Aug 30, 2016 at 6:59 PM, Jeff Zhang <zjf...@gmail.com> wrote: >>>>> >>>>>> You need add the following 2 dependencies in the interpreter setting >>>>>> page. >>>>>> >>>>>> https://zeppelin.apache.org/docs/0.6.1/interpreter/hive.html >>>>>> #dependencies >>>>>> >>>>>> org.apache.hive:hive-jdbc:0.14.0 >>>>>> org.apache.hadoop:hadoop-common:2.6.0 >>>>>> >>>>>> >>>>>> On Wed, Aug 31, 2016 at 2:39 AM, Abhi Basu <9000r...@gmail.com> >>>>>> wrote: >>>>>> >>>>>>> Folks: >>>>>>> >>>>>>> Seems like a config issue. >>>>>>> >>>>>>> 1. Copied hive-site.xml into /ZEPP_HOME/conf folder >>>>>>> 2. Added following to config file: >>>>>>> >>>>>>> export JAVA_HOME=/...../...export HADOOP_CONF_DIR=/etc/hadoop/conf >>>>>>> >>>>>>> >>>>>>> I am using Zeppelin after a while, and looks like Hive interpreter >>>>>>> is part of JDBC interpreter now. >>>>>>> Interpreter properties seem to be set correctly: >>>>>>> PropertyValue >>>>>>> hive.driver org.apache.hive.jdbc.HiveDriver >>>>>>> hive.url jdbc:hive2://localhost:10000 >>>>>>> hive.user hiveUser >>>>>>> hive.password hivePassword >>>>>>> >>>>>>> When I run %hive from Zeppelin, I get a hive jdbc driver not found >>>>>>> error. How do I fix this? Also, how do I configure for Impala within the >>>>>>> JDBC section of interpreters. >>>>>>> >>>>>>> Thanks, >>>>>>> >>>>>>> Abhi >>>>>>> >>>>>>> -- >>>>>>> Abhi Basu >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Best Regards >>>>>> >>>>>> Jeff Zhang >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> Abhi Basu >>>>> >>>> >>>> >>>> >>>> -- >>>> Best Regards >>>> >>>> Jeff Zhang >>>> >>> >>> >>> >>> -- >>> Abhi Basu >>> >> >> >> >> -- >> Abhi Basu >> > > > > -- > Abhi Basu >
