Elasticsearch Behavioral Example Queries

queries.txt

#### SETUP INDEX
PUT /actions

#### SETUP MAPPINGS

PUT /actions/_mapping/view
# view
{
"view":{
      "properties":{
      	"customer_id":    { "type": "integer"  }, 
        "product_id":     { "type": "integer"  },  
        "customer_name":     { "type": "string","index": "not_analyzed"   },
        "customer_email":     { "type": "string"  },
        "product_name":     { "type": "string","index": "not_analyzed"  }, 
        "paid":           { "type": "float"  },
        "timestamp":      { "type": "date" } 
      }
}}

PUT /actions/_mapping/purchase
# purchase
{
"purchase":
   {
      "properties":{
        "customer_id":    { "type": "integer"  }, 
        "product_id":     { "type": "integer"  },  
        "customer_name":     { "type": "string","index": "not_analyzed"   },
        "customer_email":     { "type": "string"  },
        "product_name":     { "type": "string","index": "not_analyzed"  }, 
        "paid":           { "type": "float"  },
        "timestamp":      { "type": "date" } 
      }
   }
}


#determine amounts paid by customers and order by most frequent amount paid

POST /actions/_search
#customer id by most active
{
"size":0,
   "aggregations": {
      "most_active_customers": {
         "terms": {
            "field": "customer_name"
            
         }
      }
   }
}