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.id.str=ccampbell -Dhadoop.root.logger=INFO,console -Djava.library.path=;e:\hdp\hadoop-\bin -Dhadoop.policy.file=hadoop-policy.xml -Djava.net.preferIPv4Stack=true -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

to create new topics or reply. | New User Registration

  • 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.

You must be to reply to this topic. | Create Account

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.