4. SQL Statements : CREATE LOCATION : CREATE LOCATION Examples
 
Share this page                  
CREATE LOCATION Examples
1. Create a location using a Linux path:
CREATE LOCATION extraloc WITH AREA = '/usr/vw_extra',
USAGE = (WORK);
2. Create a location on HDFS:
CREATE LOCATION vhl01 WITH AREA = 'hdfs://namenode:54310/vectorwise/vhl01', USAGE = (DATABASE);