Thanks. It works for me. Joshua
From: Jongyoul Lee <jongy...@gmail.com> To: users@zeppelin.incubator.apache.org Date: 03/16/2016 09:21 AM Subject: Re: Configure embedded hive to use remote mysql Hi Joshua, If you are using SparkSql, it would works by adding your hive-site.xml in a class path, and if you are using HiveInterpreter, it's only step that you have to add hiveserver2 url in the interpreter settings. Hope this help. Jongyoul On Tue, Mar 15, 2016 at 8:59 AM, Joshua W Hui <j...@us.ibm.com> wrote: Hi, I have been playing around the zeppelin 0.5.5 which I downloaded directly from the apache site. When I was trying to use the hive to load/run query, it often complaints the embedded derby database is already attached to another application. I guess that is because it only allows one application to connect to the derby db at a time. So I would like to configure the hive to connect to the remote MySQL db. Is there a way to do it? Since hive is packaged inside zeppelin, I cannot find any site.xml file to configure hive. Any help is appreciated. Joshua -- 이종열, Jongyoul Lee, 李宗烈 http://madeng.net
