Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-13950

Beeline: infinite loop during the connection to as remote hiveserver2

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 2.0.0, 2.0.1
    • None
    • Beeline
    • None
    • Hadoop 2.7.2, Hive 2.0.1, Tez 0.8.3, Kerberos V

    Description

      From a hive client machine, I can use beeline to connect to a remote Hiveserver2. The connection is secured with Kerberos.

      During the connection process, I have an infinite loop when a username is entered. The loop prints "Enter username for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:" and only stops if the user pushes down "enter" on its keyboard.

      [shfs3453@hive-cli01 workspace]$ beeline
      SLF4J: Class path contains multiple SLF4J bindings.
      SLF4J: Found binding in [jar:file:/opt/application/Hive/apache-hive-2.0.1-bin/lib/hive-jdbc-2.0.1-standalone.jar!/org/slf4j/impl/StaticLoggerBinder.class]
      SLF4J: Found binding in [jar:file:/opt/application/Hive/apache-hive-2.0.1-bin/lib/log4j-slf4j-impl-2.4.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
      SLF4J: Found binding in [jar:file:/opt/application/Spark/spark-1.6.1/hive/assembly/spark-assembly-1.4.1-hadoop2.7.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
      SLF4J: Found binding in [jar:file:/opt/application/Hadoop/hadoop-2.7.2/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]
      SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
      SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
      Beeline version 2.0.1 by Apache Hive
      beeline> !connect jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS
      Connecting to jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS
      Enter username for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Enter password for jdbc:hive2://hiveserver2.bigdata.fr:10000/shfs3453;principal=hiveserver2/hiveserver2.bigdata.fr@REALM.KERBEROS:  
      Jun 06 14:46:53 beeline INFO - org.apache.hive.jdbc.UtilsSupplied authorities: hiveserver2.bigdata.fr:10000
      Jun 06 14:46:53 beeline INFO - org.apache.hive.jdbc.UtilsResolved authority: hiveserver2.bigdata.fr:10000
      Connected to: Apache Hive (version 2.0.1)
      Driver: Hive JDBC (version 2.0.1)
      Jun 06 14:46:55 beeline WARN - org.apache.hive.jdbc.HiveConnectionRequest to set autoCommit to false; Hive does not support autoCommit=false.
      Transaction isolation: TRANSACTION_REPEATABLE_READ
      0: jdbc:hive2://hiveserver2.bigdata.fr>
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            BigDataOrange Alexandre Linte
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: