framework/resources/Functional/min_max_dir/drill-3474/drill-3474_24.q

select dir0,dir1,filename,fqn,filepath,suffix,cast(columns[3] as varchar(20)) from `drill-3474/*/May` where cast(columns[3] as varchar(20))='democrat';