1.elasticsearch-sql在線安裝

$./bin/elasticsearch-plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/6.2.3.0/elasticsearch-sql-6.2.3.0.zip

2.elasticsearch-sql離線安裝

$./elasticsearch-plugin install file:/home/bdp/shangeshishi/elasticsearch-6.5.4/elasticsearch-sql-6.5.4.0.zip 

3.elasticsearch-sql的postMan請求

請求地址
http://10.45.47.66:9200/_sql
請求頭
Content-Type:application/json
Authorization:Basic ZWxhc3RpYzpiZHAxMjM=
請求參數(shù)
{
  "sql":"desc label_user_info_base_es_20190729"
}
請求效果

低于6.5版本的查詢方式略有不同，查詢方式為:
http://10.45.47.66:9200/_sql?sql=select * from label_user_info_base_es_20190729

附Base64加密獲取代碼示例:
String authString = userName + ":" + password;
byte[] authEncBytes = Base64.encodeBase64(authString.getBytes("utf-8"));
String authStringEnc =new String(authEncBytes);

相關(guān)pom依賴 <dependency>     <groupId>commons-codec</groupId>     <artifactId>commons-codec</artifactId>     <version>1.14</version> </dependency>