|
|
|
|
|
|
You can invoke the Database Designer from the command line or a shell script.
Syntax
> /opt/vertica/bin/adminTools -t run_designer --file param-file -p password
Semantics
param-file |
is the name of a Database Designer parameters file (default is |
password |
is the database password |
Notes
/opt/vertica/bin to your search path.Example
The following is an example of a design_params.txt file:
DataDirectory: /scratch/examples/Stock_Schema
SampleRate: 1.0
DatabaseClient: /opt/vertica/bin/vsql
DataNullAndDelimeter: |_\n
FactTableRows: 100000000
WorkingDirectory: /scratch/examples/Stock_Schema/
DatabaseName: Stock_Schema
KSafetyLevel: 2
CatalogDirectory: /home/dbadmin//Stock_Schema/stock_schema_node1_host01_catalog
DataFileExt: .tbl
QueriesFile: /scratch/examples/Stock_Schema/stock_queries.sql
Port: 5433
TempSchemaFile: catalog_dump.sql
OptimizationStages: 1
Task: MakeSafe