Hi, I'm getting the following error when querying Avro files:
Error: VALIDATION ERROR: From line 1, column 48 to line 1, column 57: Column 'some_col' not found in any table It's true that the field is in none of the tables I'm targeting, in that particular query, but that does not mean that it is in none of the possible files I could be querying. We use Avro to get the benefits of the schema but I never expected Drill to enforce it this way. Why do unresolved columns not return null? This makes no sense to me as I think a fundamental trade of Drill, when trying to eliminate ETL, is to return null for any missing fields. Please advise. Regards, -Stefán
