thanks, I fixed it. it turns out that I need to put my hive-site.xml into
classpath, without this, it still mysteriously works and somehow gave me a
default db. (I wish it had given a more explicit error )
On Mon, Dec 30, 2013 at 12:42 PM, java8964 java8...@hotmail.com wrote:
Best mailing list for this question is hive, but I will try to give my
guess here anyway.
If you only see 'default' database, most likely you are using hive
'LocalMetaStore'. For helping yourself to find out the problem, try to find
out following information:
1) What kind of Hive metastore you are using? Did you configure any thing?
Most widely used are Derby or Mysql.
2) If you are using a remote Hive metastore, did the hive-conf folder
passed to the class path of your Java program? From the following log, it
looks like wrong hive conf files are passed in:
[2013-12-30 11:44:03,261] INFO ugi=myuser_name ip=unknown-ip-addr
cmd=get_all_databases
Yong
--
From: tedd...@gmail.com
Date: Mon, 30 Dec 2013 11:48:55 -0800
Subject: HiveMetaStoreClient only sees one of my DBs ?
To: hive-u...@hadoop.apache.org
if I log into my hive shell, do show databases; , I see many DBs:
Logging initialized using configuration in
file:/etc/hive/conf/hive-log4j.properties
hive show databases;
OK
conf
confnew
default
money
testdb
Time taken: 1.57 seconds, Fetched: 6 row(s)
but somehow if I run the following java code using the client API, it only
shows default
public static void main(String args[]) throws MetaException {
HiveMetaStoreClient cli = new HiveMetaStoreClient(new HiveConf());
for(String db: cli.getAllDatabases())
System.out.println(db);
}
stence)
[2013-12-30 11:44:02,900] INFO Validating 2 unique key(s) for table DBS
(DataNucleus.Datastore.Schema)
[2013-12-30 11:44:02,913] INFO Validating 0 foreign key(s) for table DBS
(DataNucleus.Datastore.Schema)
[2013-12-30 11:44:02,919] INFO Validating 2 index(es) for table DBS
(DataNucleus.Datastore.Schema)
[2013-12-30 11:44:02,926] INFO Validating 1 unique key(s) for table
DATABASE_PARAMS (DataNucleus.Datastore.Schema)
[2013-12-30 11:44:02,937] INFO Validating 1 foreign key(s) for table
DATABASE_PARAMS (DataNucleus.Datastore.Schema)
[2013-12-30 11:44:02,942] INFO Validating 2 index(es) for table
DATABASE_PARAMS (DataNucleus.Datastore.Schema)
[2013-12-30 11:44:03,087] INFO Listener found initialisation for
persistable class org.apache.hadoop.hive.metastore.model.MDatabase
(DataNucleus.MetaData)
[2013-12-30 11:44:03,211] INFO 0: get_all_databases
(org.apache.hadoop.hive.metastore.HiveMetaStore)
[2013-12-30 11:44:03,261] INFO ugi=myuser_name ip=unknown-ip-addr
cmd=get_all_databases
(org.apache.hadoop.hive.metastore.HiveMetaStore.audit)
default
why is it showing only 1 db? what setttings of default are different from
the others to enable it to be shown? also I wonder how is that HiveConf()
initialized ? how does it even know the hive port and config settings ? is
it hardcoded to /etc/hive/conf/hive-site.xml ?
thanks
Yang