@[TOC](論催收系統的架構的設計擴充套件和部署)
>Survive by day and develop by night.
>talk is cheap, show me the code,make a better result.
# 目錄
 Hive客戶端工具後續將使用Beeline 替代HiveCLI ，並且後續版本也會廢棄掉HiveCLI 客戶端工具,Beeline是 Hive 0.11版本引入的新命令列客戶端工具,它是基於SQLLine CLI的JDBC客戶端。

## 概述
瞭解一下beenline
### 需求：
beanline 客戶端工具如何連線呢？
## 設計思路
使用beanline 客戶端工具

## 實現思路分析
### 1.1. 不配置使用者名稱密碼
<property>
    <name>hive.server2.authentication</name>
    <value>NONE</value>
    <description>
      Expects one of [nosasl, none, ldap, kerberos, pam, custom].
      Client authentication types.
        NONE: no authentication check
        LDAP: LDAP/AD based authentication
        KERBEROS: Kerberos/GSSAPI authentication
        CUSTOM: Custom authentication provider
                (Use with property hive.server2.custom.authentication.class)
        PAM: Pluggable authentication module
        NOSASL:  Raw transport
    </description>
</property>

lenmom@Mi1701 ~$ beeline
Beeline version 1.2.1.spark2 by Apache Hive
beeline> !connect jdbc:hive2://localhost:10000/default
Connecting to jdbc:hive2://localhost:10000/default
Enter username for jdbc:hive2://localhost:10000/default:
Enter password for jdbc:hive2://localhost:10000/default:
。。。。
Connected to: Apache Hive (version 2.3.4)
Driver: Hive JDBC (version 1.2.1.spark2)
Transaction isolation: TRANSACTION_REPEATABLE_READ
0: jdbc:hive2://localhost:10014/default> show databases;
+----------------+--+
| database_name  |
+----------------+--+
| default        |
| orc          |
+----------------+--+

### 2.2. 使用者名稱密碼登入

<property>
 <name>hive.jdbc_passwd.auth.muzili</name>
 <value>muzili</value>
</property>

beeline> !connect jdbc:hive2://localhost:10000/default
Connecting to jdbc:hive2://localhost:10000/default
Enter username for jdbc:hive2://localhost:10000/default: muzili
Enter password for jdbc:hive2://cdh-server2:10000/default: ******
Connected to: Apache Hive (version 2.3.4)
Driver: Hive JDBC (version 2.3.4)
Transaction isolation: TRANSACTION_REPEATABLE_READ

### 3.3. beeline連線hiveserver2使用使用者名稱密碼(帶引數直接輸入賬號和密碼)
beeline -u "jdbc:hive2://localhost:10000"  -n muzili -p  muzili
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=512M; support was removed in 8.0
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=512M; support was removed in 8.0
scan complete in 2ms
Connecting to jdbc:hive2://localhost:10000
Connected to: Apache Hive (version 2.3.4)
Driver: Hive JDBC (version 2.3.4)
Transaction isolation: TRANSACTION_REPEATABLE_READ
Beeline version 2.3.4 by Apache Hive
0: jdbc:hive2://localhost:10000>

## 擴充實現
這裡參考：github:簡單實現上述流程：
入門級實現:
:   [部分原始碼實現](無).
:  原始碼實現

## 效能引數測試：
無

# 參考資料和推薦閱讀
1.  [beebline 命令使用](https://blog.csdn.net/qq_56870570/article/details/120077588?utm_medium=distribute.pc_relevant.none-task-blog-2~default~baidujs_baidulandingword~default-0-120077588-blog-110088179.pc_relevant_blogantidownloadv1&spm=1001.2101.3001.4242.1&utm_relevant_index=3).
2.  [主流爬蟲框架的基本介紹](https://www.cnblogs.com/StarZhai/p/14106770.html).
3.   [高擴充性的Java多執行緒爬蟲框架reptile](https://www.jianshu.com/p/cacf986a9ea2).

>歡迎閱讀，各位老鐵，如果對你有幫助，點個贊加個關注唄！~

beenline 詳解

相關文章