Have you set the "Page types" property on the Hierarchical viewer webpart?
Same applies for CMSRepeater - you need to set the "Page types" property to, let's say, "CMS.MenuItem". Otherwise, the MenuItemGroup
column would not be part of the query, and you will get a "invalid column name" exception.