i have a table tb(b Object(json)). and i will insert dynamic json into a. such a {“c”: 0}, {“d”: 1}, so i want to query: select payload.d from tb. i got:
| payload.d |
|---|
| 0 |
| 1 |
i just dont want to get the result where key d does not exists, but clickhouse still return the 0 for me, how can i filter the rows?
i want to return the records that the key d truely exists
| payload.d |
|---|
| 1 |