Unable to Move Data location in Vertica

afsalmcqueenafsalmcqueen Community Edition User

Hii, I'm unable to move anything from my current location to /home/dbadmin/vertica/SSD/.

Tried :

CREATE LOCATION '/home/dbadmin/vertica/SSD/' ALL NODES USAGE 'DATA';

 SELECT SET_OBJECT_STORAGE_POLICY('public', '/datadrive/vertica/SSD/', 'true');

got error :

SQL Error [5662] [55000]: [Vertica][VJDBC](5662) ERROR: Storage tier /datadrive/vertica/SSD/ has not been found on all nodes

then tried :

GRANT ALL ON LOCATION '/home/dbadmin/vertica/SSD' TO dbadmin;

and got error :

SQL Error [5365] [42704]: [Vertica][VJDBC](5365) ROLLBACK: User available location ["/home/dbadmin/vertica/SSD"] does not exist on node ["v_vertica_reg_node0001"]

Any Help would be grateful!

Tagged:

Answers

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file