I setup Hive cdh4 on RHEL 5 with remote metastore using mysql. I created a database, in mysql, with the same name as in hive-site.xml. I started up metastore server and hive server, but whenever I try to query hive, it throws me an error NoSuchFieldError: METASTORETHRIFTRETRIES.
I believe I'm unable to connect to metastore server or thrift server and this is causing this problem. Please point me to the right path.
Did you run mysql scripts for Hive from $HIVE_HOME/scripts/metastore/upgrade/mysql ?