Non-compact gaugings from higher dimensions