遇到了查询doris es外表 需要保证某个字段不为空的情况,经过多次实验,查询方法如下
select *
from table
where field1 = '' and field2 = ''
and esquery(`field3`,'{
"wildcard": {
"field3": {
"value": "*"
}
}
}')
遇到了查询doris es外表 需要保证某个字段不为空的情况,经过多次实验,查询方法如下
select *
from table
where field1 = '' and field2 = ''
and esquery(`field3`,'{
"wildcard": {
"field3": {
"value": "*"
}
}
}')