You can put hive-site.xml into Zeppelin's conf directory or set 'export HADOOP_CONF_DIR=$path/to/hive-site/location' in zeppelin-env.sh in conf directory.
On Wed, Jul 29, 2015 at 8:34 AM, Abhi Basu <9000r...@gmail.com> wrote: > So change it in the hive-site.xml file located in the Zeppelin install > folder? > > On Tue, Jul 28, 2015 at 3:45 PM, Litt, Shaun <sl...@conversantmedia.com> > wrote: > >> Can you just specify this parameter within your JDBC connection URL if >> you really want to make this your default? >> >> >> https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients#HiveServer2Clients-ConnectionURLFormat >> >> >> >> Thanks, >> >> >> >> *Shaun* *Litt* >> >> *From:* Abhi Basu [mailto:9000r...@gmail.com] >> *Sent:* Tuesday, July 28, 2015 5:10 PM >> *To:* Zeppelin Users >> *Subject:* Re: Hive on Spark >> >> >> >> Revisting this. >> >> >> >> So, to get the hive interpreter within Zeppelin to use HOS, I need to >> modify the hive-site.xml file in the thrift server location, correct? >> Modifying the hive-site.xml file in Zeppelin conf folder does not have any >> effect. >> >> >> >> >> >> >> >> On Sat, Jul 11, 2015 at 9:26 AM, <felixcheun...@hotmail.com> wrote: >> >> Are you referring to the Hive interpreter? Zeppelin connects to Hive >> through JDBC that way. >> >> >> >> On Fri, Jul 10, 2015 at 9:59 AM -0700, "John Omernik" <j...@omernik.com> >> wrote: >> >> Zeppelin needs to connect to a Thrift server, Zeppelin doesn't read the >> hive-site.xml. Basically you need to figure out where the thrift is >> running, and ensure ITS hive-site has the proper settings (and possibly >> restart the service) >> >> >> >> >> >> >> >> On Fri, Jul 10, 2015 at 11:52 AM, Abhi Basu <9000r...@gmail.com> wrote: >> >> We use CDH5.4. I was able to change the hive-site.xml using the CM >> option - enable Hive on Spark. That same hive-site.xml has been copied to >> the Zeppelin conf folder. Am I missing anything? As I said, I can confirm >> that HOS works from inside Hive CLI (but that is different from using HS2). >> >> >> >> On Fri, Jul 10, 2015 at 9:45 AM, John Omernik <j...@omernik.com> wrote: >> >> Zeppelin is connecting to a Hive Thrift Server (Hiveserver2) in your >> org. Can you run another instance where you start it with the execution >> engine being spark or perhaps set it in the hive-site.xml? >> >> >> >> On Fri, Jul 10, 2015 at 10:51 AM, Abhi Basu <9000r...@gmail.com> wrote: >> >> SET hive.execution.engine=spark within Zeppelin seems to have no >> effect. In Hive CLI, it does work. >> >> >> >> On Thu, Jul 9, 2015 at 7:20 PM, <felixcheun...@hotmail.com> wrote: >> >> Could you set the execution engine using thesetConf method >> on SQLContext or by running SET key=value commands using SQL statement? >> >> >> >> On Thu, Jul 9, 2015 at 7:09 AM -0700, "Abhi Basu" <9000r...@gmail.com> >> wrote: >> >> How to use Hive on Spark from within Zeppelin? We are using Cdh5.4 where >> we are able to enable HOS and I can enable this in hive cli by setting >> hive.execution.engine=spark and see the differences in query times. Queries >> in Zeppelin executes on MR instead. Hive configuration file in Zeppelin is >> updated with latest version from Hive. >> >> >> >> Thanks >> >> >> >> Abhi >> >> >> >> >> >> >> >> Sent via the Samsung Galaxy Note®, an AT&T 4G LTE smartphone >> >> >> >> >> >> -- >> >> Abhi Basu >> >> >> >> >> >> >> >> -- >> >> Abhi Basu >> >> >> >> >> >> >> >> -- >> >> Abhi Basu >> >> This email and any files included with it may contain privileged, >> proprietary and/or confidential information that is for the sole use >> of the intended recipient(s). Any disclosure, copying, distribution, >> posting, or use of the information contained in or attached to this >> email is prohibited unless permitted by the sender. If you have >> received this email in error, please immediately notify the sender >> via return email, telephone, or fax and destroy this original transmission >> and its included files without reading or saving it in any manner. >> Thank you. >> > > > > -- > Abhi Basu > -- 이종열, Jongyoul Lee, 李宗烈 http://madeng.net
