Thanks Roberto! And ScottP1971!
A few additions to Robertos post for those struggling like I am:
1. Replace on the lines starting as: TBLPROPERTIES the "if3f8-cldramaster-01", with your own masternode address (not IP-address but the other one)!
2. start Hive again and run Robertos code with the above changes
3. Start Hue again and run the "invalidate metadata" and then the query that initially gave an error.