Connecting to Vertica
Prerequisites
- The Vertica instance is accessible over the network from the PuppyGraph instance.
Configuration
| Configuration | Explanation |
|---|---|
| Username | The username of the database |
| Password | The password of the database |
| JDBC Connection String | A JDBC compatible connection URI of the data source. Read this page for more details on how to construct the URI. |
| Driver Class | The class name of the JDBC Driver. The default value is |
Data Type Mapping
| Vertica Type | PuppyGraph Type | Description |
|---|---|---|
BOOLEAN |
Boolean |
True or false |
INTEGER, INT, BIGINT, SMALLINT, TINYINT, INT8 |
Long |
64-bit signed integer |
FLOAT, DOUBLE PRECISION, REAL |
Double |
64-bit IEEE 754 floating point |
DECIMAL(P, S), NUMERIC(P, S), NUMBER(P, S), MONEY |
Decimal(P, S) |
Fixed-point decimal; precision P, scale S |
CHAR, VARCHAR |
String |
Character strings |
BINARY, VARBINARY, LONG VARBINARY |
Binary |
Byte sequence |
GEOMETRY, GEOGRAPHY |
Binary |
Spatial value in Vertica's internal binary format |
DATE |
Date |
Calendar date without time or timezone |
TIMESTAMP, TIMESTAMPTZ |
DateTime |
Date and time |
- A
NUMERICcolumn declared without a precision isNUMERIC(37, 15)in Vertica, so it maps toDecimal(37, 15). - Columns of any other type, such as
LONG VARCHAR,TIME,TIMETZ,INTERVAL,UUID,ARRAY,SET,ROWorMAP, are not supported. They are listed in Schema Builder, but you cannot add them to a node or edge as attributes.
If you need a data type that is not supported, or one that is not listed here, contact us.
Demo
See Querying Vertica Data as a Graph for a complete demo for Vertica. The demo includes setting up the connection to a Vertica instance.