Hi, When searching multiple directories, drill only searches fields that are common to all files (see the json data model). Is there a way to query a directory and list all files that contain a certain field?
In other words, I would like to use the workaround in this way: select * from (select fqn from dfs.`/bla/*/*` where foo exists) where foo = 'bar' Or is there another way to do this? I dynamically get more files, so finding the files should be included in the query. An alternative would be to execute the query such that it sets the field 'foo' to null for all files that don't contain it. However, I don't know how to execute this. Thanks, Sebastian