The Hortonworks Community Connection is now live. A completely rebuilt Q&A forum, Knowledge Base, Code Hub and more, backed by the experts in the industry.

You will be redirected here in 10 seconds. If your are not redirected, click here to visit the new site.

The legacy Hortonworks Forum is now closed. You can view a read-only version of the former site by clicking here. The site will be taken offline on January 31,2016

HDP on Windows – Installation Forum

Issues with Hive and Connecting with Putty after installation

  • #56131

    I have my cluster running on Windows Server 2012 Datacenter in Azure IaaS.

    As far as I can tell, everything is passing the smoke tests including Hive.

    I have two issues…

    1. I can’t connect with Putty. I get “Network Error Connection Refused”. Can you offer any assistance in getting this working?

    2. The HWI service is failing to start. It is attempting to restart every few seconds and ends. Is it possible that the Hive smoke test is passing even without the HWI service running? I gather that HWI is just the web interface for Hive.

    The service is ending with the log information below if it helps. Any help would be greatly appreciated.

    HadoopServiceTraceSource Information: 0 : Tracing successfully initialized
    HadoopServiceTraceSource Information: 0 : Loading service xml: e:\hdp\hive-\bin\hwi.xml
    HadoopServiceTraceSource Information: 0 : Successfully parsed service xml for service HWI
    HadoopServiceTraceSource Information: 0 : Command line: C:\Java\jdk1.7.0_60\bin\java -Xmx1000m -Dfile.encoding=UTF-8 -Dhadoop.log.dir=e:\hadoop\logs\hadoop -Dhadoop.log.file=hadoop.log -Dhadoop.home.dir=e:\hdp\hadoop- -Dhadoop.root.logger=INFO,console -Djava.library.path=;e:\hdp\hadoop-\bin -Dhadoop.policy.file=hadoop-policy.xml -classpath e:\hdp\hadoop-\etc\hadoop;e:\hdp\hadoop-\share\hadoop\common\lib\*;e:\hdp\hadoop-\share\hadoop\common\*;e:\hdp\hadoop-\share\hadoop\hdfs;e:\hdp\hadoop-\share\hadoop\hdfs\lib\*;e:\hdp\hadoop-\share\hadoop\hdfs\*;e:\hdp\hadoop-\share\hadoop\yarn\lib\*;e:\hdp\hadoop-\share\hadoop\yarn\*;e:\hdp\hadoop-\share\hadoop\mapreduce\lib\*;e:\hdp\hadoop-\share\hadoop\mapreduce\*;;e:\hdp\hive-\conf;e:\hdp\hive-\lib\*;;e:\hdp\tez-\conf\;e:\hdp\tez-\*;e:\hdp\tez-\lib\*;e:\hdp\tez-\conf\;e:\hdp\tez-\*;e:\hdp\tez-\lib\*; org.apache.hadoop.hive.hwi.HWIServer -hiveconf hive.querylog.location=e:\hadoop\logs\hive\history -hiveconf hive.log.dir=e:\hadoop\logs\hive
    HadoopServiceTraceSource Information: 0 : ServiceHost#OnStart
    HadoopServiceTraceSource Information: 0 : Child process started, PID: 1120
    HadoopServiceTraceSource Information: 0 : Child process exited with exit code: 1

  • Author
  • #56297

    To close this out…

    The issue connecting w/Putty is my naiveté…Use Command Prompt or PowerShell in Windows…d’oh.

    The Pig and Hive execution issues were being caused by firewall issues. I need to dig more into the ports causing the problem but disabling Windows Firewall for the time being has me moving forward.

The forum ‘HDP on Windows – Installation’ is closed to new topics and replies.

Support from the Experts

A HDP Support Subscription connects you experts with deep experience running Apache Hadoop in production, at-scale on the most demanding workloads.

Enterprise Support »

Become HDP Certified

Real world training designed by the core architects of Hadoop. Scenario-based training courses are available in-classroom or online from anywhere in the world

Training »

Hortonworks Data Platform
The Hortonworks Data Platform is a 100% open source distribution of Apache Hadoop that is truly enterprise grade having been built, tested and hardened with enterprise rigor.
Get started with Sandbox
Hortonworks Sandbox is a self-contained virtual machine with Apache Hadoop pre-configured alongside a set of hands-on, step-by-step Hadoop tutorials.
Modern Data Architecture
Tackle the challenges of big data. Hadoop integrates with existing EDW, RDBMS and MPP systems to deliver lower cost, higher capacity infrastructure.