Hive : Tables are not displayed

[vaibhav negi <ss...@gmail.com>]

Hi,

I am using hadoop version 0.20 . I created a table in hive ,then i opened
another terminal and entered "show tables" command, but it showed no tables.
then i created another table with same table name again in later terminal.
It allowed creating it. then i closed both terminals and opened third
terminal and enetered show tables command and got error message .

Also, sometimes on entering "show tables " command hive returned no tables
and i need to reopen the terminal.

Is it a bug or there needs to make some configuration changes.

Vaibhav Negi

Re: Hive : Tables are not displayed

[Prasad Chakka <pc...@facebook.com>]

Hive stores all table information in a metastore and by default it is a local metastore that is stored off your working directory. Check http://wiki.apache.org/hadoop/Hive/AdminManual/MetastoreAdmin on how to setup a shared metastore that can be used by multiple users from multiple hosts.

Prasad

On Jul 28, 2010, at 4:35 AM, vaibhav negi wrote:

> Hi,
> 
> I am using hadoop version 0.20 . I created a table in hive ,then i opened another terminal and entered "show tables" command, but it showed no tables. then i created another table with same table name again in later terminal. It allowed creating it. then i closed both terminals and opened third terminal and enetered show tables command and got error message .
> 
> Also, sometimes on entering "show tables " command hive returned no tables and i need to reopen the terminal.
> 
> Is it a bug or there needs to make some configuration changes.
> 
> Vaibhav Negi