Got to know from the dev team that they have modified the column definition. We ran the MSCK repair table and we are able to run the select distinct query.  Vertex errors may not relate to memory issues. Hope this helps the community.  ... View more