HiveServer2 migrates to Router

Last updated: 2020-05-26 10:20:08

    How do I migrate HiveServer2 to a router node?

    1. Log in to the EMR Console and select Cloud Hardware Management on the left sidebar. Click Add Router Node to enter the router node adding page and choose to install the Hive 2.1.1 component.
    2. Log in to the router node and modify the configuration file hive-site.xml.
    3. Disable the Hive service on the master node.
      On the Hive role management page in component management, suspend all Hive processes on the master node and restart Hive processes on the router node.
    4. Conduct a test.
      On the router node, check whether HiveServer2 can be properly connected to and existing tables can be queried; and if yes, the migration is successful.
    5. Modify the Hue configuration file to route requests to the Hive component on the router node.
      vim /usr/local/service/knox/conf/topologies/emr.xml   Modify `HIVE` and `HIVEUI`.
      <service>
       <role>HIVE</role>
       <url>http://Router-ip:7003</url>
       <param>
           <name>replayBufferSize</name>
           <value>8</value>
       </param>
      </service>
      <service>
       <role>HIVEUI</role>
       <url>http://Router-ip:7003</url>
      </service>
      Run the following command to restart Knox.
      su hadoop 
      /usr/local/service/knox/bin/gateway.sh stop ; /usr/local/service/knox/bin/gateway.sh start

    Was this page helpful?

    Was this page helpful?

    • Not at all
    • Not very helpful
    • Somewhat helpful
    • Very helpful
    • Extremely helpful
    Send Feedback
    Help