hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pavan <yarapa...@gmail.com>
Subject Re: Question table visibility in hive
Date Sat, 13 Nov 2010 13:40:33 GMT
The default hive configuration makes use of Derby, an embedded derby
database, for storing metadata. This is usually metastore_db in your
current directory from where hive is launched [configured via
javax.jdo.option.ConnectionURL in conf/hive-site.xml]. In the default
configuration, this metadata is only visible to one user at a time.

If you change directories, it doesn't find metastore_db anymore and
thus doesn't show up your tables.


~
Pavan
** Sent from Mobile **



On Sat, Nov 13, 2010 at 4:53 AM, M.R. Muthukumar <m_muthukumar@yahoo.com> wrote:
> Environment Info :
>
> SLES10SP1, Hadoop 0.20.2, Hive 0.6.0
>
> This is the scenario :
>
> 1. start hive shell from /root/tmp directory and create a table and quit out of hive.
>
> 2. start hive shell from /root directory, show tables does not show the created table,
this new
>    table is not visible at all.
>
> Can some of you please shed some light on this, is this by design.
>
> Any help is greatly appreciated.
>
> Thanks
>
> -Muthu
>
>
>
>
>
>

Mime
View raw message