获取elasticsearch的元数据

关注

原创最新推荐文章于 2026-07-22 11:19:06 发布 1.2k 阅读 AI 写同款· GEO 优化 ›

【ES】Elasticsearch 元数据 前几天写了文章介绍了 ES 的核心概念，没看过的可以看下面的文章。【ES】Elasticsearch 核心概念对应元数据，文中一笔带过了，没有说清楚。今天继续讲一下。比如我们查一个数据，如果是采用下面的方法： GET {这里填index}/_search { "query": { "match_all": {} } } 那么会返回 index 下所有数据。如果采用下面的方法： GET {这里填index}/{这里填type}/{这里填id} { "query": { 阅读详情

//采集es元数据
       /*Connection saveConn =null;
       CloseableHttpClient httpclient=null;
           httpclient = HttpClientBuilder.create().build();
           String httpUrl ="http://localhost:9200/_all";
           log.debug("采集ElasticsearchURL :"+httpUrl);
           HttpGet httpget = new HttpGet(httpUrl);
           HttpResponse res = httpclient.execute(httpget);
            String result = EntityUtils.toString(res.getEntity());// 返回json格式：
            log.debug("采集ElasticsearchMapData= :"+result);
            JSONObject esIndexsData = JSON.parseObject(result);
           Iterator<String> indexs = esIndexsData.keySet().iterator();
           while (indexs.hasNext()) {
               String indexName =indexs.next();
               if(esIndexsData.get(indexName) instanceof JSONObject ){
                   JSONObject mappingInfo =esIndexsData.getJSONObject(indexName).getJSONObject("mappings");
                   if (mappingInfo==null){
                       continue;
                   }
                   //提取typeName 遍历字段定义
                   Iterator<String> types=mappingInfo.keySet().iterator();
                   //提取表的后半部分
                   while(types.hasNext()){
                       String subfix =types.next();
                       String TABLE_NAME =indexName+"-"+ subfix;
                       String TABLE_TYPE ="TABLE";
                       String OWNER = indexName;
                       String CREATE_DATE ="2019-03-06 00:00:00";
                       String DESCRIPTION="";
                       //解析字段信息
                       JSONObject fieldsPro=mappingInfo.getJSONObject(subfix).getJSONObject("properties");
                       //解析_meta信息
                       JSONObject metaInfo =mappingInfo.getJSONObject(subfix).getJSONObject("_meta");
                       if(fieldsPro==null){
                           continue;
                       }
                       Iterator<String> fieldKeys =fieldsPro.keySet().iterator();
                       int position=0;
                       while(fieldKeys.hasNext()){
                           position++;
                           String COLUMN_NAME = fieldKeys.next();
                           JSONObject fieldInfo =fieldsPro.getJSONObject(COLUMN_NAME);
                           String ORDINAL_POSITION = position+"";
                           String COLUMN_DEFAULT ="";
                           String IS_NULLABLE = "";
                           String isIndex="Y";
                           if("false".equalsIgnoreCase(fieldInfo.getString("index"))){
                               isIndex="N";
                           }
                           String DATA_TYPE = fieldInfo.getString("type")==null?"":fieldInfo.getString("type");
                           //从fields对象取字段长度
                           String CHARACTER_MAXIMUM_LENGTH = "";
                           JSONObject fields =fieldInfo.getJSONObject("fields");
                           if(fields!=null && fields.getJSONObject("keyword")!=null){
                               if(fields.getJSONObject("keyword").getString("ignore_above")!=null){
                                   CHARACTER_MAXIMUM_LENGTH=fields.getJSONObject("keyword").getString("ignore_above");
                               }
                           }
                           String NUMERIC_PRECISION = "";
                           String NUMERIC_SCALE = "";
                           String fieldDesc = "";
                           String metaData="";
                           JSONObject fileMeta=null;
                           if(metaInfo!=null){
                               fileMeta= metaInfo.getJSONObject(COLUMN_NAME);
                           }
                           fieldDesc =fileMeta!=null ?fileMeta.getString("字段名"):"";
                           metaData =fileMeta!=null ?fileMeta.getString("备注"):"";
                           // 处理type='nested'字段信息
                       }
                   }
               }
            }*/