Create a Database in an Alternate HDFS Location
You can create a database in an HDFS location other than II_HDFSDATA by using the ‑v flag on the createdb command. This location becomes the new default HDFS location for this database.
To create a database in a location other than the default
1. Create the location. For example:
CREATE LOCATION vwhdfs WITH AREA = 'hdfs://mydatanode:9000/Actian/vwhdfs', USAGE = DATABASE;
2. Issue a createdb command. For example:
createdb sales_fact -vvwhdfs
In this example, the sales_fact database is created in a new HDFS location for Vector data: vwhdfs. The location was defined previously with the CREATE LOCATION statement.