The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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!



Leave a Comment

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