Re: Custom hive-site.xml is ignored, how to find out why

2012-11-26 Thread Stephen Boesch
Hi, The problem may not have to do with hive-site.xml. When I run hive client by itself it connects successfully to mysql and creates / reads metadataa. The problem comes in when i run the metastore/thrift servers via: hive --service metastore hive --service hiveserver. As soon as i do th

Re: Custom hive-site.xml is ignored, how to find out why

2012-11-26 Thread Shreepadma Venugopalan
Hi Stephen, If you wish to setup a mysql metastore, you need to have the following in your hive-site.xml, javax.jdo.option.ConnectionURL jdbc:mysql://MYHOST/metastore javax.jdo.option.ConnectionDriverName com.mysql.jdbc.Driver javax.jdo.option.ConnectionUserName hiveuser j

Re: Custom hive-site.xml is ignored, how to find out why

2012-11-24 Thread Stephen Boesch
It appears that I were missing the *hive.metastore.uris* parameter. That one was not mentioned in the (several) blogs / tutorials that I had seen. 2012/11/24 Stephen Boesch > > It seems the customized hive-site.xml is not being read. It lives under > $HIVE_HOME/conf ( which happens to be /sha

Custom hive-site.xml is ignored, how to find out why

2012-11-24 Thread Stephen Boesch
It seems the customized hive-site.xml is not being read. It lives under $HIVE_HOME/conf ( which happens to be /shared/hive/conf). I have tried everything there is to try: set HIVE_CONF_DIR=/shared/hive/conf , added --config /shared/hive/conf and added debugging to the hive shell script (bash -x