starrocks创建es外部表，登录starrocks数据库，通过日期字段查询报错：
ERROR 1064 (HY000): Failed to connect to ES server, errmsg is: The requested URL returned error: 400
sql语句：select * from match_orders_es where create_time >= “2022-06-28 12:08:15” limit 10;
es连接正常，通过其它字段是可以查询的，可以排除es连接问题。
es里的create_time字段类型是date，format为：“yyyy-MM-dd’T’HH:mm:ss.SSS||yyyy-MM-dd’T’HH:mm:ss.SSSXXX||yyyy-MM-dd’T’HH:mm:ssXXX”
starrocks库中的create_time字段类型是datetime。
可以辛苦测试下es里面 format 为 yyyy-MM-dd HH:mm:ss 这个的类型么？猜测是这个问题。
测试了下，还是不行，还是报同样的错误
以下是be.info.log 中的日志：
I0705 18:28:49.638813 7294 plan_fragment_executor.cpp:69] Prepare(): query_id=4247dd78-fc4d-11ec-8784-5254c0a80d6b fragment_instance_id=4247dd78-fc4d-11ec-8784-5254c0a80d6c backend_num=1
I0705 18:28:49.639237 7164 plan_fragment_executor.cpp:183] Open(): fragment_instance_id=4247dd78-fc4d-11ec-8784-5254c0a80d6c
I0705 18:28:49.639564 7164 es_scroll_query.cpp:137] Generated ES queryDSL [ {“query”:{“bool”:{“filter”:[{“bool”:{“should”:[{“range”:{“create_time”:{“gte”:“1640786079000”}}}]}}]}},“stored_fields”:“none”,“docvalue_fields”:[“id”,“user_id”,“broker_id”,“pair_code”,“order_id”,“oppo_order_id”,“mr_id”,“clazz”,“system_type”,“side”,“deal_side”,“entrust_price”,“filled_amount”,“price”,“unfilled_amount”,“deal_status”,“order_status”,“bill_status”,“ext”,“create_time”,“update_time”],“sort”:["_doc"],“size”:4096} ]
I0705 18:28:49.639739 15387 es_scan_reader.cpp:105] First scroll request URL: 192.168.13.108:9200/exchange_match_orders_new/_doc/_search?scroll=5m&preference=_shards:0&filter_path=_scroll_id,hits.total,hits.hits._score,hits.hits.fields&terminate_after=4096
W0705 18:28:49.643702 15387 http_client.cpp:169] fail to execute HTTP client, errmsg=The requested URL returned error: 400
W0705 18:28:49.643805 15387 es_scan_reader.cpp:162] Parsing json error, json is:
W0705 18:28:49.643887 7164 plan_fragment_executor.cpp:188] Fail to open fragment, instance_id=4247dd78-fc4d-11ec-8784-5254c0a80d6c, status=Internal error: Failed to connect to ES server, errmsg is: The requested URL returned error: 400
Index是怎么建的，发一下
“create_time”:{
“type”:“date”,
“format”: "yyyy-MM-dd HH:mm:ss
},
{“query”:{“bool”:{“filter”:[{“bool”:{“should”:[{“range”:{“create_time”:{“gte”:“1640786079000”}}}]}}]}},“stored_fields”:“ none ”,“docvalue_fields”:[“id”,“user_id”,“broker_id”,“pair_code”,“order_id”,“oppo_order_id”,“mr_id”,“clazz”,“system_type”,“side”,“deal_side”,“entrust_price”,“filled_amount”,“price”,“unfilled_amount”,“deal_status”,“order_status”,“bill_status”,“ext”,“create_time”,“update_time”],“sort”:["_doc"],“size”:4096}
用这个请求一下ES，返回什么