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
Hii, I'm unable to move anything from my current location to /home/dbadmin/vertica/SSD/.
CREATE LOCATION '/home/dbadmin/vertica/SSD/' ALL NODES USAGE 'DATA'; SELECT SET_OBJECT_STORAGE_POLICY('public', '/datadrive/vertica/SSD/', 'true');
got error :
SQL Error  : [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  : [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!