Hi, Try either a) place your hive-site.xml in ZEPPELIN_HOME/conf dir, b) export HADOOP_CONF_DIR in ZEPPELIN_HOME/conf/zeppelin-env.sh to the directory that contains your hive-site.xml
Thanks, moon On Sun, Jun 28, 2015 at 6:12 AM Brian McDevitt <brian.mcdev...@nerdery.com> wrote: > If you don't have the hive-site.xml in your SPARK_HOME/conf directory, > spark will create a new Hive metastore in the current directory. See > https://spark.apache.org/docs/1.3.1/sql-programming-guide.html#hive-tables > > You can test this by running the spark-shell and trying to use > sqlContext.sql("show databases"). When you quit the spark-shell, if > there's a metastore directory created, then you don't have spark configured > correctly for Hive. > > HTH > > > Thanks, > Brian McDevitt > Software Engineer > The Nerdery > > On Sun, Jun 28, 2015 at 1:22 AM, IT CTO <goi....@gmail.com> wrote: > >> Can you access these databases? e.g. use %hive to list the DB and then >> use %sql to select from them? >> I have the same behavior >> Eran >> >> On Sun, Jun 28, 2015 at 8:21 AM Vadla, Karthik <karthik.va...@intel.com> >> wrote: >> >>> Hi All, >>> >>> >>> >>> Recently I have imported new databases into my hive meta store on >>> cluster. >>> >>> When I use %sql interpreter with below commands. I’m not able to see >>> newly imported databases. >>> >>> >>> >>> Command used: >>> >>> >>> >>> *%sql* >>> >>> >>> >>> *show databases* >>> >>> >>> >>> It shows only default databases not the newly imported databases. But >>> when I use hive command from command line >>> >>> >>> >>> *$hive –e “show databases”* >>> >>> >>> >>> It shows all the newly imported databases too. >>> >>> >>> >>> >>> >>> Do anyone have clue on this, why I’m not able to see with zeppelin >>> >>> Appreciate your help. >>> >>> >>> >>> Thanks >>> >>> Karthik Vadla >>> >> >
