I am not able to connect to beeline-hive. I am get...

Discussion in 'Big Data and Analytics' started by Siva Teja Reddy Kandula, Jan 20, 2017.

  1. Siva Teja Reddy Kandula

    Joined:
    Dec 22, 2016
    Messages:
    1
    Likes Received:
    0
    I am not able to connect to beeline-hive. I am getting the below error:
    Connecting to jdbc:hive2://localhost:10000
    Error: Could not open client transport with JDBC Uri: jdbc:hive2://localhost:10000: java.net.ConnectException: Connection refused (state=08S01,code=0)
    Beeline version 1.2.1000.2.4.0.0-169 by Apache Hive
    0: jdbc:hive2://localhost:10000 (closed)>
     
    #1
  2. Megha_42

    Megha_42 Well-Known Member
    Simplilearn Support

    Joined:
    Dec 15, 2016
    Messages:
    206
    Likes Received:
    9
    Hi Siva,

    Thanks for reaching out.


    Check if the Hive Server 2 is running: 'sudo service hive-server2 status'.
    If it's not restart it with 'sudo service hive-server2 restart'. If you continue having issues, have a log at Hive Server 2 logs in /var/log/hive for any errors.
    Check the hiveserver2.log, the issue could be related to queuename if you've setup a yarn scheduler. The fix is, to set a queuename for hive and add 'hive' to submit application to that queuename.

    Hope this resolution helps.

    Thanks and Regards
    Megha
     
    #2
  3. Adekunle Umar

    Adekunle Umar New Member
    Alumni

    Joined:
    Mar 7, 2017
    Messages:
    1
    Likes Received:
    0
    <code>
    $ beeline -u jdbc:hive2://localhost:10000
    WARNING: Use "yarn jar" to launch YARN applications.Connecting to jdbc:hive2://localhost:10000Error: Could not open client transport with JDBC Uri: jdbc:hive2://localhost:10000: java.net.ConnectException: Connection refused (state=08S01,code=0)Beeline version 1.2.1000.2.4.0.0-169 by Apache Hive0: jdbc:hive2://localhost:10000 (closed)>
    </code>

    As seen above , I'm also receiving a similar Connection refused error.

    I've tried both commands as suggested above to Siva:

    sudo service hive-server2 status
    sudo service hive-server2 restart

    I get this message, <<my username>> is not in the sudoers file. This incident will be reported. Please how do I find a way around this to use Hive?

    Kindly assist. Thanks.
     
    #3

Share This Page