Posts

Showing posts from September, 2013

How to run Hive queries through Hive Web Interface.

Image
One of the good things about Hadoop, and related projects, which I really like is the WebUI provided to us. It makes our life a lot easier. Just point your web browser to the appropriate URL and quickly perform the desired action. Be it browsing through HDFS files or glancing over HBase tables. Otherwise you need to go the shell and issue the associated commands one by one for each action [I know i'm a bit lazy ;)]. Hive is no exception and provides us a WebUI, called as Hive Web Interface , or HWI in short. But, somehow I feel it is less documented and talked about as compared to HDFS and HBase WebUI. But that doesn't make it any less useful. In fact I personally find it quite helpful. With its help you can do various operations like browsing your DB schema , see your sessions , query your tables etc. You can also see the System and User variables like Java Runtime, your OS architecture, your PATH etc etc. OK, enough brand building. Let's get started and see how to