it turns out to be a environment issue. i was running hive server using
another user:
sudo -u op
but the system resets all environment variables for that user under sudo
command. the fix i put in is to put environment variable names in env_keep
in /etc/sudoers. after that hive server is running
I havn't tried setting hive with derby server yet. I am using mysql as
metastore. But not much difference I think.
To setup Hive server in remote machine you should add the all the hadoop and
hive packages (folders) under ur working directory. Set the hadoop master
and slaves
accordingly. Setup t
hmm, nobody replied to my email earlier so going to send this out one last
time, sorry for the spam guys.
btw, i also exported these env variables before starting hive server:
export HADOOP_CONF_DIR
export HADOOP_HOME
export HIVE_CONF_DIR
export HIVE_HOME
export PATH=$HIVE_HOME/bin:$PATH
