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
>>
>
