엘라스틱 서치 데이터 적재 및 웹 연동

실습순서

캐글에서 CSV 수집
키바나에서 수집 데이터 적재
Rest API 웹 연동(AJAX)

캐글에서 CSV 수집

Kaggle: Your Machine Learning and Data Science Community

Titanic Dataset 수집

키바나에서 데이터 적재

Home > Get started by adding integrations > Uplaod a file
Home > Anaytics > Machine Learning > Data Visualizer > Import data

Discover에서 확인

KQL : Age > 30

Dev Tools

GET titanic_dataset/_search
{
  "query": {
    "range": {
      "Age": {
        "gt": 30
      }
    }
  }
}

AJAX

<!DOCTYPE html>
<html lang="ko">
<head>
    <meta charset="UTF-8">
    <title>ajax-jquery.html</title>
    <script src="<https://code.jquery.com/jquery-3.6.0.min.js>" integrity="sha256-/xUj+3OJU5yExlq6GSYGSHk7tPXikynS7ogEvDej/m4=" crossorigin="anonymous"></script>
    <script>
    const getJson = function (type) {
        const match = {
            "query": {
                "match": {
                "category": "clothing"
                }
            },
            size: 20
        }

        const range = {
            "query": {
                "range": {
                    "day_of_week_i": {
                    "gte": 1
                    }
                }
            },
            size: 20
        }
        const must = {
            "_source": ["day_of_week","customer_full_name"], 
            "query": {
                "bool": {
                "must":[
                    {
                    "term": {
                    "day_of_week": "Sunday"
                    }
                    },
                    {
                    "match": {
                    "customer_full_name": "mary"
                    }
                    }
                ]
                }
            },
            size: 20
        }

        const sel = [match,range,must];

        const url = '<http://localhost:9200/titanic_dataset/_search>'
        const urlt = '<http://localhost:9200/kibana_sample_data_ecommerce/_search>'
        
        $.ajax({
            type:'POST',
            contentType: "application/json",
            url:urlt,
            dataType:'json',
            data:JSON.stringify(sel[type]),
            success: function (data) {
                console.log(data);
                $('#area').text(data);
            },
            error: function (request, status, error) {
                console.log(request, status,error);
            }
        });
    }  
   
    </script>
</head>
<body>
    <p id="area"></p>
    <button id="match" onclick="getJson(0)">match</button>
    <button id="range" onclick="getJson(1)">range</button>
    <button id="must" onclick="getJson(2)">must</button>

    
</body>
</html>