You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@zeppelin.apache.org by Richard Xin <ri...@yahoo.com> on 2017/08/03 01:21:01 UTC

configure Zeppelin to use existing external hive metastore

on AWS EMRI am trying to bind zeppelin to an existing hive metastore, I modified hive-site.xml under /etc/hive/conf to pointing to existing metastore, and I tested with commandline hive, it works as expected.but under zeppelin %sql is still connected to previous hive metastore, I added line export HIVE_CONF_DIR=/etc/hive/conf
inside zeppelin-env.sh

And /etc/spark/conf's spark-env.sh has following line by default:export HIVE_CONF_DIR=${HIVE_CONF_DIR:-/etc/hive/conf}

What did I miss?

Thanks

Re: configure Zeppelin to use existing external hive metastore

Posted by Richard Xin <ri...@yahoo.com>.
It works, Thanks Jeff!

On Wednesday, August 2, 2017, 6:24:34 PM PDT, Jeff Zhang <zj...@gmail.com> wrote:


I suppose the %sql means %spark.sql, in that case you need to modify the hive-site.xml under SPARK_CONF_DIR

Richard Xin <ri...@yahoo.com>于2017年8月3日周四 上午9:21写道：

on AWS EMRI am trying to bind zeppelin to an existing hive metastore, I modified hive-site.xml under /etc/hive/conf to pointing to existing metastore, and I tested with commandline hive, it works as expected.but under zeppelin %sql is still connected to previous hive metastore, I added line export HIVE_CONF_DIR=/etc/hive/conf
inside zeppelin-env.sh

And /etc/spark/conf's spark-env.sh has following line by default:export HIVE_CONF_DIR=${HIVE_CONF_DIR:-/etc/hive/conf}

What did I miss?

Thanks

Re: configure Zeppelin to use existing external hive metastore

Posted by Jeff Zhang <zj...@gmail.com>.
I suppose the %sql means %spark.sql, in that case you need to modify the
hive-site.xml under SPARK_CONF_DIR


Richard Xin <ri...@yahoo.com>于2017年8月3日周四 上午9:21写道：

> on AWS EMR
> I am trying to bind zeppelin to an existing hive metastore, I modified
> hive-site.xml under /etc/hive/conf to pointing to existing metastore, and I
> tested with commandline hive, it works as expected.
> but under zeppelin %sql is still connected to previous hive metastore,
> I added line
> export HIVE_CONF_DIR=/etc/hive/conf
> inside zeppelin-env.sh
>
>
> And /etc/spark/conf's spark-env.sh has following line by default:
> export HIVE_CONF_DIR=${HIVE_CONF_DIR:-/etc/hive/conf}
>
> What did I miss?
>
> Thanks
>