ERROR :regarding Hive WI, hwi service is not running
Hi all, I am trying to run hive wi but its showing FATAL, I have used this command hive --service hwi but it shows.. yogesh@yogesh-Aspire-5738:/opt/hive-0.8.1/lib$ hive --service hwi 12/09/20 03:12:03 INFO hwi.HWIServer: HWI is starting up 12/09/20 03:12:04 FATAL hwi.HWIServer: HWI WAR file not found at /opt/hive-0.8.1/lib/hive-hwi-0.8.1.war although lies there. yogesh@yogesh-Aspire-5738:/opt/hive-0.8.1/lib$ pwd /opt/hive-0.8.1/lib ls -l -rw-rw-r-- 1 root root 55876 Jan 26 2012 hive-common-0.8.1.jar -rw-rw-r-- 1 root root 112440 Jan 26 2012 hive-contrib-0.8.1.jar -rw-rw-r-- 1 root root 112440 Jan 26 2012 hive_contrib.jar -rw-rw-r-- 1 root root 3461228 Jan 26 2012 hive-exec-0.8.1.jar -rw-rw-r-- 1 root root 48829 Jan 26 2012 hive-hbase-handler-0.8.1.jar -rw-rw-r-- 1 root root 23529 Jan 26 2012 hive-hwi-0.8.1.jar -rwxrwxrwx 1 root root 28413 Jan 26 2012 hive-hwi-0.8.1.war -rw-rw-r-- 1 root root 58914 Jan 26 2012 hive-jdbc-0.8.1.jar -rw-rw-r-- 1 root root 1765743 Jan 26 2012 hive-metastore-0.8.1.jar -rw-rw-r-- 1 root root 14081 Jan 26 2012 hive-pdk-0.8.1.jar -rw-rw-r-- 1 root root 509488 Jan 26 2012 hive-serde-0.8.1.jar -rw-rw-r-- 1 root root 174445 Jan 26 2012 hive-service-0.8.1.jar -rw-rw-r-- 1 root root 110154 Jan 26 2012 hive-shims-0.8.1.jar -rw-rw-r-- 1 root root 15260 Jan 24 2012 javaewah-0.3.jar -rw-rw-r-- 1 root root 198552 Dec 24 2009 jdo2-api-2.3-ec.jar Please suggest regarding Thanks regards Yogesh Kumar
Re: ERROR :regarding Hive WI, hwi service is not running
It's probably looking for that file on HDFS. Try placing it there under the given location and see if you get the same error. On Wed, Sep 19, 2012 at 4:45 PM, yogesh dhari yogeshdh...@live.com wrote: Hi all, I am trying to run hive wi but its showing FATAL, I have used this command * hive --service hwi * but it shows.. yogesh@yogesh-Aspire-5738:/opt/hive-0.8.1/lib$ hive --service hwi *12/09/20 03:12:03 INFO hwi.HWIServer: HWI is starting up 12/09/20 03:12:04 FATAL hwi.HWIServer: HWI WAR file not found at /opt/hive-0.8.1/lib/hive-hwi-0.8.1.war * although lies there. yogesh@yogesh-Aspire-5738:/opt/hive-0.8.1/lib$ pwd */opt/hive-0.8.1/lib* ls -l -rw-rw-r-- 1 root root 55876 Jan 26 2012 hive-common-0.8.1.jar -rw-rw-r-- 1 root root 112440 Jan 26 2012 hive-contrib-0.8.1.jar -rw-rw-r-- 1 root root 112440 Jan 26 2012 hive_contrib.jar -rw-rw-r-- 1 root root 3461228 Jan 26 2012 hive-exec-0.8.1.jar -rw-rw-r-- 1 root root 48829 Jan 26 2012 hive-hbase-handler-0.8.1.jar -rw-rw-r-- 1 root root 23529 Jan 26 2012 hive-hwi-0.8.1.jar *-rwxrwxrwx 1 root root 28413 Jan 26 2012 hive-hwi-0.8.1.war* -rw-rw-r-- 1 root root 58914 Jan 26 2012 hive-jdbc-0.8.1.jar -rw-rw-r-- 1 root root 1765743 Jan 26 2012 hive-metastore-0.8.1.jar -rw-rw-r-- 1 root root 14081 Jan 26 2012 hive-pdk-0.8.1.jar -rw-rw-r-- 1 root root 509488 Jan 26 2012 hive-serde-0.8.1.jar -rw-rw-r-- 1 root root 174445 Jan 26 2012 hive-service-0.8.1.jar -rw-rw-r-- 1 root root 110154 Jan 26 2012 hive-shims-0.8.1.jar -rw-rw-r-- 1 root root 15260 Jan 24 2012 javaewah-0.3.jar -rw-rw-r-- 1 root root 198552 Dec 24 2009 jdo2-api-2.3-ec.jar Please suggest regarding Thanks regards Yogesh Kumar -- Swarnim
RE: ERROR :regarding Hive WI, hwi service is not running
Hello Swarnim, Are you saying to put hive-hwi-0.8.1.war into hadoop/lib ? I have put it over there and still the same issue.. Thanks Regards Yogesh Kumar From: kulkarni.swar...@gmail.com Date: Wed, 19 Sep 2012 16:48:37 -0500 Subject: Re: ERROR :regarding Hive WI, hwi service is not running To: user@hive.apache.org It's probably looking for that file on HDFS. Try placing it there under the given location and see if you get the same error. On Wed, Sep 19, 2012 at 4:45 PM, yogesh dhari yogeshdh...@live.com wrote: Hi all, I am trying to run hive wi but its showing FATAL, I have used this command hive --service hwi but it shows.. yogesh@yogesh-Aspire-5738:/opt/hive-0.8.1/lib$ hive --service hwi 12/09/20 03:12:03 INFO hwi.HWIServer: HWI is starting up 12/09/20 03:12:04 FATAL hwi.HWIServer: HWI WAR file not found at /opt/hive-0.8.1/lib/hive-hwi-0.8.1.war although lies there. yogesh@yogesh-Aspire-5738:/opt/hive-0.8.1/lib$ pwd /opt/hive-0.8.1/lib ls -l -rw-rw-r-- 1 root root 55876 Jan 26 2012 hive-common-0.8.1.jar -rw-rw-r-- 1 root root 112440 Jan 26 2012 hive-contrib-0.8.1.jar -rw-rw-r-- 1 root root 112440 Jan 26 2012 hive_contrib.jar -rw-rw-r-- 1 root root 3461228 Jan 26 2012 hive-exec-0.8.1.jar -rw-rw-r-- 1 root root 48829 Jan 26 2012 hive-hbase-handler-0.8.1.jar -rw-rw-r-- 1 root root 23529 Jan 26 2012 hive-hwi-0.8.1.jar -rwxrwxrwx 1 root root 28413 Jan 26 2012 hive-hwi-0.8.1.war -rw-rw-r-- 1 root root 58914 Jan 26 2012 hive-jdbc-0.8.1.jar -rw-rw-r-- 1 root root 1765743 Jan 26 2012 hive-metastore-0.8.1.jar -rw-rw-r-- 1 root root 14081 Jan 26 2012 hive-pdk-0.8.1.jar -rw-rw-r-- 1 root root 509488 Jan 26 2012 hive-serde-0.8.1.jar -rw-rw-r-- 1 root root 174445 Jan 26 2012 hive-service-0.8.1.jar -rw-rw-r-- 1 root root 110154 Jan 26 2012 hive-shims-0.8.1.jar -rw-rw-r-- 1 root root 15260 Jan 24 2012 javaewah-0.3.jar -rw-rw-r-- 1 root root 198552 Dec 24 2009 jdo2-api-2.3-ec.jar Please suggest regarding Thanks regards Yogesh Kumar -- Swarnim
RE: ERROR :regarding Hive WI, hwi service is not running
Swarnim, opt/hive-0.8.1/lib already exists, its the path of hive dir hive-hwi-0.8.1.war already exists there. /opt/hive-0.8.1/lib ls -l -rw-rw-r-- 1 root root 55876 Jan 26 2012 hive-common-0.8.1.jar -rw-rw-r-- 1 root root 112440 Jan 26 2012 hive-contrib-0.8.1.jar -rw-rw-r-- 1 root root 112440 Jan 26 2012 hive_contrib.jar -rw-rw-r-- 1 root root 3461228 Jan 26 2012 hive-exec-0.8.1.jar -rw-rw-r-- 1 root root 48829 Jan 26 2012 hive-hbase-handler-0.8.1.jar -rw-rw-r-- 1 root root 23529 Jan 26 2012 hive-hwi-0.8.1.jar -rwxrwxrwx 1 root root 28413 Jan 26 2012 hive-hwi-0.8.1.war -rw-rw-r-- 1 root root 58914 Jan 26 2012 hive-jdbc-0.8.1.jar -rw-rw-r-- 1 root root 1765743 Jan 26 2012 hive-metastore-0.8.1.jar Thats what its very surprising :-( Thanks Regards Yogesh Kumar From: kulkarni.swar...@gmail.com Date: Wed, 19 Sep 2012 16:58:01 -0500 Subject: Re: ERROR :regarding Hive WI, hwi service is not running To: user@hive.apache.org No. I meant create /opt/hive-0.8.1/lib/ in HDFS and place the hive-hwi-0.8.1.war there. On Wed, Sep 19, 2012 at 4:55 PM, yogesh dhari yogeshdh...@live.com wrote: Hello Swarnim, Are you saying to put hive-hwi-0.8.1.war into hadoop/lib ? I have put it over there and still the same issue.. Thanks Regards Yogesh Kumar From: kulkarni.swar...@gmail.com Date: Wed, 19 Sep 2012 16:48:37 -0500 Subject: Re: ERROR :regarding Hive WI, hwi service is not running To: user@hive.apache.org It's probably looking for that file on HDFS. Try placing it there under the given location and see if you get the same error. On Wed, Sep 19, 2012 at 4:45 PM, yogesh dhari yogeshdh...@live.com wrote: Hi all, I am trying to run hive wi but its showing FATAL, I have used this command hive --service hwi but it shows.. yogesh@yogesh-Aspire-5738:/opt/hive-0.8.1/lib$ hive --service hwi 12/09/20 03:12:03 INFO hwi.HWIServer: HWI is starting up 12/09/20 03:12:04 FATAL hwi.HWIServer: HWI WAR file not found at /opt/hive-0.8.1/lib/hive-hwi-0.8.1.war although lies there. yogesh@yogesh-Aspire-5738:/opt/hive-0.8.1/lib$ pwd /opt/hive-0.8.1/lib ls -l -rw-rw-r-- 1 root root 55876 Jan 26 2012 hive-common-0.8.1.jar -rw-rw-r-- 1 root root 112440 Jan 26 2012 hive-contrib-0.8.1.jar -rw-rw-r-- 1 root root 112440 Jan 26 2012 hive_contrib.jar -rw-rw-r-- 1 root root 3461228 Jan 26 2012 hive-exec-0.8.1.jar -rw-rw-r-- 1 root root 48829 Jan 26 2012 hive-hbase-handler-0.8.1.jar -rw-rw-r-- 1 root root 23529 Jan 26 2012 hive-hwi-0.8.1.jar -rwxrwxrwx 1 root root 28413 Jan 26 2012 hive-hwi-0.8.1.war -rw-rw-r-- 1 root root 58914 Jan 26 2012 hive-jdbc-0.8.1.jar -rw-rw-r-- 1 root root 1765743 Jan 26 2012 hive-metastore-0.8.1.jar -rw-rw-r-- 1 root root 14081 Jan 26 2012 hive-pdk-0.8.1.jar -rw-rw-r-- 1 root root 509488 Jan 26 2012 hive-serde-0.8.1.jar -rw-rw-r-- 1 root root 174445 Jan 26 2012 hive-service-0.8.1.jar -rw-rw-r-- 1 root root 110154 Jan 26 2012 hive-shims-0.8.1.jar -rw-rw-r-- 1 root root 15260 Jan 24 2012 javaewah-0.3.jar -rw-rw-r-- 1 root root 198552 Dec 24 2009 jdo2-api-2.3-ec.jar Please suggest regarding Thanks regards Yogesh Kumar -- Swarnim -- Swarnim
Re: ERROR :regarding Hive WI, hwi service is not running
Check your configuration (and the default value) and change it. I know there was issues about the check and/or the error message for previous versions of hive. I had the same issue but can't remember the exact details (maybe it was due to relative path vs absolute). Try 1) rename the war 2) put the absolute path in your conf 3) run it Regards Bertrand On Thu, Sep 20, 2012 at 12:02 AM, yogesh dhari yogeshdh...@live.com wrote: Swarnim, opt/hive-0.8.1/lib already exists, its the path of hive dir *hive-hwi-0.8.1.war *already exists there. */opt/hive-0.8.1/lib* ls -l -rw-rw-r-- 1 root root 55876 Jan 26 2012 hive-common-0.8.1.jar -rw-rw-r-- 1 root root 112440 Jan 26 2012 hive-contrib-0.8.1.jar -rw-rw-r-- 1 root root 112440 Jan 26 2012 hive_contrib.jar -rw-rw-r-- 1 root root 3461228 Jan 26 2012 hive-exec-0.8.1.jar -rw-rw-r-- 1 root root 48829 Jan 26 2012 hive-hbase-handler-0.8.1.jar -rw-rw-r-- 1 root root 23529 Jan 26 2012 hive-hwi-0.8.1.jar *-rwxrwxrwx 1 root root 28413 Jan 26 2012 hive-hwi-0.8.1.war* -rw-rw-r-- 1 root root 58914 Jan 26 2012 hive-jdbc-0.8.1.jar -rw-rw-r-- 1 root root 1765743 Jan 26 2012 hive-metastore-0.8.1.jar Thats what its very surprising :-( Thanks Regards Yogesh Kumar -- From: kulkarni.swar...@gmail.com Date: Wed, 19 Sep 2012 16:58:01 -0500 Subject: Re: ERROR :regarding Hive WI, hwi service is not running To: user@hive.apache.org No. I meant create */opt/hive-0.8.1/lib/ *in HDFS and place the *hive-hwi-0.8.1.war *there. On Wed, Sep 19, 2012 at 4:55 PM, yogesh dhari yogeshdh...@live.comwrote: Hello Swarnim, Are you saying to put *hive-hwi-0.8.1.war *into hadoop/lib ? I have put it over there and still the same issue.. Thanks Regards Yogesh Kumar -- From: kulkarni.swar...@gmail.com Date: Wed, 19 Sep 2012 16:48:37 -0500 Subject: Re: ERROR :regarding Hive WI, hwi service is not running To: user@hive.apache.org It's probably looking for that file on HDFS. Try placing it there under the given location and see if you get the same error. On Wed, Sep 19, 2012 at 4:45 PM, yogesh dhari yogeshdh...@live.comwrote: Hi all, I am trying to run hive wi but its showing FATAL, I have used this command * hive --service hwi * but it shows.. yogesh@yogesh-Aspire-5738:/opt/hive-0.8.1/lib$ hive --service hwi *12/09/20 03:12:03 INFO hwi.HWIServer: HWI is starting up 12/09/20 03:12:04 FATAL hwi.HWIServer: HWI WAR file not found at /opt/hive-0.8.1/lib/hive-hwi-0.8.1.war * although lies there. yogesh@yogesh-Aspire-5738:/opt/hive-0.8.1/lib$ pwd */opt/hive-0.8.1/lib* ls -l -rw-rw-r-- 1 root root 55876 Jan 26 2012 hive-common-0.8.1.jar -rw-rw-r-- 1 root root 112440 Jan 26 2012 hive-contrib-0.8.1.jar -rw-rw-r-- 1 root root 112440 Jan 26 2012 hive_contrib.jar -rw-rw-r-- 1 root root 3461228 Jan 26 2012 hive-exec-0.8.1.jar -rw-rw-r-- 1 root root 48829 Jan 26 2012 hive-hbase-handler-0.8.1.jar -rw-rw-r-- 1 root root 23529 Jan 26 2012 hive-hwi-0.8.1.jar *-rwxrwxrwx 1 root root 28413 Jan 26 2012 hive-hwi-0.8.1.war* -rw-rw-r-- 1 root root 58914 Jan 26 2012 hive-jdbc-0.8.1.jar -rw-rw-r-- 1 root root 1765743 Jan 26 2012 hive-metastore-0.8.1.jar -rw-rw-r-- 1 root root 14081 Jan 26 2012 hive-pdk-0.8.1.jar -rw-rw-r-- 1 root root 509488 Jan 26 2012 hive-serde-0.8.1.jar -rw-rw-r-- 1 root root 174445 Jan 26 2012 hive-service-0.8.1.jar -rw-rw-r-- 1 root root 110154 Jan 26 2012 hive-shims-0.8.1.jar -rw-rw-r-- 1 root root 15260 Jan 24 2012 javaewah-0.3.jar -rw-rw-r-- 1 root root 198552 Dec 24 2009 jdo2-api-2.3-ec.jar Please suggest regarding Thanks regards Yogesh Kumar -- Swarnim -- Swarnim -- Bertrand Dechoux