doris on es 如何查询不为空/不为空字符串

遇到了查询doris es外表 需要保证某个字段不为空的情况，经过多次实验，查询方法如下

select *
from table
where field1 = '' and field2 = ''
  and esquery(`field3`,'{
    "wildcard": {
      "field3": {
        "value": "*"
      }
    }
}')
order by xxx