The dbadmin user must have full privileges on the directory in order to create the location.
Syntax:
CREATE LOCATION 'path'
{NODE 'nodename' | ALL NODES}
[SHARED]
[USAGE 'usetype']
[LABEL 'labelname']
[root@DCXLG001 u03]# mkdir data_store1
[root@DCXLG001 u03]# chown -R dbadmin:vertica /u03/data_store1/
chown: invalid group: dbadmin:vertica'
[root@DCXLG001 u03]# chown -R dbadmin:verticadba /u03/data_store1/
dbadmin= CREATE LOCATION '/u03/data_store1/'
ALL NODES
USAGE 'DATA'
LABEL 'DataCollector';
CREATE LOCATION
dbadmin= select * from storage_locations;
location_id | node_name | location_path | location_usage | is_retired | location_label | rank | throughput | latency
-------------------+--------------+-----------------------------------+----------------+------------+----------------+------+------------+---------
45035996273704982 | v_d_node0001 | /home/dbadmin/d/v_d_node0001_data | DATA,TEMP | f | | 0 | 0 | 0
45035996273757994 | v_d_node0001 | /u03/data_store1 | DATA | f | DataCollector | 0 | 0 | 0
[root@DCXLG001 /]# cat /proc/meminfo | grep MemTotal | awk '{ print $2 }'
8190956
dbadmin= SELECT MEASURE_LOCATION_PERFORMANCE('/u03/data_store1','v_d_node0001');
WARNING 3914: measure_location_performance can take a long time to execute. Please check logs for progress
MEASURE_LOCATION_PERFORMANCE
-------------------------------------------------
Throughput : 71 MB/sec. Latency : 818 seeks/sec
[dbadmin@DCXLG001 ~]$ /opt/vertica/bin/vertica -m /u03/data_store1
Path:/u03/data_store1 Throughput:71 (MiB/sec) Latency:799 (seeks/sec)
dbadmin= select SET_LOCATION_PERFORMANCE ( '/u03/data_store1' , 'v_d_node0001' , '71' , '818' );
SET_LOCATION_PERFORMANCE
-------------------------------------------------
/u03/data_store1 performance statistics stored.
(1 row)
dbadmin= select * from storage_locations;
location_id | node_name | location_path | location_usage | is_retired | location_label | rank | throughput | latency
-------------------+--------------+-----------------------------------+----------------+------------+----------------+------+------------+---------
45035996273704982 | v_d_node0001 | /home/dbadmin/d/v_d_node0001_data | DATA,TEMP | f | | 1 | 0 | 0
45035996273757994 | v_d_node0001 | /u03/data_store1 | DATA | f | DataCollector | 0 | 71 | 818
(2 rows)