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
