Vertica 7.2 - How to identify file associated with a Projection
I am using VM Ware image Vertica 7.2, I am trying to find out the file for a speicific projection. I used the approach of using following meta data table mentioned in the link http://vertica-forums.com/viewtopic.php?t=106
select storage_type, storage_oid from v_monitor.storage_containers where projection_name = 'test1_node0001';
This logic does not look like valid any more after Vertica 7.X version. Can you please share the correct logic for Vertica 7.2 , I am seeing .gt file instead of fdb or ipdx files. Can some one explain the logic of gt file also.