hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From java8964 <>
Subject RE: HiveMetaStoreClient only sees one of my DBs ?
Date Mon, 30 Dec 2013 20:42:25 GMT
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	

Date: Mon, 30 Dec 2013 11:48:55 -0800
Subject: HiveMetaStoreClient only sees one of my DBs ?

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.propertieshive>
show databases;

moneytestdbTime 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

[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)


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 ?


View raw message