It may be because you may be using the default config which creates metadata in a directory relative to current directory. Check whether you have multiple 'metastore_db' directories. If so then try to set up a common metastore by changing config (conf/hive-default.xml --> conf/hive-site.xml) or follow the instructions at http://wiki.apache.org/hadoop/Hive/AdminManual/MetastoreAdmin
________________________________ From: chen keven <[email protected]> Reply-To: <[email protected]> Date: Fri, 17 Jul 2009 10:48:57 -0700 To: <[email protected]> Subject: Fwd: create tables question I'm trying to create tables pragmatically using JDBC. However, I can't really see the table I created from the hive shell. What's worse, when i access hive shell from different directories, i see different tables in the database. Is any setting i need to configure? Thanks in advance. -- Thank you, Keven Chen
