A shortcut or alias to the SpiderOak Hive folder will appear automatically on your desktop. Where the folder itself is located depends on your computer's operating system:
In Windows Explorer: Documents folder (C:\\Users\USERNAME\Documents\SpiderOak Hive)
In Mac Finder: /Users/USERNAME/SpiderOak Hive/
In Linux: ~/SpiderOak Hive.
To keep things simple, Hive cannot be moved or renamed. Instead of moving or renaming Hive, use Sync, which can make any folder on your computer work like Hive and can be given any name.