Based on the default hive configuration, different directories called
metastore_db can be created in different locations... If you are prototyping
and trying hive with your peers, it is even worse... Someone creates a
table, others don't see it due to the fact that users are not using the same
meta
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
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.
