ES date & aggregations

gistfile1.txt

curl -XPOST "http://localhost:9200/myindex/"

curl -XPOST "http://localhost:9200/myindex/travel/_mapping" -d '
{
    "travel": {
        "properties": {
            "end_date": {
                "format": "dateOptionalTime",
                "type": "date"
            },
            "start_date": {
                "format": "dateOptionalTime",
                "type": "date"
            }
        }
    }
}'

curl -XPOST "http://localhost:9200/myindex/travel/" -d '
{
    "start_date":"2013-09-11T11:50:00.000Z",
    "end_date":"2013-09-11T13:08:00.000Z"
}'

curl -XGET 'http://localhost:9200/myindex/travel/_search?pretty' -d '
{
    "aggs": {
        "duration": {
            "histogram": {
                "interval": 1,
                "script": "(doc['end_date']-doc['start_date'])/3600"
            }
        }
    }
}'

curl -XGET 'http://localhost:9200/myindex/travel/_search?pretty' -d '
{
    "aggs": {
        "duration": {
            "histogram": {
                "interval": 1,
                "script": "(doc['end_date'].value-doc['start_date'].value)/3600"
            }
        }
    }
}
'