I have installed Hortonworks Hadoop via Ambari and have hive working on both a single VM in pseudo-distributed mode and on a 5-node cluster.
I would like to try out the Hive web interface. When I try to start it I get an error:
$ hive –service hwi
13/06/21 09:14:23 INFO hwi.HWIServer: HWI is starting up
13/06/21 09:14:29 WARN conf.HiveConf: DEPRECATED: Configuration property hive.metastore.local no longer has any effect. Make sure to provide a valid value for hive.metastore.uris if you are connecting to a remote metastore.
13/06/21 09:14:29 FATAL hwi.HWIServer: HWI WAR file not found at /usr/lib/hive/usr/lib/hive/lib/hive-hwi-0.11.0.1.3.0.0-107.war
The hive-hwi war file is present at /usr/lib/hive/lib/hive-hwi-0.11.0.1.3.0.0-107.war, but for some reason it is adding the extra ‘/usr/lib/hive’ prefix to the path. How do I correct this?
Second question – the Apache Hive instructions (https://cwiki.apache.org/confluence/display/Hive/HiveWebInterface) say that Hive web interface requires Ant to be installed. Is this also true of the Hortonworks distribution? When I set it up it didn’t make any difference and got the same error as above.