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_muthuku...@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 > > > > > >
