Drill Community, Thanks for the quick response to my last question. I am exploring the tool and will definitely use it, especially the json capabilities with the flatten function. I noticed that Flatten will error on nested maps. I would like to exclude these maps to build tables from them later by excluding them since I do not know every key in the Json mapping. Is there a way to select * keys from a json object except the keys that are maps?
The problem is that I would need to read through millions of records tens to hundreds of times per day to achieve productivity with this method. I really want to avoid anything manual. I am looking for something like: SELECT flatten(filter_not(record[column],array['col1','col2'])) FROM table All help is greatly appreciated. Thanks, Andrew Evans
