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<mailto: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<mailto: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<mailto: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<mailto: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<mailto: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<mailto: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<mailto: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.
