###
POST {{baseUrl}}/_plugins/_ppl/_explain
Content-Type: application/x-ndjson

{
    "query": "source=testindex | where timestamp > '2025-05-01 05:40:00'"
}

{
  "calcite": {
    "logical": "LogicalProject(timestamp=[$0])\n  LogicalFilter(condition=[>(TIMESTAMP($0), TIMESTAMP('2025-05-01 05:40:00':VARCHAR))])\n    CalciteLogicalIndexScan(table=[[OpenSearch, testindex]])\n",
    "physical": "EnumerableCalc(expr#0=[{inputs}], expr#1=[TIMESTAMP($t0)], expr#2=['2025-05-01 05:40:00':EXPR_TIMESTAMP VARCHAR], expr#3=[>($t1, $t2)], timestamp=[$t0], $condition=[$t3])\n  CalciteEnumerableIndexScan(table=[[OpenSearch, testindex]], PushDownContext=[[PROJECT->[timestamp]], OpenSearchRequestBuilder(sourceBuilder={\"from\":0,\"timeout\":\"1m\",\"_source\":{\"includes\":[\"timestamp\"],\"excludes\":[]}}, requestedTotalSize=10000, pageSize=null, startFrom=0)])\n"
  }
}

###
PUT {{baseUrl}}/testindex
Content-Type: application/x-ndjson

{
  "mappings": {
    "properties": {
      "timestamp" : {
        "type" : "date",
        "format" : "yyyy-MM-dd HH:mm:ss" 
      }
    }
  }
}

###
POST {{baseUrl}}/testindex/_doc
Content-Type: application/x-ndjson

{
  "timestamp" : "2025-05-01 05:49:00"
}