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

select substr(filename,1,7), `replace`(suffix, 'p', 'P') from `dfs.drillTestDir`.`min_max_dir/2016/Oct` where length(fqn) > 59;